what is the best way to export data from snowflake to postgres?

404

posted on 04 Nov 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Post Comment

nVector06-Nov-20

Use the COPY INTO <location> command to copy the data from the Snowflake database table into one or more files in a Snowflake or external stage.

You can then download the file from the stage using:

From a Snowflake stage, use the GET command to download the data file(s).
From S3, use the interfaces/tools provided by Amazon S3 to get the data file(s).
From Azure, use the interfaces/tools provided by Microsoft Azure to get the data file(s).

Checkout this Snowflake resource for more details