Columns split between float and int (e.g. SALES_FL and SALES_IT) in snowflake

[jtalmi]

The script is putting numbers it assumes are floats into one column and integers into another column for the same source column in gsheets.

For example, I have a SALES column with numbers like 0.5, 1.2, and occasionally 0.

The script is creating two columns, SALES_FL and SALES_IT, where the SALES_FL has values 0.5, 1.2 while the SALES_IT has the 0 values.

How can i ensure that columns will not be split up based on inferred data type (i.e. the 0s in float columns are translated into 0.00)?

[bob-blake]

+1 on this issue, I'm having the same issue with columns which have a mix of text and numbers stored as text - each one gets split into to columns in the db table, one for the data it interprets as VARCHARs and one for the BIGINTs. Would be great to have some control over this.

[nelsonauner]

We've had success with this in two ways:

1. Force character typing within google sheets
2. Use DBT to put the columns back together again