Restore Backup

Restores database objects from a backup accessible via the data source specified by input parameter datasource_name.

Input Parameter Description

Name

Type

Description

backup_name

string

Name of the backup to restore from, which must refer to an existing backup. The default value is ''.

restore_objects_map

map of string to strings

Map of database objects to be restored from the backup.

Supported Parameters (keys)	Parameter Description
all	All object types and data contained in the given schemas(s).
table	Tables(s) and SQL view(s).
credential	Credential(s).
context	Context(s).
datasink	Data sink(s).
datasource	Data source(s).
stored_procedure	SQL procedure(s).
monitor	Table monitor(s) / SQL stream(s).
user	User(s) (internal and external) and associated permissions.
role	Role(s), role members (roles or users, recursively), and associated permissions.
configuration	If true, restore the database configuration file. The default value is false. The supported values are: true false

datasource_name

string

Data source through which the backup will be restored.

options

map of string to strings

Optional parameters. The default value is an empty map ( {} ).

Supported Parameters (keys)

Parameter Description

backup_id

ID of the snapshot to restore. Leave empty to restore the most recent snapshot in the backup. The default value is ''.

restore_policy

Behavior to apply when any database object to restore already exists. The default value is none.

Supported Values	Description
none	If an object to be restored already exists with the same name, abort and return error.
replace	If an object to be restored already exists with the same name, replace it with the backup version.
rename	If an object to be restored already exists with the same name, move that existing one to the schema specified by renamed_objects_schema.

renamed_objects_schema

If the restore_policy is rename, use this schema for relocated existing objects instead of the default generated one. The default value is ''.

create_schema_if_not_exist

Behavior to apply when the schema containing any database object to restore does not already exist. The default value is true.

Supported Values	Description
true	If the schema containing any restored object does not exist, create it automatically.
false	If the schema containing any restored object does not exist, return an error.

reingest

Behavior to apply when restoring table data. The default value is false.

Supported Values	Description
true	Restore table data by re-ingesting it. This is the default behavior if the cluster topology differs from that of the contained backup.
false	Restore the persisted data files directly.

ddl_only

Behavior to apply when restoring tables. The default value is false.

Supported Values	Description
true	Restore table DDL, but do not restore data.
false	Restore tables and their data.

checksum

Whether or not to verify checksums for backup files when restoring. The default value is false. The supported values are:

dry_run

Whether or not to perform a dry run of the restoration operation. The default value is false. The supported values are:

Name	Type	Description
backup_name	string	Value of input parameter backup_name.
backup_id	long	ID of the snapshot that was restored.
restored_bytes	long	Total size of data restored from backup.
restored_files	long	Total number of files restored from backup.
restored_records	long	Total number of records restored from backup.
restored_objects	map of string to strings	Database objects that were successfully restored and their associated types.
renamed_objects	map of string to strings	Original and new names of database objects that were successfully restored and their associated types.
failed_objects	map of string to strings	Database objects that failed to be restored and their associated types.
info	map of string to strings	Additional information.