This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@fpinchon,@diganP Do you know how I can resolve this issue when using Data Stream In tool? I am getting a similar error message but there is no option available to run pre-create SQL. I have tried all 3 creation modes but always get the error:
Error: Data Stream In (6): DataWrap2ODBC::SendBatch: SQL compilation error:
Expression type does not match column data type, expecting TIMESTAMP_NTZ(9) but got TIMESTAMP_LTZ(9) for column....
I have found a workaround using the DateTime tool to convert each date and datetime field to a string. They are then read as varchar in Snowflake. It works, but is not scalable as these fields would need to be specified for each different table.