postgres_forward_etl_configurations
Creates, updates, deletes, gets or lists a postgres_forward_etl_configurations resource.
Overview
| Name | postgres_forward_etl_configurations |
| Type | Resource |
| Id | databricks_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:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
delete | delete | parent, deployment_name | pg_database_oid, pg_schema_oid, tenant_id, timeline_id | Hard 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.
| Name | Datatype | Description |
|---|---|---|
deployment_name | string | The Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc) |
parent | string | The Branch to delete Forward ETL configuration for. Format: projects/{project_id}/branches/{branch_id} |
pg_database_oid | integer | PostgreSQL database OID to delete configuration for. |
pg_schema_oid | integer | PostgreSQL schema OID to delete configuration for. |
tenant_id | string | Tenant ID (dashless UUID format). |
timeline_id | string | Timeline ID (dashless UUID format). |
DELETE examples
- delete
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 }}'
;