https://linen.dev logo
#advice-data-ingestion
Title
# advice-data-ingestion
a

Amit Jain

09/27/2022, 5:31 PM
Hello Folks, I'm using Snowflake as a source and Postgresql as destination. Source: Snowflake 0.1.24 Destination: Postgresql 0.3.24 After the latest update on Snowflake driver getting following error:
Copy code
2022-09-27 17:19:14 - Additional Failure Information: io.airbyte.integrations.source.relationaldb.InvalidCursorException: The following tables have invalid columns selected as cursor, please select a column with a well-defined ordering as a cursor. {tableName='APPDATA_VIEWS.WV_ADDRESSES', cursorColumnName='ROW_LOADED_AT', cursorSqlType=TIMESTAMP_WITH_TIMEZONE},{tableName='APPDATA_VIEWS.WV_PRACTITIONERS', cursorColumnName='ROW_LOADED_AT', cursorSqlType=TIMESTAMP_WITH_TIMEZONE},{tableName='APPDATA_VIEWS.WV_RECOMMENDATIONS', cursorColumnName='ROW_LOADED_AT', cursorSqlType=TIMESTAMP_WITH_TIMEZONE},{tableName='APPDATA_VIEWS.WV_TREATMENT_PLAN_TEMPLATE_ITEMS', cursorColumnName='ROW_LOADED_AT', cursorSqlType=TIMESTAMP_WITH_TIMEZONE}
I think I was at Snowflake 0.1.17 when it was able to run with
ROW_LOADED_AT
column as cursor.
ROW_LOADED_AT
is timestamp datatype on Snowflake. Can you confirm if I can still make it work with same column.
4 Views