How to create tables automatically based on the csv files feilds in snowflake
typescript
Ethan JacksonI ma having doubt regarding data loading in snowflake, I have uploaded the files into snowflake internal storage where all my foels were store in the . CSV. GZ formate, now how can i load the data to the table in new schema, but the thin6is the tabels should create automatically based on the csv file fields, not manually because i ma having bulk number of files. How can i achieve 3
Answer
Use the USING TEMPLATE and INFER_SCHEMA options. This example is in the documentation:
CREATE TABLE mytable
USING TEMPLATE (
SELECT ARRAY_AGG(OBJECT_CONSTRUCT(*))
FROM TABLE(
INFER_SCHEMA(
LOCATION=>'@mystage/json/',
FILE_FORMAT=>'my_json_format'
)
));