postgres_recovery_branch_previews

Creates, updates, deletes, gets or lists a postgres_recovery_branch_previews resource.

Overview

Name	postgres_recovery_branch_previews
Type	Resource
Id	databricks_workspace.postgres.postgres_recovery_branch_previews

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	The resource name of the recovery branch. Format: projects/{project_id}/preview/recovery-branches/{recovery_branch_id}
create_time	string (date-time)
parent	string	The project containing this recovery branch. Format: projects/{project_id}
▶status	object
uid	string
update_time	string (date-time)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	parent, deployment_name	page_size, page_token	Returns a paginated list of recovery branches for the project.
inspect	exec	name, deployment_name, branch_id		Materializes a temporary inspection branch from the specified recovery branch for data examination.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
deployment_name	string	The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
name	string	The recovery branch from which to create the inspection branch.
parent	string
page_size	integer
page_token	string

SELECT examples

list

Returns a paginated list of recovery branches for the project.

SELECT
name,
create_time,
parent,
status,
uid,
update_time
FROM databricks_workspace.postgres.postgres_recovery_branch_previews
WHERE parent = '{{ parent }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND page_size = '{{ page_size }}'
AND page_token = '{{ page_token }}'
;

Lifecycle Methods

inspect

Materializes a temporary inspection branch from the specified recovery branch for data examination.

EXEC databricks_workspace.postgres.postgres_recovery_branch_previews.inspect 
@name='{{ name }}' --required, 
@deployment_name='{{ deployment_name }}' --required 
@@json=
'{
"branch_id": "{{ branch_id }}", 
"request_id": "{{ request_id }}"
}'
;