At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

The MINDATARETENTIONTIMEINDAYS parameter is an account-level setting available for Enterprise Edition (and higher) accounts. Its purpose is to enforce a minimum Time Travel retention period for all databases, schemas, and tables within the account. This ensures that no object can have its DATARETENTIONTIMEINDAYS set to a value lower than this account-wide minimum, which is critical for compliance and data governance. This parameter can only be set by a user with the ACCOUNTADMIN role.

B. Database: The DATARETENTIONTIMEINDAYS parameter can be set at the database level, but not the MINDATARETENTIONTIMEINDAYS parameter.

C. Schema: The DATARETENTIONTIMEINDAYS parameter can be set at the schema level, but not the MINDATARETENTIONTIMEINDAYS parameter.

D. Table: The DATARETENTIONTIMEINDAYS parameter can be set at the table level, but not the MINDATARETENTIONTIMEINDAYS parameter.

- Snowflake Documentation. (n.d.). MINDATARETENTIONTIMEINDAYS. In Object Parameters. Retrieved from https://docs.snowflake.com/en/sql-reference/parameters#min-data-retention-time-in-days

- Snowflake Documentation. (n.d.). Specifying the Data Retention Period for an Object. In Understanding & Using Time Travel. Retrieved from https://docs.snowflake.com/en/user-guide/data-time-travel#specifying-the-data-retention-period-for-an-object