Join Slack
Powered by
Are we able to use an incrementing ID as the curso...
# ask-community-for-troubleshooting
b
Blake Enyart
12/15/2021, 10:49 PM
Are we able to use an incrementing ID as the cursor for an incremental strategy for data ingestion on a database?
✅ 1
u
[DEPRECATED] Augustin Lafanechere
12/16/2021, 3:16 PM
Hi
@Blake Enyart
this might depend of the source connector you are using. Could you tell me which one you tried?
b
Blake Enyart
12/16/2021, 4:44 PM
I'm using the MS SQL source for this right now
Blake Enyart
12/16/2021, 4:44 PM
The most recent version
u
[DEPRECATED] Augustin Lafanechere
12/16/2021, 5:48 PM
Yes I'd give this a try. The incremental strategy is basically a
SELECT .. WHERE cursor > cursor_value
b
Blake Enyart
12/17/2021, 4:28 AM
Excellent! Thank you!
3
Views
Open in Slack
Previous
Next