Postgres Connection
Connection to a PostgreSQL database.
Examples​
- postgres_connection_basic.yaml
- postgres_connection_schema_port.yaml
- postgres_connection_setup.yaml
connection:
postgres:
database: my_database
host: your-hostname
user: your-username
password: "${vaults.my_vault_name.password}"
connection:
postgres:
database: my_database
host: your-hostname
user: your-username
password: "${vaults.my_vault_name.password}"
schema: your-schema
port: 5432
connection:
postgres:
host: your-hostname
user: your-username
password: "${vaults.my_vault_name.password}"
database: your-database
schema: your-schema
port: 5432
PostgresConnection​
info
PostgresConnection
is defined beneath the following ancestor nodes in the YAML structure:
Below are the properties for the PostgresConnection
. Each property links to the specific details section further down in this page.
Property | Default | Type | Required | Description |
---|---|---|---|---|
description | string | No | A brief description of what the model does. | |
metadata | No | Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources. | ||
name | string | Yes | The name of the model | |
ssh_tunnel | string | No | ||
postgres | Yes | The PostgreSQL connection options. |
Property Details​
Connection​
A connection to a data source/sink.
Property | Default | Type | Required | Description |
---|---|---|---|---|
connection | One of:   S3Connection   GcsConnection   AbfsConnection |