I have loaded a table in Snowflake using S3 load generator. I need to append to this table (files from S3 loads) based on a column match. If col1 exists in the table & file only then proceed with appending the data in target table. Please advise

Matillion ETL
1

I have loaded a table in Snowflake using S3 load generator. I need to append to this table (files from S3 loads) based on a column match. If col1 exists in the table & file only then proceed with appending the data in target table. Please advise.

2

First you can load the file to csv to temp table in snowflake then compare the data between information schema and tmp table based on this result you can proceed further.

3

Okay, thanks for your response. I'll check it out.