This article describes how to integrate Databricks to create datasets.

Supports connecting to Databricks data sources to create datasets. Data connections support direct connection or offline extraction of Databricks data sources.

The following steps are required to obtain the necessary connection information:

1. Log in to your Databricks workspace and go to the Data Science & Engineering or Databricks Machine Learning environment.
   
2. To change roles, click the icon below the Databricks logo.
   
3. Click the "Compute" tab in the sidebar.
   
4. Select the cluster to connect to and click to enter.

5. Click "Advanced Options".
   
6. Obtain the JDBC connection string. Click the JDBC/ODBC tab and copy the JDBC URL for use in subsequent connections.
   
7. Obtain the password. Click "User Settings" and then click "Generate new token" to generate a token.

1. Go to BytePlus, enter a specific project, click Data Preparation, find Data Connection in the dropdown list, and click Data Connection.

   

2. Select Databricks on the page.

3. Fill in the required basic information, test the connection, and click Save after a successful connection.
   

   • Configuration instructions for SaaS version connection method are as follows:

     Parameters	Configuration description
     Data connection name	Name for the new data connection, used to distinguish between different database connections in the system. For example, Databricks_20250724110727. The name can be modified. Please enter a valid name. Only Chinese characters, English letters, numbers, and underscores are allowed. Leading and trailing spaces are not permitted.
     Connection method	IP/Port: Suitable for general scenarios. Click IP/Port to use this method. JDBC connection string: Suitable for scenarios where users need to add connection parameters. This is the default method. warning This method is recommended, as parameter retrieval is simpler.
     Server	The server hostname value of the Databricks compute resource, that is, server-hostname. For details, refer to the official Databricks documentation.
     JDBC connection string	JDBC connection string. For details, refer to Preparation.
     Username	The username created in the database engine. Enter "token" here.
     Password	The Databricks token. For details, refer to Preparation.
     httpPath	The HTTP path value of the Databricks compute resource. The connector constructs the HTTP address to connect to by appending the httpPath value to the host and port specified in the connection URL. For example, to connect to the HTTP address http://localhost:10002/cliservice, you can use the following connection URL: jdbc:databricks://localhost:10002;httpPath=cliservice.
     Database	Optional. The name of the database created in Databricks.

   • Configuration instructions for privatized version connection method are as follows:

     Parameters	Configuration description
     Data connection name	Name for the new data connection, used to distinguish between different database connections in the system. For example, Databricks_20250724110757. The name can be modified. Please enter a valid name. Only Chinese characters, English letters, numbers, and underscores are allowed. Leading and trailing spaces are not permitted.
     Connection method	IP/Port: Suitable for general scenarios. JDBC connection string: Suitable for scenarios where users need to add connection parameters. warning This method is recommended, as parameter retrieval is simpler.
     Server	The server hostname value of the Databricks compute resource, that is, server-hostname. For details, refer to the official Databricks documentation.
     JDBC connection string	JDBC connection string. For details, refer to Preparation.
     Username	The username created in the database engine. Enter "token" here.
     Password	The Databricks token value. For details, refer to Preparation.
     httpPath	The HTTP path value of the Databricks compute resource. The connector constructs the HTTP address to connect to by appending the httpPath value to the host and port specified in the connection URL. For example, to connect to the HTTP address http://localhost:10002/cliservice, you can use the following connection URL: jdbc:databricks://localhost:10002;httpPath=cliservice. For details, refer to the Databricks official documentation.
     Database	Optional. The name of the database created in Databricks.

1. Go to BytePlus, click Data Preparation --> Dataset, and select the "New" button in the upper left corner to create a new dataset.

   

2. When selecting a data connection, click New Configuration.

   

3. The subsequent steps are the same as steps 2 and 3 of Create from data connection above. After completing the configuration, you will remain in the pop-up window for selecting a data connection for the dataset, and you can proceed directly to the next step of dataset creation.

1. Use the previously created data connection to create a dataset: Click Data Preparation --> Dataset, and select the "New" button in the upper left corner to create a new dataset.

   

2. Search for or select from the dropdown the previously created data connection.

   

If a 403 error occurs during connection testing, first check whether the username and password are entered correctly. If they are correct, try adding an allowlist on the Databricks side to resolve the issue. The public IP accessed by "DataWind" can be viewed at Data Connections Overview.