https://linen.dev logo
#ask-community-for-troubleshooting
Title
# 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
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