I’m seeing a lot of ingestion errors when i’m ingesting fivetran loaded snowflake tables:

SQL compilation error: syntax error line 1 at position 29 unexpected 'START'. syntax error line 1 at position 28 unexpected '('.

SELECT APPROX_COUNT_DISTINCT(START) 
FROM "SURVEYMONKEY"."FIVETRAN_AUDIT"

I believe the issue is that

START

is a column in

FIVETRAN_AUDIT

tables and

START

is also a reserved snowflake keyword. The solution at the query level is to wrap the reserved keyword in quotes

APPROX_COUNT_DISTINCT("START")

. Since datahub is executing these queries, should this be fixed within datahub? the tables themselves are fivetran-service tables so i believe there’s no ability to map/rename these columns. Has any1 else ran into this? I’m on the latest datahub via a helm/k8s deployment.

This is indeed an issue. Let me check and revert back with the solution.

thank you!

Should be fixed by this PR https://github.com/datahub-project/datahub/pull/6107

💯 thanks guys, @gray-shoe-75895 that looks like a good fix