In account usage views, which column displays the timestamp when an object was dropped?

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

In account usage views, which column displays the timestamp when an object was dropped?

Explanation:
In account usage views, objects’ lifecycle events are tracked with a timestamp that records when a drop occurred. The column that stores that moment is Deleted. It contains the drop time, and is NULL when the object still exists. This naming directly signals the event of removal, whereas the other labels would imply either a different naming convention or a boolean indicator rather than the exact drop timestamp.

In account usage views, objects’ lifecycle events are tracked with a timestamp that records when a drop occurred. The column that stores that moment is Deleted. It contains the drop time, and is NULL when the object still exists. This naming directly signals the event of removal, whereas the other labels would imply either a different naming convention or a boolean indicator rather than the exact drop timestamp.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy