Skip to content
RebelCore Docs

PostgreSQL connector

The PostgreSQL connector exposes approved PostgreSQL views to the dataset import blade.

Configuration

In Customer Settings -> Connectivity, configure PostgreSQL with:

  • Hostname
  • Port, normally 5432
  • Database name
  • Authentication method
  • Network mode
  • Connection secret

The connection must be enabled, have a stored secret, and have an Active status before it appears in the import blade.

Authentication

Use a least-privilege database user. The user needs read access to the approved v_rc_ views and metadata access through information_schema.

Store the connection secret as a PostgreSQL SQLAlchemy-compatible URL.

Connectivity

The database must be reachable from RebelCore workers over the configured network route. Confirm firewall rules, private networking, DNS, and TLS requirements before enabling the connector.

Supported objects

Only views are supported. RebelCore lists views whose names start with v_rc_.

Tables, materialized views, functions, and arbitrary SQL queries are not imported in this workflow.

View requirement

Create client-facing views with names like:

CREATE VIEW public.v_rc_hr_employees AS
SELECT ...

Rows are read only when RebelCore builds and vectorizes the gold semantic dataset.