search

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
288 stars 116 forks source link

Q: When creating external tables with Parquet files on Redshift does the column order matter? #238

Open ian-lewis-d opened 8 months ago

ian-lewis-d commented 8 months ago

Hi,

I'm experimenting with creating external tables in Redshift based on Parquet files stored on S3.

It's not 100% clear to me whether the columns need to be listed, or if the order matters with Parquet files. There is a specific mention in the docs that column order only matters for CSV files.

Can anyone clarify this for me.

Many thanks. Ian Lewis

github-actions[bot] commented 2 months ago

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

dataders commented 2 months ago

what did you try? did you get an error?