You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If you setup Incremental replication on a stream select a non datetime column as a Replcation Key if you have a start_date set in the meltano.yml then during the initial incremental run it will fail with a pyodbc conversion error.
start_date: '2022-01-03'
raw-tags:
replication-method: INCREMENTAL
replication-key: Id
sqlalchemy.exc.DataError: (pyodbc.DataError) ('22018', "[22018] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value '2022-01-03' to data type int. (245) (SQLExecDirectW)")
[SQL: SELECT raw.tags.[Id], raw.tags.[TagName], raw.tags.[Count], raw.tags.[ExcerptPostId], raw.tags.[WikiPostId]
FROM raw.tags
WHERE raw.tags.[Id] >= ? ORDER BY raw.tags.[Id]]
[parameters: ('2022-01-03',)]
The text was updated successfully, but these errors were encountered:
I tracked the issue down to _write_starting_replication_value. It doesn't check if the replication key col is of type timestamp before assigning the start_date. I guess it could also check that the replication key is not of type numeric or int.
If you setup Incremental replication on a stream select a non datetime column as a Replcation Key if you have a
start_date
set in themeltano.yml
then during the initial incremental run it will fail with a pyodbc conversion error.The text was updated successfully, but these errors were encountered: