sqlexcelsnowflake-cloud-data-platform

How to write complex Snowflake SQL queries in Excel


I have installed ODBC driver for Snowflake on my Windows machine. I have also connected to Snowflake in Excel using the ODBC driver :

enter image description here

Now I want to write complex Snowflake SQL queries in Excel and generate results in Excel and save the Excel file and refresh the Excel file when there is new data loaded from the source Snowflake tables. Is there a way where I can copy paste the Snowflake SQL query into Excel, execute the query in Excel and generate the result?

Here is an example of a Snowflake SQL query:

select
    trim(RES) RES, trim(RES1)  RES1, trim(RES2)  RES2
from
    TEST123
where
    trim(RES) in ('TRER');

Solution

  • In Excel you can navigate to Data | Get Data | From Other Sources | From ODBC to retrieve data from any database (including Snowflake) using ODBC

    enter image description here