What it is: The Snowflake warehouse to use (optional)
Test and Save Connection
Click Add Connection to test the connection
Julius will validate your credentials and access
If successful, your connector will be saved and ready to use
If there’s an error, check the troubleshooting section below
Create Role and OAuth Integration in Snowflake
Run the following SQL line by line in Snowflake with the indicated roles:
Copy
Ask AI
-- create the role first (SECURITYADMIN)use role SECURITYADMIN;create role if not exists JULIUS_APP_ROLE;grant role JULIUS_APP_ROLE to user <YOUR_USER>;grant role JULIUS_APP_ROLE to role SYSADMIN;-- create/alter the integration (ACCOUNTADMIN)use role ACCOUNTADMIN;create or replace security integration JULIUS_OAUTH type = oauth enabled = true oauth_client = custom oauth_client_type = 'CONFIDENTIAL' oauth_redirect_uri = 'https://api.julius.ai/snowflake/oauth/callback' oauth_enforce_pkce = true oauth_issue_refresh_tokens = true oauth_refresh_token_validity = 7776000 oauth_client_rsa_public_key = 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApf4GJ3CNy6J4Dmw1rQPisPFrKyXNbsEKsHc38kdIWCscLJsroOUPsfAuynIYSIgvMgNIa/seVRm2Bld0ZFS2W5Mx24nn0lXnkuZQCqv2r6bytPlxw+VQHVV3L5PUVQXS0XF+3zQ1o/ty8RT2Cy0Z3JcI0L7kLMFwK/ouFClmSlRjtgmW/atap2R42RDwfd2JsIGa2LdUvzbmwq3c/P8KBQzUJDCtLR6bqY/447TGyRWhsDRlww7dXki32me65bBrwx21gWHoAYP1MEa+o35kzQ+6WwzwZZpG3abqfTSWrqkKj8lErLkD7imXXx3/F6KWSPcK5tJxt/b02c0GO1kYywIDAQAB' pre_authorized_roles_list = ('JULIUS_APP_ROLE');alter security integration JULIUS_OAUTH_DEV set blocked_roles_list = ('ACCOUNTADMIN','SECURITYADMIN','SYSADMIN','USERADMIN');describe integration JULIUS_OAUTH;
Test and Save Connection
Select the OAuth option in Julius and paste the output of the describe command above
Complete the OAuth consent screen when prompted
Julius will validate your access and save the connector
If there’s an error, check the troubleshooting section below
Double-check your username, password, access token, or private key - Ensure
your Snowflake account identifier is correct - Verify your user has permission
to access the specified database
Permission denied errors
Verify your user or role has the necessary privileges - Check if the
warehouse is running and accessible - Ensure the database and schema exist
Julius can't find my tables or data
Confirm your user has read permissions on the tables - Check that you’re
connected to the correct database and schema - Verify table names and schemas
are accessible to your user account
