Are there known issues with blanks in table names when using MS SQL Change Tracking Client

asked 2019-10-02 10:29:46 -0500

lutz.kuenneke gravatar image

Hi All,

i am using the Change Tracking Client to connect to a Microsoft SQL Database. When attempting to replicate all tables to Snowflake i run into an SQL compilation error saying: "Unexpected token 'AS'".

There are some tables in the schema with blanks in the name. Say "schema"."value entry". When filtering on tables that do not have blanks the pipeline works.

So my question is: Has anybody else observed this behaviour and is there a known solution? Renaming all tables is not really an option though.

Thank you

edit retag flag offensive close merge delete