Hello! Trying out airbyte to sync postgres data to...
# ask-community-for-troubleshooting
r
Hello! Trying out airbyte to sync postgres data to snowflake, It works for the Full syncs of data, but i can't seem to find the incremental options, Postgres 13.7 -> snowflake postgres source -> 1.0.10 snowflake dest -> 0.4.36 airbyte -> 0.40.7 all the tables have:
updated_at
fields to use as cursor but no option to select them. Previous was processing the same data through stitch so i'd think it would be possible.
I saw:
Copy code
Some sources cannot define the cursor without user input. For example, in the postgres source, the user needs to choose which column in a database table they want to use as the cursor field. In these cases, select the column in the sync settings dropdown that should be used as the cursor field.
I also see the supported types: https://docs.airbyte.com/integrations/sources/postgres/#supported-cursors and can see some supported type in each table....
the option appears when i select all tables but with no option for cursor
m
Are you using CDC mode?
r
no just normal, sorry for the double post