0

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).

Vishrant
  • 15,456
  • 11
  • 71
  • 120

2 Answers2

0

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.

Greg Pavlik
  • 10,089
  • 2
  • 12
  • 29
  • thanks Greg for the response, can you please answer the second part of the question, can I export to s3 bucket with a uniform filetype (parquet) – Vishrant Jun 10 '20 at 20:16
  • Yes, you can. Snowflake supports exporting COPY INTO as JSON, parquet, or CSV. – Greg Pavlik Jun 10 '20 at 20:30
0

is it not possible to use multiple file format in one copy command only.

I am having gzip, bz2, deflate formatted files in one s3 stage, so while loading these al file formats , how to use multiple file format in copy command or do we have option to specify multiple compression type while creating file format.

Priya Chauhan
  • 445
  • 1
  • 5
  • 21