SHOW PARAMETERS: Changes to Retention Time Values for Databases Created From a Share

Attention

This behavior change is in the 2023_05 bundle.

For the current status of the bundle, refer to Bundle History.

The results of the SHOW PARAMETERS IN DATABASE <database_name> command include default values for parameters that do not apply to a database created from a share.

The DATA_RETENTION_TIME_IN_DAYS parameter sets the number of days data is retained for Time Travel. This data retention time value is 0 for a database created from a share.

The MAX_DATA_EXTENSION_TIME_IN_DAYS parameter sets the maximum number of days Snowflake can extend the data retention period for tables to ingest streaming data to prevent streams from becoming stale. This parameter does not apply to a database created from a share since it is read-only.

In the current release, this behavior changed as follows:

Previously:

For a database created from a share, the results of the SHOW PARAMETERS IN DATABASE database_name command includes the default values for:

  • DATA_RETENTION_TIME_IN_DAYS (1)

  • MAX_DATA_EXTENSION_TIME_IN_DAYS (14)

Currently:

For a database created from a share, the results of the SHOW PARAMETERS IN DATABASE database_name command will no longer include the parameters:

  • DATA_RETENTION_TIME_IN_DAYS

  • MAX_DATA_EXTENSION_TIME_IN_DAYS

Ref: 1146