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 level |
Column hashing | check | |
Re-sync | check | Connector level |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
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_RETURN
ACH_TRANSFER
BANK_ACCOUNT
BOOK_TRANSFER
CHECK_RETURN
CHECK_TRANSFER
COUNTER_PARTY
DISBURSEMENT
ENTITY
EVENT
INTERNATIONAL_WIRE
LOAN
PAYMENT
TRANSFER
WIRE_DRAW_DOWN
WIRE_TRANSFER
We re-import the following tables and their child tables once a week to capture updates and deletes.
ACH_TRANSFER
BANK_ACCOUNT
BOOK_TRANSFER
COUNTER_PARTY
DISBURSEMENT
LOAN
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.
To zoom, open the ERD in a new window.