DATABASE_REFRESH_HISTORY¶

Returns the refresh history for a secondary database.

Note

This function returns database refresh activity within the last 14 days.

Syntax¶

DATABASE_REFRESH_HISTORY( '<secondary_db_name>' )

Copy

secondary_db_name

Name of the secondary database. This argument is optional if the secondary database is the active database in the current session.

Note that the entire name must be enclosed in single quotes.

Only returns results for account administrators (users with the ACCOUNTADMIN role).
When calling an Information Schema table function, the session must have an INFORMATION_SCHEMA schema in use or the function name must be fully-qualified. For more details, see Snowflake Information Schema.
Following is the list of phases in the order processed:
1. SECONDARY_UPLOADING_INVENTORY
2. PRIMARY_UPLOADING_METADATA
3. PRIMARY_UPLOADING_DATA
4. SECONDARY_DOWNLOADING_METADATA
5. SECONDARY_DOWNLOADING_DATA
6. COMPLETED / FAILED / CANCELED

The function returns the following columns:

Column Name	Data Type	Description
CURRENT_PHASE	TEXT	Current replication phase. For the list of phases, see the usage notes.
START_TIME	NUMBER	Time when the replication operation began. Format is epoch time.
END_TIME	NUMBER	Time when the replication operation finished, if applicable. Format is epoch time.
JOB_UUID	TEXT	Query ID for the secondary database refresh job.
COPY_BYTES	NUMBER	Number of bytes copied during the replication operation.
OBJECT_COUNT	NUMBER	Number of database objects copied during the replication operation.

Retrieve the database refresh history for the database that is currently active in the user session:

select *
from table(information_schema.database_refresh_history());

Copy