Postgres Connector

Connect to an existing PostgreSQL instance and extract data. Rows of data in PostgreSQL are extracted as JSON objects.

​

Properties

Required properties:

• connection_string: Connection string to the Postgres instance
• query: SQL query to extract data (i.e. Select * From TableName)

Optional properties:

• batch_size: The size of batches of rows. Affects performance and latency.

Compatible loaders:

• NeumJSONLoader

​

Usage

from neumai.DataConnectors import PostgresConnector
from neumai.Shared import Selector

postgres_connector =  PostgresConnector(
    connection_string = "postgresql://postgres:<password>@<host>:<port>/postgres",
    query = """ Select * From "TableName"; """
)