Setup Snowflake
Learn how to securely connect Julius to your Snowflake data warehouse using the authentication method that fits your organization.
What is Snowflake?
Snowflake is a cloud-based data platform that provides data warehousing, analytics, and secure data sharing. It supports multiple authentication methods for flexible and secure access.
Snowflake Connection Requirements
To connect Julius to your Snowflake account, you’ll need:
- A Snowflake account with the necessary permissions
- The connection details and credentials for your chosen authentication mode
Choose the authentication mode that matches your organization’s security policy. If unsure, ask your Snowflake administrator.
Connecting Julius to Snowflake
- Go to your Julius Data Connectors Settings
- Click Create new Data Connector
- Select Snowflake from the available options
Configure Connection Details
You’ll see a form with the following fields:
Fields marked with an asterisk (*) are required to establish a connection.
- What it is: A friendly name to identify this Snowflake connection
- Example: “Production Warehouse” or “Marketing Analytics”
- What it is: Your individually assigned Snowflake username
- What it is: The password for your Snowflake account
- What it is: Your company-wide Snowflake account identifier
- What it is: The particular database name you want to connect to within snowflake
- What it is: Multi-Factor Authentication type if required
- What it is: The Snowflake role to use (optional)
- 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
Configure Connection Details
You’ll see a form with the following fields:
Fields marked with an asterisk (*) are required to establish a connection.
- What it is: A friendly name to identify this Snowflake connection
- Example: “Production Warehouse” or “Marketing Analytics”
- What it is: Your individually assigned Snowflake username
- What it is: The password for your Snowflake account
- What it is: Your company-wide Snowflake account identifier
- What it is: The particular database name you want to connect to within snowflake
- What it is: Multi-Factor Authentication type if required
- What it is: The Snowflake role to use (optional)
- 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
Configure Connection Details
You’ll see a form with the following fields:
Fields marked with an asterisk (*) are required to establish a connection.
- What it is: A friendly name to identify this Snowflake connection
- What it is: Your programmatic access token for Snowflake
- What it is: Your Snowflake account identifier
- What it is: Your Snowflake username
- What it is: The database you want to connect to
- What it is: The Snowflake role to use (optional)
- 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
Configure Connection Details
You’ll see a form with the following fields:
Fields marked with an asterisk (*) are required to establish a connection.
- What it is: A friendly name to identify this Snowflake connection
- What it is: Your private key for authentication (PEM format)
- What it is: Your Snowflake account identifier
- What it is: Your Snowflake username
- What it is: The database you want to connect to
- What it is: The Snowflake role to use (optional)
- 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
Troubleshooting Common Issues
Authentication failed or invalid credentials
Authentication failed or invalid credentials
- 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
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
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
Security & Best Practices
- Use least-privilege credentials for your Snowflake connections
- Rotate credentials regularly and follow your organization’s security policies
- Monitor usage and audit access to your Snowflake account
If you need help with Snowflake connection setup, contact your Snowflake administrator or see the official documentation.