Closed alejobs closed 1 year ago
-- FOR INFERRING THE SCHEMA IN THE STAGE FILES select ','||column_name||' '||type|| '\n' from table ( infer_schema (location=>'@DEV.RAW_T2.USERS' , file_format=> '"DEV"."DEV_SCHEMA".PARQUET')) order by column_name;
Describe the feature
Currently we need to manually define all columns and data types coming from the external files. With this new feature we could auto-generate external tables schema by leveraging the infer_schema or generate_column_description in Snowflake: https://docs.snowflake.com/en/sql-reference/functions/generate_column_description.html