We will configure SnowSQL to connect with a Flow address on Sundeck.
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.
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
Once connected to Sundeck, you can run Sundeck DDL statements (i.e.
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.