This section describes how you interact through the  with your Azure Databricks Tables data.

NOTE: Use of Azure Databricks Tables requires installation on Azure, integration with Azure Databricks, and an Azure Databricks connection. For more information, see Configure for Azure Databricks.


Uses of Databricks Tables

The  can use Databricks Tables for the following tasks:

  1. Create datasets by reading from Databricks Tables tables.
  2. Write data to Databricks Tables.
Table TypeSupportNotes
Databricks managed tablesRead/Write
Delta tablesRead/Write

NOTE: Versioning and rollback of Delta tables is not supported within the . The latest version is always used. You must use external tools to manage versioning and rollback.

External tables

Read/Write

NOTE: When writing to an external table the TRUNCATE and DROP publishing actions are not supported.

Databricks unmanaged tablesRead/Write

Delta Tables (managed and unmanaged tables)

Read/Write
Partitioned tablesRead

The underlying format for Databricks Tables is Parquet.

Limitations

Before You Begin Using Databricks Tables

Storing Data in Databricks Tables

NOTE: The does not modify source data in Databricks Tables. Datasets sourced from Databricks Tables are read without modification from their source locations.

Reading from Databricks Tables

You can create a  from a table or view stored in Databricks Tables.

For more information on how data types are imported from Databricks Tables, see Databricks Tables Data Type Conversions.

Writing to Databricks Tables

You can write data back to Databricks Tables using one of the following methods:

Ad-hoc Publishing to Databricks Tables

Not supported.