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 |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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 connections.
Explore Column schema ERD