Column Lite
Column is a nationally chartered infrastructure bank for developers.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ACCOUNT, ACH_TRANSFER, BANK_ACCOUNT, BOOK_TRANSFER, BUSINESS_DETAIL, COUNTER_PARTY, DISBURSEMENT, LOAN, and PERSON_DETAIL tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Column setup guide to connect Column with your destination using Fivetran connectors.
Sync overview
We incrementally sync the following tables and their child tables to capture new records:
ACH_RETURNACH_TRANSFERBANK_ACCOUNTBOOK_TRANSFERCHECK_RETURNCHECK_TRANSFERCOUNTER_PARTYDISBURSEMENTENTITYEVENTINTERNATIONAL_WIRELOANPAYMENTTRANSFERWIRE_DRAW_DOWNWIRE_TRANSFER
We re-import the following tables and their child tables once a week to capture updates and deletes.
ACH_TRANSFERBANK_ACCOUNTBOOK_TRANSFERCOUNTER_PARTYDISBURSEMENTLOAN
We also re-import the remaining tables and their child tables during every sync to capture updates and deletes.
Schema information
This schema applies to all Column connectors.
Explore Column schema ERD