Collaborate with your team
When connecting SQL client tools to Sundeck flows, Sundeck simply passes the user’s credentials to Snowflake. Snowflake handles authentication of SQL clients, and queries submitted to Sundeck flows are executed as the user who connected to the flow.
This means that your team members can use any SQL client tool to connect to Sundeck flows without any additional grants/privileges in Sundeck.
Sundeck admin users can connect to a Sundeck flow with any SQL client and execute Sundeck DDL statements, such as
CREATE OR REPLACE FLOW,
SHOW FLOWS, etc. Please see the “Admin Grants” section below for more details.
You can use the same credentials (email and password, or Google SSO) that you provided during signup to login to the Sundeck UI, and will have full permissions to view and modify Flows.
If you wish to collaborate with one or more additional users on the Sundeck UI, please follow these steps :
- Enable Snowflake SSO for your Sundeck account. This will allow users to log in to the Sundeck UI with their Snowflake credentials.
- Grant admin privileges to the additional users (using their Snowflake username). Please see the “Admin Grants” section below for more details.
- Share the Sundeck account URL with the new admins.
Sundeck admins have the following additional privileges:
- They can login to Sundeck UI and view/modify flows
- They can connect to a Sundeck Flow with any SQL client and execute Sundeck DDL
To grant admin privileges to a user with the Snowflake username FOO, execute the following statement:
GRANT SUNDECK ROLE ADMIN TO USER FOO;
To revoke admin privileges from a user with the Snowflake username FOO, execute the following statement:
REVOKE SUNDECK ROLE ADMIN FROM USER FOO;
The same can also be done in the Sundeck UI, by navigating to the
Account Settings page and clicking on the
Grant Role to User button in the