AWS Databricks external tables are delta tables?

Akshay_Petkar
Valued Contributor

If I create an external table on AWS Databricks, will it be a Delta table? If not, is there a way to make it a Delta table, or is there no Delta capability for external tables?

Akshay Petkar

Vidhi_Khaitan
Databricks Employee
Databricks Employee

Hi Akshay,

I believe you can try this for your use case ->

CREATE TABLE IF NOT EXISTS catalog.schema.my_external_table (
id INT,
name STRING,
age INT
)
USING delta
LOCATION '<location>'

This will create a delta table.