CODEWITHSUNDEEP
exportexport-to-csvexport-to-excelsnowflake-cloud-data-platform
Sahil Gupta
Sahil Gupta

Reputation: 105

how to export all the records of a table from snowflake?

I need to export the data of a table in Snowflake into excel or csv file. Can I directly get the data into my local machine without any staging like S3 bucket or similar?

Upvotes: 3

Views: 13354

Answers (3)

doyouevendata
doyouevendata

Reputation: 179

If it's small enough that you don't mind the single stream download, you could write a little program to make this happen. Like a little python utility that leverages the snowflake connector to run your query and turn the data into a local csv.

Upvotes: 0

peterb
peterb

Reputation: 727

You can export up to 1M rows directly into excel with the Snowflake ODBC connector: 1) install ODBC driver 2) configure driver with snowflake creds 3) open excel and go to data->get data-> other sources - > odbc

Upvotes: 0

Mike Walton
Mike Walton

Reputation: 7369

If your table is too big to query in the UI and download the results to a CSV or Tab-delimited file, then you'll need to leverage COPY INTO {location} as your Snowflake-native solution to get data out. You can leverage Snowflake's internal staging, if you don't have your own S3 bucket and then leverage SnowSQL to "GET" the file from internal stage to your local machine.

For more information, https://docs.snowflake.net/manuals/user-guide/intro-summary-unloading.html

Upvotes: 3

Related Questions