Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
A data engineer has created a new table named 'payments' with a comment stating 'This table contains sensitive information' using the query: CREATE TABLE payments COMMENT 'This table contains sensitive information' AS SELECT * FROM bank_transactions. Which command should the data engineer use to review the comment of the table?
Explanation:
The correct command to review the comment of the table, along with other custom table properties and columns' comments, is DESCRIBE EXTENDED. This command provides a comprehensive overview of the table's metadata, including the comment specified during its creation. Reference: Databricks SQL Language Manual.