How to determine if a table is a managed table vs external table?

How to determine if a table is a managed table vs external table?
A . Run IS_MANAGED(‘table_name’) function
B. All external tables are stored in data lake, managed tables are stored in DELTA lake
C. All managed tables are stored in unity catalog
D. Run SQL command DESCRIBE EXTENDED table_name and check type
E. Run SQL command SHOW TABLES to see the type of the table

Answer: D

Explanation:

The answer is Run SQL command DESCRIBE EXTENDED table_name and check type Example of External table

Graphical user

interface, text, application

Description automatically generated

Example of managed table

Graphical user

interface, text, application, Teams

Description automatically generated

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments