How can I see the location of an external Delta table in Spark using Spark SQL?-CodePudding

Home > database > How can I see the location of an external Delta table in Spark using Spark SQL?

How can I see the location of an external Delta table in Spark using Spark SQL?

Time：12-07

If I create an external table in Databricks, how can I check its location (in Delta lake) using an SQL query?

CodePudding user response：

This can be done by using of multiple ways .

%sql 
show create table database.tablename

%sql 

desc formatted database.tablename

CodePudding user response：

It can be done by using the following command.

describe detail <the table>

The location would be listed in the column location.