Categories:

System functions (System Information)

SYSTEM$DATABASE_REFRESH_HISTORY — DeprecatedÂļ

Returns a JSON object showing the refresh history for a secondary database.

Note

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

SyntaxÂļ

SYSTEM$DATABASE_REFRESH_HISTORY( '<secondary_db_name>' )
Copy

ArgumentsÂļ

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.

OutputÂļ

The function returns the following elements in a JSON object:

Column Name

Data Type

Description

startTimeUTC

NUMBER

Time when the replication operation began. Format is epoch time.

endTimeUTC

NUMBER

Time when the replication operation finished, if applicable. Format is epoch time.

currentPhase

TEXT

Current replication phase. For the list of phases, see the usage notes.

jobUUID

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.

Usage notesÂļ

  • Only returns results for account administrators (users with the ACCOUNTADMIN role).

  • 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

ExamplesÂļ

The following example retrieves the refresh history for the mydb secondary database. The results are returned in a JSON object:

SELECT SYSTEM$DATABASE_REFRESH_HISTORY('mydb');
Copy

The following example retrieves the same details as in the previous example, but the results are flattened into relational form:

SELECT
    to_timestamp_ltz(value:startTimeUTC::numeric,3) AS "start_time"
    , to_timestamp_ltz(value:endTimeUTC::numeric,3) AS "end_time"
    , value:currentPhase::string AS "phase"
  , value:jobUUID::string AS "query_ID"
  , value:copy_bytes::integer AS "bytes_transferred"
FROM TABLE(flatten(INPUT=> PARSE_JSON(SYSTEM$DATABASE_REFRESH_HISTORY('mydb'))));
Copy
Language: English