Skip to content

Add data to Registry

When ingesting data through the Data Registry, DataRobot completes EDA1 (for materialized, or static assets) as part of the registration process and saves the results to reuse later.

To add data from the Data Registry, click the Add data dropdown and select one of the following methods:

Method Description
Data connection Add data from an existing data connection or configure and add data from a new one.
Local file Browse and upload a file from your local file system.
URL Adds a snapshot of the full dataset specified in the URL.

You can also upload calendar files for time series experiments using any of the above methods.

Dataset formatting

To avoid introducing unexpected line breaks or incorrectly separated fields during data import, if a dataset includes non-numeric data containing special characters—such as newlines, carriage returns, double quotes, commas, or other field separators—ensure that those instances of non-numeric data are wrapped in quotes ("). Properly quoting non-numeric data is particularly important when the preview feature "Enable Minimal CSV Quoting" is enabled.

Data connection

Configuring a data connection—to either a native connector or JDBC driver—allows you to interactively explore, preview, and profile live data before bringing it into DataRobot. Once defined, you can reuse these connections and credentials to securely add data in the future.

For important additional information, see:

In Registry, you can connect to and add data from a data connection by clicking Add data > Data connection. From here, you can:

  Element Description
1 + Add connection Allows you to add and configure a new data connection.
2 List of connections Lists all data connections associated with your DataRobot account.
3 Connection actions While hovering over a data connection, you can access the following actions:
  • Edit: Opens the configuration options for the data connection.
  • Clone: Makes a copy of the connection, including the configuration parameters and credentials.
  • Share: Allows you to share the data connection with other users, groups, or organizations, as well as assign permissions.
  • Delete: Deletes the data connection.
4 Add from SQL query Allows you to use SQL queries to add data.
5 Cancel / Add to registry To exit the modal without adding data, click Cancel. Once you've selected at least one data asset, the Add to registry button is enabled.

Local file

This method of adding data is a good approach if your dataset is already ready for modeling.

Before you proceed, review DataRobot's dataset requirements for accepted file formats and size guidelines. See the associated considerations for important additional information.

After selecting Local file from the Add data dropdown, locate and select your dataset in the file explorer. Then, click Open.

Supported file types

The following file types are supported for upload: .csv, .tsv, .dsv, .xls, .xlsx, .sas7bdat, .geojson, .gz, .bz2, .tar, .tgz, .zip.

URL

You can use a local, HTTP, HTTPS, Google Cloud Storage, Azure Blob Storage, or S3 (URL must use HTTP) URL to import your data. To use a local file, specify the URL as follows: file:///local/file/location.

After selecting URL from the Add data dropdown, enter the URL in the field and click Save.

Note

When importing a data using a URL, DataRobot registers a snapshot of the full dataset.

Calendars for time series

Calendars for time series experiments can be uploaded directly to the Data Registry using any of the upload methods. Calendars uploaded as a local file are automatically added to the Data Registry, where they can then be shared and downloaded.

Next steps

From here you can: