PostgresqlSource
PostgresqlSources hold the connection information to PostgreSQL data sources.
Example
sources:
- name: postgresql_source
type: postgresql
database: database
username: {{ env_var('PG_USER') }}
password: {{ env_var('PG_PASSWORD') }}
connection_pool_size: 2
Note
Recommended environment variable use is covered in the sources overview.
Attributes
Field | Type | Default | Description |
---|---|---|---|
path | string | None | A unique path to this object |
name | string | None | The unique name of the object across the entire project. |
host | string | None | The host url of the database. |
port | integer | None | The port of the database. |
database | string | None | The database that the Visivo project will use in queries. |
username | string | None | Username for the database. |
password | string | None | Password corresponding to the username. |
db_schema | string | None | The schema that the Visivo project will use in queries. |
type | string | None | |
connection_pool_size | integer | 1 | The pool size that is used for this connection. |