Heylo peeps! I’m facing this at the moment which looks like an error on the compiler while running the queries: I’m currently running

target_snowflake:

2023-04-12T09:30:34.335617Z [info     ]     raise error_class(         cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2023-04-12T09:30:34.335782Z [info     ] snowflake.connector.errors.ProgrammingError: 001003 (42000): SQL compilation error: cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2023-04-12T09:30:34.335947Z [info     ] syntax error line 1 at position 59 unexpected ')'. cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake

This is the query that is trying to run:

CREATE TABLE IF NOT EXISTS pendo_test."PREP_PENDO_GUIDES" () data_retention_time_in_days = 1

This looks like a parsing error or i am missing something?

@guilherme_petris hmm thats weird 🤔 . What target variant are you using? What tap are you using? What does the tap output look like if you ran

meltano invoke tap-x > output_file.json

? I'm wondering if this is an issue with the data coming out of the tap, its almost like the tap is sending an empty schema to the target because usually the

()

would be populated with the column names. If the tap data looks good then its possible that the target has a bug with parsing the schema for some reason but I've never heard of this happening so your tap data might be unusual.

Just saw, apparently a select was missing a . which selected the schema but not the columns