If you change the data retention at the account level, do databases, schemas, and tables without explicit retention inherit the new value?

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

Multiple Choice

If you change the data retention at the account level, do databases, schemas, and tables without explicit retention inherit the new value?

Explanation:
Data retention for Time Travel is defined at specific objects and isn’t automatically cascaded from the account down to databases, schemas, and tables. Changing the account-level setting does not automatically apply to those objects that don’t have their own explicit retention set. If you want a particular retention window across objects, you must set it explicitly at each level, or script the propagation for those without an override. When a lower-level object does have its own retention value, that value overrides the account default.

Data retention for Time Travel is defined at specific objects and isn’t automatically cascaded from the account down to databases, schemas, and tables. Changing the account-level setting does not automatically apply to those objects that don’t have their own explicit retention set. If you want a particular retention window across objects, you must set it explicitly at each level, or script the propagation for those without an override. When a lower-level object does have its own retention value, that value overrides the account default.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy