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

Currently, I'm working in an ETL that needs to migrate some tables from Snowflake to Postgres, anybody knows the best way to do that? (I'm using airflow to build the ETL)


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


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