Data source error: DataSource.Error: <pii>ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.</pii>. DataSourceKind = <pii>Snowflake</pii>. DataSourcePath = <pii>g...
Hi glopreto ,
Please check if the following two options will help you with your problem
1. Run SHOW PARAMETERS LIKE 'ODBC_QUERY_RESULT_FORMAT'
- See if this option says value is "ARROW"
- If ARROW, run ALTER USER SET ODBC_QUERY_RESULT_FORMAT='JSON'
2. If that did not work, contact Snowflake support to set ODBC_TREAT_DECIMAL_AS_INT=false in the server properties.
Best Regards,
Community Support Team _ Caitlyn