![]() 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. Review the license agreement for the Databricks ODBC driver before installing the software. This section presents the steps to configure your ODBC driver to connect to Azure Databricks. In the sidebar, click SQL > SQL Warehouses.Īlternatively, you can click the icon for one of the displayed technology partners or developer tools and follow the onscreen steps to connect using your SQL warehouse’s connection details. Log in to your Azure Databricks workspace. To retrieve connection details, do the following: To establish connections to many external data sources, developer tools, or technology partners, you must provide connection details for your SQL warehouse. Get connection details for a SQL warehouse Log in to your Azure Databricks workspace.To establish connections to many external data sources, developer tools, or technology partners, you must provide connection details for your cluster. This section explains how to retrieve the connection details that you need to connect to Azure Databricks. For instructions about how to refresh the token, see the ODBC driver installation guide (in the section Configuring Authentication on Windows > Providing a New Access Token) or the JDBC driver installation guide (in the section Configuring Authentication > Using OAuth 2.0). The access token can be refreshed programmatically for an existing session without breaking the connection by completing the steps in Refresh an Azure AD access token. The Azure Active Directory access token has a default lifetime of 1 hour.See how to get an Azure Active Directory access token. This method requires generating an Azure Active Directory access token. Azure Active Directory authentication is available in ODBC and JDBC drivers 2.6.15 and above.For instructions about how to generate a token, see Azure Databricks personal access tokens.The Databricks ODBC and JDBC drivers support authentication by using a personal access token or an Azure Active Directory token. The Databricks SQL warehouse automatically starts if it was stopped. To access a Databricks SQL warehouse, you need Can Use permission. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |