Load data using the add data UI

Important

This feature is in Public Preview.

The add data UI allows you to easily load data into Azure Databricks from a variety of sources. To access the UI, click New Icon New > Add data.

How do I add data to Azure Databricks?

There are multiple ways to load data using the add data UI:

  • Load data from cloud object storage using Unity Catalog external locations. For more information, see Load data using a Unity Catalog external location.
  • Select Create or modify table to load CSV, TSV, JSON, XML, Avro, Parquet, or text files into Delta Lake tables.
  • Select Upload files to volume to upload files in any format to a Unity Catalog volume, including structured, semi-structured, and unstructured data. For semi-structured or structured files, you can use Auto Loader or COPY INTO to create tables starting from the files. You can also run various machine learning and data science workloads on files uploaded to a volume. See Upload files to a Unity Catalog volume.
  • Select DBFS to use the legacy DBFS file upload.
  • Other icons launch sample notebooks to configure connections to many data sources.

See Connect to data sources.

Add data with Partner Connect

The Databricks Partner Connect program provides integrations maintained by independent software vendors to easily connect to most enterprise data systems. You can configure these connections through the add data UI using the following instructions:

Note

You must be an Azure Databricks workspace admin to create the connection to Fivetran. If the connection exists, a Fivetran Account Administrator must add you to the account.