For tool or client specific connection instructions, see the Databricks integrations guide. Before you start, you need to make sure you have the appropriate permissions to connect to Azure Databricks, to prepare your credentials and to retrieve the connection details. There are two permissions you may need when you connect to a Azure Databricks cluster :. The Databricks SQL endpoint will be automatically started if it was stopped.
This section explains how to retrieve the connection details that you need to connect to Azure Databricks. Some tools and clients require you to install the Databricks ODBC driver to set up a connection to Azure Databricks, while others embed the driver and do not require separate installation.
After you download the appropriate installer of the driver for your platform, use the following instructions to install and configure the driver:.
Locate the odbc. Create another section with the same name as your DSN and specify the configuration parameters as key-value pairs. See the mandatory ODBC configuration and connection parameters for more information about how to set the configuration parameters. See also ODBC driver capabilities for more driver configurations. Here are some examples that show how to set up a DSN on different platforms based on your authentication method.
The location of the Databricks ODBC driver installation and configuration guide depends on your platform:. See the mandatory ODBC configuration and connection parameters for more information about how to set the configuration parameters.
See also ODBC driver capabilities for more driver configurations. Here are some examples that show how to set up a DSN on different platforms based on your authentication method. Set the content of the odbc. With that setting, the driver passes the SQL queries verbatim to Databricks. The location of the Databricks ODBC driver installation and configuration guide depends on your platform:. For more information about the JDBC driver, refer to the installation and configuration guide.
Find the Databricks JDBC driver installation and configuration guide in the docs directory of the driver package. Support Feedback Try Databricks. Help Center Documentation Knowledge Base. Updated Nov 21, Send us feedback. Requirements Before you start, you need to make sure you have the appropriate permissions to connect to Databricks, to prepare your credentials and to retrieve the connection details.
Permission requirements Authentication requirements Retrieve the connection details. Permission requirements There are two permissions you may need when you connect to a Databricks cluster : Can Attach To permission to connect to the running cluster. Can Restart permission to automatically trigger the cluster to start if its state is terminated when connecting. For instructions about how to generate a token, see Generate a personal access token. Username and password authentication is possible only if single sign-on is disabled.
Retrieve the connection details This section explains how to retrieve the connection details that you need to connect to Databricks. Get connection details for a cluster Get connection details for a SQL endpoint.
Get connection details for a cluster Click Compute in the sidebar. Choose a cluster to connect to. Navigate to Advanced Options.
0コメント