Payrails integration

Payrails data, in your warehouse.

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

name: raw.payments
type: ingestr
parameters:
  source_connection: payrails
  source_table: 'payments'
  destination: snowflake
  incremental_strategy: merge

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

  1. extract · Payrails paymentsincremental
  2. load · snowflake raw.paymentsmerged
  3. checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

Payrails is a payment operations and orchestration platform that lets enterprises connect and manage multiple payment providers through a single integration.

  1. 01

    Add a Payrails connection with its credentials.

  2. 02

    Pick the tables to load and how: replace, append or merge.

  3. 03

    Bruin runs it on your schedule and checks every load.

Connection parameters

clientid
the ID of your Payrails API credential
clientsecret
the secret of your Payrails API credential
certpath
path to your mTLS client certificate (.pem)
keypath
path to your mTLS client private key (.key)

Tables

3 tables, ready to load.

  • payments
  • instruments
  • executions

The platform

Part of the Bruin platform.

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

01 · Move

Data Ingestion

02 · Model & govern

SQL & Python
Data Quality
Data Governance

03 · Use

AI Data Analyst
AI Dashboards
Data Apps
Self-Healing Pipelines
Bruin Cloudorchestration · governance · observability

Frequently asked

Questions about Payrails.

Does Bruin have a built-in Payrails integration?

Yes. Built-in ingestr source.

Which Payrails tables can Bruin load?

payments, instruments, executions.

Where can Payrails 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.

Ready to connect Payrails?

$100 in credits and 50 AI tasks. No credit card.

A demo walks through your own data.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.

The signup form is hosted by Brevo. Allow marketing cookies to load it.