postgres_forward_etl_metadata
Creates, updates, deletes, gets or lists a postgres_forward_etl_metadata resource.
Overview
| Name | postgres_forward_etl_metadata |
| Type | Resource |
| Id | databricks_workspace.postgres.postgres_forward_etl_metadata |
Fields
The following fields are returned by SELECT queries:
- get
| Name | Datatype | Description |
|---|---|---|
databases | array | List of databases with their PostgreSQL OIDs. |
schemas | array | List of schemas with their PostgreSQL OIDs. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | parent, deployment_name | tenant_id, timeline_id | Get Forward ETL metadata (database and schema OIDs). |
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 get metadata for. Format: projects/{project_id}/branches/{branch_id} |
tenant_id | string | Tenant ID (dashless UUID format). |
timeline_id | string | Timeline ID (dashless UUID format). |
SELECT examples
- get
Get Forward ETL metadata (database and schema OIDs).
SELECT
databases,
schemas
FROM databricks_workspace.postgres.postgres_forward_etl_metadata
WHERE parent = '{{ parent }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND tenant_id = '{{ tenant_id }}'
AND timeline_id = '{{ timeline_id }}'
;