6

Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don't have access to that bucket. And we only need to get the specific tables from Snowflake not the entire data.

chandra mouli
  • 53
  • 1
  • 3
  • Welcome to Stack Overflow. Please read about [asking questions](https://stackoverflow.com/help/asking). The use of the word "best" will cause some people to view this as an opinion based question which can get the question closed. – Jason Aller Oct 19 '19 at 20:55

3 Answers3

8

you will want the unloading into Amazon S3 documentation.

you can ether choose a table with the

copy into s3://mybucket/unload/
  from mytable
  storage_integration = myint
  file_format = (format_name = my_csv_format);

or choose from a select, which is mostly how I export data.

copy into @my_stage
from (
    select * from orderstiny limit 5
);

again the COPY INTO doc's are helpful here.

Simeon Pilgrim
  • 22,906
  • 3
  • 32
  • 45
1

You can use COPY INTO command for both data load as well as data unload from source to destination.

Dharman
  • 30,962
  • 25
  • 85
  • 135
Sriga
  • 1,165
  • 4
  • 11
0

You can follow one of the options. The option1 is the most secure of them. If it is for internal or inside vpc communication then option3 could the easier one.

Ameya Bapat
  • 1
  • 1
    Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Apr 21 '22 at 11:24
  • Welcome in stackoverflow @ameya-bapat ! Please, describe briefly the recommended option here in your answer. If the hyperlink will not work in the future, then your answer will be useless without additional info. – eNca Apr 25 '22 at 11:09