Skip to main content

​
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:
  1. A Snowflake account with the necessary permissions
  2. 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

  1. Go to your Julius Data Connectors Settings
  2. Click Create new Data Connector
  3. Select Snowflake from the available options
  • Username / Password
  • Programmatic Access Token
  • Private Key Authentication

Configure Connection Details

You’ll see a form with the following fields:
Fields marked with an asterisk (*) are required to establish a connection.
​
Connection Name*
string
  • What it is: A friendly name to identify this Snowflake connection
  • Example: “Production Warehouse” or “Marketing Analytics”
​
User*
string
  • What it is: Your individually assigned Snowflake username
​
Password*
string
  • What it is: The password for your Snowflake account
​
Account*
string
  • What it is: Your company-wide Snowflake account identifier
​
DB*
string
  • What it is: The particular database name you want to connect to within snowflake
​
MFA_TYPE
string
  • What it is: Multi-Factor Authentication type if required
​
Role
string
  • What it is: The Snowflake role to use (optional)
​
Warehouse
string
  • What it is: The Snowflake warehouse to use (optional)

Test and Save Connection

  1. Click Add Connection to test the connection
  2. Julius will validate your credentials and access
  3. If successful, your connector will be saved and ready to use
  4. If there’s an error, check the troubleshooting section below

​
Troubleshooting Common Issues

  • 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
  • Verify your user or role has the necessary privileges
  • Check if the warehouse is running and accessible
  • Ensure the database and schema exist
  • 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.
Reach out to team@julius.ai for support or to ask questions not answered in our documentation.
⌘I