Snowflake Free Desktop SQL Client

QStudio is a free SQL Client for Snowflake database that allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including Snowflake.

Setting up a Snowflake connection in QStudio

Start Snowflake

As an example of starting Snowflake:

1. Go to snowflake
2. Create a new project and database.

Get Connection Details

Click your account name at the bottom and then "Connect a tool".

Select the relvant details on the dropdowns and then copy the JDBC URL. Note the URL will not contain your password you will need to fill it in.

Create QStudio Connections

Connecting to a Server

When you first open QStudio click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

1. Server Type: Snowflake
2. Connect By: URL
3. URL: jdbc:snowflake://VJFETVB-PC04346.snowflakecomputing.com/?user=FLAKERSON&warehouse=COMPUTE_WH&db=USER$FLAKERSON&schema=PUBLIC&password=my_password
4. Username: USER
   Password: PASSWORD
5. Click Add

Note, I also had to complete the username and password boxes to get it to work. The first time you will also see a popup as QStudio has to download the driver.

Sending Queries

You can run queries by highlighting selected code and pressing :

Command	Shortcut
Run Current Statement	Ctrl + q
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

Create a Table

CREATE TABLE orders ( order_id INT IDENTITY (1, 1) PRIMARY KEY, customer_id INT NULL, order_status tinyint NOT NULL, -- Order status: 1 = Pending; 2 = Processing; 3 = Rejected; 4 = Completed order_date DATE NOT NULL, required_date DATE NOT NULL, shipped_date DATE, store_id INT NULL, staff_id INT NULL ); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(1,259,4,'2016-01-01','2016-01-03','2016-01-03',1,2); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(2,1212,4,'2016-01-01','2016-01-04','2016-01-03',2,6); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(3,523,4,'2016-01-02','2016-01-05','2016-01-03',2,7); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(4,175,4,'2016-01-03','2016-01-04','2016-01-05',1,3); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(5,1324,4,'2016-01-03','2016-01-06','2016-01-06',2,6); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(6,94,4,'2016-01-04','2016-01-07','2016-01-05',2,6); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(7,324,4,'2016-01-04','2016-01-07','2016-01-05',2,6); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(8,1204,4,'2016-01-04','2016-01-05','2016-01-05',2,7); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(9,60,4,'2016-01-05','2016-01-08','2016-01-08',1,2); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(10,442,4,'2016-01-05','2016-01-06','2016-01-06',2,6); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(11,1326,4,'2016-01-05','2016-01-08','2016-01-07',2,7); INSERT INTO orders(order_id, customer_id, order_status, order_date, required_date, shipped_date, store_id,staff_id) VALUES(12,91,4,'2016-01-06','2016-01-08','2016-01-09',1,2); SELECT * FROM orders;

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Notes:

1. You may get an error "Snowflake JDBC driver internal error: Fail to retrieve row count for first arrow chunk: null " which is due to this bug. Run this query to fix it:

   	ALTER SESSION SET JDBC_QUERY_RESULT_FORMAT='JSON';

2. You may only be able to run one query at a time.
3. You may have to restart QStudio after first adding the server to get the driver to load properly.

Well Done!

You have now got QStudio querying your database successfully.

We want to make QStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.