Blank double quoted fields in CSVs treated as varchar instead of null in Snowflake External Tables #132
Closed
1 of 3 tasks
Labels
bug
Something isn't working
Describe the bug
After we upgraded to dbt v1.0.0, we started having errors selecting from Snowflake External Tables.
This was due to the CSV files in S3 containing blank double quoted values, e.g.
""
.Snowflake was storing these as text as opposed to null, leading to cast type errors.
Steps to reproduce
Expected results
Blank fields cast to data type as expected and Snowflake query returns result set.
Actual results
Snowflake fails to cast to data type and throws an error.
Screenshots and log output
System information
The contents of your
packages.yml
file:Which database are you using dbt with?
The output of
dbt --version
:The operating system you're using:
MacOS Monterey 12.1
The output of
python --version
:3.9.9
Additional context
PR created with fix
#131
The text was updated successfully, but these errors were encountered: