Snowflake

Setting up a Snowflake connection in Max enables users to interact with data stored in Snowflake, supporting data analysis and decision-making processes. Follow these steps to establish a new Snowflake connection:

Step-by-Step Guide

1. Navigate to the Data Page
   Access the Connections page within Max where all connections are managed.

2. Initiate New Connection
   Click the + button

3. Fill in Connection Details

   • Connection Name: A unique name for identifying the connection.
   • Description (optional): Briefly describe the connection’s purpose.
   • Connection Type: Select Snowflake from the dropdown.

4. Database Details

   • Host: The Snowflake host URL (e.g., your-account.snowflakecomputing.com).
   • Database Name: Name of the database to connect to.
   • Schema: Schema to use within the database.
   • Port: Optional. Provide if your Snowflake setup requires a specific port (typically not needed).

5. Authentication
   Max supports two authentication methods:

   • Username & Password (Legacy)

     • Database User: Your Snowflake username.
     • Password: Your Snowflake password.

   • Key Pair Authentication

     • Database User: Your Snowflake username.
     • Private Key: Paste your private key used to authenticate against Snowflake.
     • This method is more secure and recommended for enterprise use.

6. Test and Create

   • Click Test Connection to verify connectivity.
   • If successful, click Create to save the connection.

Important Notes

• Ensure the host, database name, and authentication method are correctly configured.
• The Key Pair method requires the corresponding public key to be registered with the Snowflake user.
• Snowflake identifiers (e.g., tables, columns) are expected to be in uppercase.
• Verify that network and firewall policies allow Max to access your Snowflake instance.

Connecting Max to Snowflake enables powerful natural language-driven data exploration and analysis directly on your Snowflake warehouse.