PostgresqlSource

PostgresqlSources hold the connection information to PostgreSQL data sources.

Example

Simple

    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.