Column logo

Column

Sync Column account, transfer, and loan data into your warehouse.

Overview

The Column connector syncs your banking-as-a-service data into analytics-ready tables in your data warehouse. Pull accounts, transfers, entities, and loans from the Column API, with Ingest handling auth, pagination, and retries so the tables stay current.

What you can sync

Ingest syncs the following Column data into your data warehouse, each as its own table refreshed on your schedule:

  • Accounts
  • Transfers
  • Entities
  • Loans

Authentication

HTTP Basic Auth (API key)

Create a sandbox or production API key in the Column developer dashboard, sent as the Basic Auth password with a blank username.

You enter credentials in a secure form, never in chat. Ingest stores and rotates them for you.

Resources