Snowflake table

Question

how can we create table in snowflake without running create table query, directly our snowpipe will detect data format and will create a table for us.

Answer for my query related to snowflake

I don’t believe you can, why do you believe this is possible? — NickW, Mar 17 '23 at 09:17
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. — Community, Mar 17 '23 at 13:00

score 1 · Answer 1 · answered Mar 17 '23 at 09:55

This is not possible automatically as of today.

There is a possibility to create a table for semi-structured data by using a template and inferring the file schema (this feature is currently limited to Apache Parquet, Apache Avro, and ORC files), like this example:

CREATE TABLE mytable
  USING TEMPLATE (
    SELECT ARRAY_AGG(OBJECT_CONSTRUCT(*))
    WITHIN GROUP (ORDER BY ORDER_ID)
      FROM TABLE(
        INFER_SCHEMA(
          LOCATION=>'@mystage',
          FILE_FORMAT=>'my_parquet_format'
        )
      ));

For more information have a look at the CREATE TABLE syntax and INFER_SCHEMA function.

Snowflake table

1 Answers1