After a data scientist noticed that a column was missing from a production feature set stored as a Delta table, the machine learning engineering team has been tasked with determining when the column was dropped from the feature set.
Which of the following SQL commands can be used to accomplish this task?
The DESCRIBE HISTORY command in SQL provides a detailed history of all changes made to a Delta table, including column additions and deletions. This command can be used to track when specific changes, such as the dropping of a column, occurred in the feature set.
D is correct. https://docs.databricks.com/en/sql/language-manual/delta-describe-history.html
DESCRIBE HISTORY command in SQL provides a history of all changes made to a Delta table, including column additions and deletions. Doc: https://docs.databricks.com/en/sql/language-manual/delta-describe-history.html