How to download CSV from Snowflake?

Once you get the reader account details as shared by the RChilli Support team, you can download the taxonomy database from the snowflake account.

You can run an SQL query for each table of schema and download the CSV file.

Follow the below steps further: 

1. Create Warehouse:  Follow the below steps and create a warehouse.
   • Go to Admin> Warehouses on the navigation panel and click+ Warehouse. On the Warehouse pop-up, do the following:
     • Enter the name of the warehouse.
     • Enter the size of the warehouse.
     • Enter Comments as necessary.
     • Click Create Warehouse.
       
2. Click Worksheet on the navigation panel, and click+ Worksheet to run the SQL query on the taxonomy database.
   
3. If there is no warehouse selected for the worksheet, select a warehouse that is created in step-1 above.
   
4. On the No Database Selected drop-down, select the databases (that is shared with you) and the schema of the database.

     5. Enter the SQL query using the table name(see below sample query), and click Runicon to run the query.

In the above query, EDUCATION is the table name in the EDUCATION_DEGREE schema.

select * from EDUCATION

Note:

• Similarly, you have to run SQL query for all the tables of all the schema and download the table CSV file (a total of 39 tables CSV you can download). Refer to the below table for all queries to download all the tables of all the schema.
• Make sure before running SQL query for table CSV, you have selected the related database and Schema instep-4.

For further queries please refer to the link here or you can contact RChilli Support by creating a ticket at RChilli Helpdesk or simply by sending an email to support@rchilli.com.