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 Data page within Max where all connections are managed.

2. Initiate New Connection:

   • Click the + button in the bottom left of the connections left panel to start the process of creating a new connection.

3. Fill in Connection Details:

   • Connection Name: Enter a unique name for the connection to help identify it within Max.
   • Description (optional): Provide a brief description of what this connection will be used for.
   • Connection Type: Select Snowflake from the dropdown menu.

4. Database Details:

   • Host: Enter the hostname of your Snowflake instance (e.g., your-account-identifier.snowflakecomputing.com).
   • Database Name: Specify the name of the database in Snowflake to connect to.
   • Schema: Enter the target schema within the database that you want to query.
   • Port: Specify the port number if you are using a proxy server or if your Snowflake setup requires a specific port.

5. Authentication:

   • Database User: Provide the username that Max will use to access Snowflake.
   • Password: Enter the password associated with the database user.

6. Test and Create:

   • Click the Test Connection button to verify that Max can connect to Snowflake with the provided settings.
   • If the test is successful, click the Create button to finalize the connection.

Important Notes

• Ensure that all details, especially the host, database name, and authentication credentials, are entered correctly to avoid connectivity issues.
• Check that your Snowflake account has the necessary configurations to accept connections from Max, including firewall settings and network policies.
• AnswerRocket assumes that Snowflake tables and columns are uppercase only.

Establishing this connection allows Max to perform seamless data operations on your Snowflake data warehouse, enhancing data accessibility and analysis capabilities.