AWS Databricks external tables are delta tables?

[Akshay_Petkar]

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?

[Vidhi_Khaitan]

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.