credentials
Creates, updates, deletes, gets or lists a credentials resource.
Overview
| Name | credentials |
| Type | Resource |
| Id | databricks_workspace.postgres.credentials |
Fields
The following fields are returned by SELECT queries:
- generate
| Name | Datatype | Description |
|---|---|---|
expire_time | string (date-time) | |
token | string | The OAuth token that can be used as a password when connecting to a database. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
generate | select | deployment_name | Generate OAuth credentials for a Postgres database. |
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) |
SELECT examples
- generate
Generate OAuth credentials for a Postgres database.
SELECT
expire_time,
token
FROM databricks_workspace.postgres.credentials
WHERE deployment_name = '{{ deployment_name }}' -- required
;