# Data connections
URL: https://docs.datarobot.com/en/docs/workbench/nxt-workbench/dataprep/add-data/connect.html

> Connect to an external data source to seamlessly browse, preview, and profile data, as well as initiate scalable data preparation for machine learning with push-down.

# Data connections

In Workbench, you can easily configure and reuse secure connections to predefined data sources, allowing you to interactively browse, preview, and profile your data before using DataRobot's integrated [data preparation capabilities](https://docs.datarobot.com/en/docs/workbench/nxt-workbench/dataprep/wrangle-data/index.html).

See the associated [considerations](https://docs.datarobot.com/en/docs/workbench/nxt-workbench/dataprep/data-faq/index.html#add-data) for important additional information.

> [!WARNING] Source IP addresses for allowing
> Before setting up a data connection, make sure the [source IPs](https://docs.datarobot.com/en/docs/reference/data-ref/allowed-ips.html) have been allowed.

## Connect to a data source

Creating a data connection lets you explore external source data—from both connectors and JDBC drivers—and then add it to your Use Case. The Browse data modal only lists connections that support structured data.

To create a data connection:

1. From theData assetstile, clickAdd data > Browse datain the upper-right corner, opening theBrowse datamodal.
2. Click+ Add connection.
3. Choose eitherStructuredfor connections that support adding structured data, orUnstructuredfor connections that support unstructured data (only available during VDB creation). Then, select a data store. Now, you canconfigure the data connection.

### Configure the connection

> [!NOTE] Note
> When configuring your data connection, configuration types, authentication options, and required parameters are based on the selected data source. The example below shows how to configure Snowflake with OAuth using new credentials.

To configure the data connection:

1. With theConnection Configurationtab selected in theEdit Connectionmodal, choose a configuration method—eitherParametersorJDBC URL.
2. Enter the required parameters for the selected configuration method.
3. ClickNew Credentialsand select an authentication method—the available authentication methods are based on the selected connection. Saved credentialsIf you previouslysaved credentials for the selected data source, clickSaved credentialsand select the appropriate credentials from the dropdown.
4. ClickSavein the upper right corner. If your browser window is small, you may need to scroll up. If you selected OAuth as your authentication method, you will be prompted to sign in before you canselect a dataset. See the list ofsupported data storesfor more information about supported authentication methods and required parameters.

### Select a dataset

Once you've set up a data connection, you can add datasets by browsing the [database schemas](https://www.ibm.com/topics/database-schema) and tables you have access to.

To select a dataset:

1. Select the schema associated with the table you want to add.
2. Select the box to the left of the appropriate table. With a dataset selected, you can: ElementDescription1Add to Use CaseAdds the data asset to your Use Case, making it available to you and other team members.2Add from SQL queryAllows you to use SQL queries to add data.3SettingsAllows you to show, hide, and/or pin columns.4Actions menuProvides access to the following actions:Preview: Open a snapshot preview to help determine if the dataset is relevant to your Use Case and/or if it needs to be modified in either Wrangler or the SQL Editor.Open in Wrangler: Perform data preparation before adding the asset to your Use Case.Open in SQL Editor: Create a recipe comprised of SQL queries that enrich, transform, shape, and blend datasets together. Large datasetsIf you want to decrease the size of the dataset before adding it to your Use Case, click Wrangle. When you publish a recipe, you canconfigure automatic downsamplingto control the number of rows when Snowflake materializes the output dataset.
3. ClickAdd to Use Case, and then choose a snapshot policy by adding either dynamic data (Add as dynamic dataset) or a snapshot of the dataset (Add as snapshot). To go back without adding data, clickContinue browsing.

## Edit a connection

To modify an existing  data connection from the Browse data modal, hover over the connection and click the edit icon. For more information, see [Edit a connection](https://docs.datarobot.com/en/docs/platform/acct-settings/nxt-data-connect.html#edit-a-connection). From this modal, you can also [delete a connection](https://docs.datarobot.com/en/docs/platform/acct-settings/nxt-data-connect.html#delete-a-connection).

## Connection support for Wrangling and SQL Editor

You can connect to and add data from all connectors and JDBC drivers that are currently supported in DataRobot. For a full list of supported data stores, see [Supported data stores](https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/index.html).

Note that Snowflake, BigQuery, and Databricks connections use pushdown wrangling—all other connections use Spark wrangling.

The table below highlights the capabilities supported by each wrangling method:

| Wrangling method | Snapshot datasets | Dynamic datasets | Live preview | Wrangling | In-source materialization |
| --- | --- | --- | --- | --- | --- |
| Pushdown wrangling: Snowflake, BigQuery, Databricks |  | ✔ | ✔ | ✔ | ✔ |
| Spark wrangling: snapshots uploaded from local files, public URLs, all supported connections | ✔ |  |  | ✔ |  |

> [!NOTE] JDBC driver capabilities
> You can only add snapshot datasets from a JDBC driver connection.

---
