SnowSQL

Summary

We will configure SnowSQL to connect with a Flow address on Sundeck.

Pre-requisites

You’ll need the following before configuring SnowSQL to use Sundeck:

Install SnowSQL, according to the instructions in Snowflake’s documentation.
Your Snowflake connection details like user credentials, the account locator, and database.

Step-by-Step Configuration

First, log into the Sundeck Web UI, and navigate to the Flows page (using the left-hand menu):

Copy the address of the Sundeck Flow to which you wish to connect. This can be done easily by using the “Copy to Clipboard” button next to the desired Flow Address:

To configure SnowSQL to connect to a Flow address on Sundeck, simply specify the connection parameter for host address, in addition to parameters you use when start SnowSQL cli. This can be done by passing the Sundeck flow address with the SnowSQL Host parameter (-h <sundeck-flow-address or --host <sundeck-flow-address>):

Once connected to Sundeck, you can run Sundeck DDL statements (i.e. SHOW FLOWS, CREATE OR REPLACE FLOW), in addition to any valid Snowflake SQL statements:

That’s it! You’re now ready to use SnowSQL to connect to Sundeck.