Skip to main content

postgres_forward_etl_configurations

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

Overview

Namepostgres_forward_etl_configurations
TypeResource
Iddatabricks_workspace.postgres.postgres_forward_etl_configurations

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
deletedeleteparent, deployment_namepg_database_oid, pg_schema_oid, tenant_id, timeline_idHard delete a Forward ETL configuration and all associated table mappings. Unlike DisableForwardEtl,

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.

NameDatatypeDescription
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
parentstringThe Branch to delete Forward ETL configuration for. Format: projects/{project_id}/branches/{branch_id}
pg_database_oidintegerPostgreSQL database OID to delete configuration for.
pg_schema_oidintegerPostgreSQL schema OID to delete configuration for.
tenant_idstringTenant ID (dashless UUID format).
timeline_idstringTimeline ID (dashless UUID format).

DELETE examples

Hard delete a Forward ETL configuration and all associated table mappings. Unlike DisableForwardEtl,

DELETE FROM databricks_workspace.postgres.postgres_forward_etl_configurations
WHERE parent = '{{ parent }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND pg_database_oid = '{{ pg_database_oid }}'
AND pg_schema_oid = '{{ pg_schema_oid }}'
AND tenant_id = '{{ tenant_id }}'
AND timeline_id = '{{ timeline_id }}'
;