Time Travel on a shared database or its schemas/tables is supported for consumer accounts.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Time Travel on a shared database or its schemas/tables is supported for consumer accounts.

Explanation:
Time Travel in Snowflake operates on the historical versions of objects owned within your own account. A shared database, schemas, or tables come from another account and are presented to you as a read-only view. The historical versions for those shared objects aren’t stored in your consumer account, so you can’t perform Time Travel queries on them. In practice, you can Time Travel data you own, but not the data you access solely through a data share. If you need past states of the shared data, you’d have to rely on the provider’s Time Travel history or other arrangements with the data provider to obtain the desired point-in-time state.

Time Travel in Snowflake operates on the historical versions of objects owned within your own account. A shared database, schemas, or tables come from another account and are presented to you as a read-only view. The historical versions for those shared objects aren’t stored in your consumer account, so you can’t perform Time Travel queries on them. In practice, you can Time Travel data you own, but not the data you access solely through a data share. If you need past states of the shared data, you’d have to rely on the provider’s Time Travel history or other arrangements with the data provider to obtain the desired point-in-time state.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy