dbt-labs / dbt-external-tables

dbt macros to stage external sources
https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/
Apache License 2.0
298 stars 120 forks source link

Snowflake - Allow `PARSE_HEADER` to be used with `INFER_SCHEMA` for CSVs #284

Open b-per opened 5 months ago

b-per commented 5 months ago

Describe the feature

Allow the ability to get the CSV column names when using INFER_SCHEMA and CSVs

Describe alternatives you've considered

If you use INFER_SCHEMA and CSVs all the columns are called c1, c2 etc...

Additional context

The closed issue #254 mentions this Snowflake issue but I am wondering if this is really an issue in that case or not.

This might require a quick spike to test

Who will this benefit?

People wanting to load CSVs without listing every column