Load data from multiple filetypes into same snowflake table?

Question

Can I use multiple file-formats with different filetype to load data into same snowflake table, I read this documentation, but it does not specify explicitly.

1. There are some files that I load from the external stage (s3) to snowflake that are in CSV format, but there is another data source for this table with a parquet file format.

2. The other requirement is to unload the whole data (CSV. + parquet) into an external stage (s3) that will follow single filetype (parquet).

Answer 1

Yes, you can do this. You can specify as many file formats and copy into statements for a table as you need. If you want, you can even separate the CSV and parquet files into different stages to help keep things neatly separated.