CODEWITHSUNDEEP
snowflake-cloud-data-platformsnowflake-schema
Cool-Dip
Cool-Dip

Reputation: 13

To check table schema change in snowflake

I have a table in snowflake, I am inserting data from AWS job. before inserting data in snowflake I want to check if the number of columns and the data type of the inserting values are same as the snowflake table.

Upvotes: 1

Views: 403

Answers (1)

ElenaG
ElenaG

Reputation: 96

What file type are you using? Snowflake recently implemented schema detection feature which allows to detect schema of the files in the stage. Note that this feature is currently limited to Apache Parquet, Apache Avro, and ORC files: https://docs.snowflake.com/en/user-guide/data-load-overview.html#detection-of-column-definitions-in-staged-semi-structured-data-files

Upvotes: 1

Related Questions