Qualia has your Snowflake permissions under the chosen role. To prevent writes, make that role read-only and list only it in
ALLOWED_ROLES_LIST.Prerequisites
- A Snowflake account where someone with
ACCOUNTADMINcan create a security integration. On a trial account you have it. In an enterprise account, ask whoever owns it. - A role for Qualia sessions. One role covers every sign-in.
- A warehouse that role can use.
- No network policy that blocks Qualia. Qualia Cloud can’t reach an account behind an IP allowlist, so connect from the desktop app instead.
ACCOUNTADMIN once. In Qualia Cloud, saving the connection also needs an organization admin in Qualia.
Required privileges
Each person who signs in needs these in Snowflake:Create the security integration
AnACCOUNTADMIN runs one statement by hand. Qualia Cloud and the desktop app each need their own integration.
- Qualia Cloud
- Desktop app
1
Copy the redirect URL
Open Settings > Integrations > Snowflake and click the copy button next to Redirect URL. Snowflake matches it character for character, so paste it rather than retyping it.
2
Create the integration
Run this in Snowflake, replacing the bracketed values:
3
Get the client ID and secret
Run
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('QUALIA_OAUTH'); and keep the client ID and secret for the next section.What the parameters do
ALLOWED_ROLES_LISTis the access bound. Snowflake blocks every role not on the list for this integration.PRE_AUTHORIZED_ROLES_LISTskips the consent screen for the listed roles. Snowflake supports it for confidential clients only, so the desktop integration leaves it out.OAUTH_ISSUE_REFRESH_TOKENSkeeps you signed in. AfterOAUTH_REFRESH_TOKEN_VALIDITYlapses, at most 90 days, everyone signs in again.IS_AGENTICmarks these sessions as agent access in your audit history.
OAUTH_USE_SECONDARY_ROLES to IMPLICIT, because that activates each user’s default secondary roles and bypasses ALLOWED_ROLES_LIST. Leave it unset so it keeps its default, NONE.
Connect Qualia
Snowflake settings have two steps. Step 1, Account points Qualia at your account and its security integration. Step 2, Your access is your personal sign-in, available once step 1 is saved.1
Open Snowflake settings
Go to Settings > Integrations > Snowflake.
2
Enter the account identifier
Enter the part of your Snowsight URL before
.snowflakecomputing.com in Account identifier. Both the [ORG]-[ACCOUNT] form and the legacy [LOCATOR].[REGION] form work.3
Paste the client credentials
Paste OAuth client ID. If you use Qualia Cloud, also paste OAuth client secret. The desktop app has no secret field.
4
Set the role and warehouse
Enter the Role you listed in
ALLOWED_ROLES_LIST, and optionally a Warehouse, Default database, and Default schema. The warehouse applies to queries that don’t name one.5
Save
Click Save connection.
- If you use Qualia Cloud, click Sign in with Snowflake under Your access and authorize. Each other member of your organization signs in the same way. The account configuration is shared, but each authorization is personal.
- If you use the desktop app, there is no sign-in button. Your first query opens the browser to sign in, and later queries and new kernels don’t ask again.
Changing the role, the account, or the OAuth client signs everyone out, so everyone must authorize again.
Query from a notebook
Ask the agent, or write the query yourself:Disconnect or remove the connection
- Disconnect under Your access (Qualia Cloud) revokes your own saved authorization. Other members stay connected.
- Remove under Remove connection deletes the account configuration. In Qualia Cloud it also removes every member’s authorization.

