Are we able to use an incrementing ID as the curso...
# ask-community-for-troubleshooting
b
Are we able to use an incrementing ID as the cursor for an incremental strategy for data ingestion on a database?
1
u
Hi @Blake Enyart this might depend of the source connector you are using. Could you tell me which one you tried?
b
I'm using the MS SQL source for this right now
The most recent version
u
Yes I'd give this a try. The incremental strategy is basically a
SELECT .. WHERE cursor > cursor_value
b
Excellent! Thank you!