downloading data from snowflake. full refresh wor...
# ask-community-for-troubleshootingr
Ramesh Shanmugam
11/10/2022, 10:31 PMdownloading data from snowflake. full refresh works. but incremental sync with timestamp not working. any idea why if fails?
Copy code
internalMessage" : "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='tmp.test', cursorColumnName='LAST_MODIFIED_DATE', cursorSqlType=TIMESTAMP_WITH_TIMEZONE}",Ramesh Shanmugam
11/10/2022, 11:22 PMhttps://github.com/airbytehq/airbyte/blob/f91799ba09f320c6017e9985c92e8bd15eafed43/airbyte-db/db-lib/src/main/java/io/airbyte/db/jdbc/JdbcUtils.java#L57 -- any reason TIMESTAMP_WITH_TIMEZONE not supported?
n
Nataly Merezhuk (Airbyte)
11/14/2022, 3:27 PMI am not aware of a reason; I'd advise you open a GitHub issue for this - that seems like the best course of action!