PostgreSQL integration

PostgreSQL data, in your warehouse.

A built-in ingestr connector: add credentials, pick tables, schedule it.

name: raw.public_users
type: ingestr
parameters:
  source_connection: postgresql
  source_table: 'public.users'
  destination: snowflake
  incremental_strategy: merge

$ bruin run assets/raw/postgresql.asset.yml

extract · PostgreSQL public.usersincremental
load · snowflake raw.public_usersmerged
checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

PostgreSQL is a powerful, open-source relational database system with a strong reputation for reliability, feature robustness, and performance.

01
Add a PostgreSQL connection with its credentials.
02
Pick the tables to load and how: replace, append or merge.
03
Bruin runs it on your schedule and checks every load.

Connection parameters

username: Database user
password: User password
host: Database server hostname or IP
port: Server port (default 5432)
database: Database name
sslmode: SSL mode (disable, require, verify-ca, verify-full)

Every way PostgreSQL works with Bruin

SourceBuilt-in ingestr sourceDocs →
DestinationBuilt-in ingestr destinationDocs →
Query engineRuns SQL and Python assetsDocs →

Tables

4 tables, ready to load.

public.users
public.orders
public.products
analytics.events

Step-by-step

Pick a destination.

PostgreSQL → Snowflake

Read the guide

PostgreSQL → Google BigQuery

Read the guide

PostgreSQL → Databricks

Read the guide

PostgreSQL → Amazon Redshift

Read the guide

PostgreSQL → ClickHouse

Read the guide

PostgreSQL → DuckDB

Read the guide

PostgreSQL → MotherDuck

Read the guide

The platform

Part of the Bruin platform.

Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.

See the full platform

Sources

DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scraping

Move

Data Ingestion

Model & govern

SQL & Python Data Quality Data Governance

Self-Healing Pipelines

Use

AI Data Analyst AI Dashboards Data Apps Scheduled Agents Reverse ETL

Bruin Cloud runs every step

Databases

More tools, same category.

All 71 Databases tools

MySQL Built in Microsoft SQL Server Built in MongoDB Built in Oracle Database Built in Amazon DynamoDB Built in Elasticsearch Built in SQLite Built in Azure SQL Database Built in

Frequently asked

Questions about PostgreSQL.

Does Bruin have a built-in PostgreSQL integration?

Yes. Built-in ingestr source. Built-in ingestr destination. Runs SQL and Python assets.

Which PostgreSQL tables can Bruin load?

public.users, public.orders, public.products, analytics.events.

Where can PostgreSQL data go?

Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.

How fresh is the data?

As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.

Do we need Bruin Cloud?

No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.