To integrate Max with Databricks, establishing a connection allows Max to access and interact with data hosted on Databricks. Here’s how to set up a new Databricks 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 Databricks from the dropdown menu.

4. Connection and Database Details:

   • Connection URL: Enter the URL for your Databricks instance.
   • Database Name: Specify the name of the database in Databricks to which Max should connect.
   • Database Schema: Enter the target schema within the database that you want to query.

5. Authentication:

   • Password: Enter the password needed to access your Databricks data.

6. Test and Create:

   • Click the Test Connection button to verify that Max can connect to Databricks 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 Connection URL, database name, and password, are entered correctly to avoid connectivity issues.
• Verify that the Databricks instance is configured to accept connections from Max.

Setting up this connection allows Max to perform data operations directly on your Databricks datasets, enabling robust data analysis and integration.