topic AWS Databricks external tables are delta tables? in Warehousing & Analytics

AWS Databricks external tables are delta tables?

Akshay_Petkar — Thu, 27 Jun 2024 12:17:09 GMT

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?

Re: AWS Databricks external tables are delta tables?

Vidhi_Khaitan — Wed, 21 May 2025 04:24:01 GMT

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.