![]() Expand the target database (schema), if one exists for your connection.Double-click or expand the target connection for your warehouse.Right-click the connection, and click Edit Connection.In the Connections pane, expand the connection group, if one exists for your target connection.If the SQLTools view is not visible, then in Visual Studio Code, on the sidebar, click the SQLTools icon.This procedure assumes that you have successfully connected to at least one warehouse. If the connection test succeeds, click Save Connection.(Optional) For Show records default limit, leave the default of 50 to show only up to the first 50 rows for each query, or enter a different limit. If you selected Hostname and Token for Connect using, then for Token, enter your Azure Databricks personal access token value.įor Catalog, enter the name of your catalog.įor workspaces that are not enabled for Unity Catalog, you can leave Catalog blank to use the default value of hive_metastore.įor Schema, enter the name of your schema. To get a warehouse’s HTTP path setting, see Get connection details for a SQL warehouse. To get a warehouse’s Server hostname setting, see Get connection details for a SQL warehouse.įor Path, enter the warehouse’s or cluster’s HTTP path setting. If you selected Hostname and Token for Connect using, then for Host, enter the warehouse’s Server hostname setting. To use the Azure CLI for authentication, select VS Code extension (beta).To use an Azure Databricks personal access token for authentication, select Hostname and Token.Connection groups make it easier to find connections in the extension.įor version 0.4.0 and higher of the Databricks Driver for SQLTools, for Connect using, select one of the following: ![]() Or, enter a unique name to create a new connection group with the new connection. (Optional) For Connection group enter the name of an existing connection group to add the new connection to that group. For the Connection Settings step, enter the following information about your warehouse, catalog, and schema:įor Connection name, enter some unique name for this connection.On the SQLTools Settings tab, for the Select a database driver step, click the Databricks icon.Otherwise, click the Add New Connection icon in the pane’s title bar. ![]() In the SQLTools view, if this is your first time using the SQLTools extension, click Add New Connection within the Connections pane.In Visual Studio Code, on the sidebar, click the SQLTools icon.Click the Databricks Driver for SQLTools entry.In the Search Extensions in Marketplace box, enter Databricks Driver for SQLTools.In Visual Studio Code, click View > Extensions on the main menu.To install the Databricks Driver for SQLTools extension, go to Databricks Driver for SQLTools and then click Install, or: Be sure to click the entry from Matheus Teixeira. There might be multiple SQLTools entries listed. In the Search Extensions in Marketplace box, enter SQLTools.Ĭlick the SQLTools entry from Matheus Teixeira. In Visual Studio Code, click View > Extensions on the main menu. To install the SQLTools extension, go to SQLTools and then click Install, or: The Databricks Driver for SQLTools extension for Visual Studio Code.The SQLTools extension for Visual Studio Code.To download, install, and configure Visual Studio Code, see Setting up Visual Studio Code. To view your installed version, click Code > About Visual Studio Code from the manin menu on Linux or macOS and Help > About on Windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |