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

[ian-lewis-d]

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]]

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]

what did you try? did you get an error?