JSData & Media Start a project

← All connectors

Schema · Entity relationship diagram

Airtable tables and relationships

Every base, table, field and record your token can see. Record values land as JSON (one row per record) so any base layout works; the whole base is refreshed each sync.

Live4 tables · 4 relationships
ConnectPaste an API key
Default schemaairtable
Source API docssupport.airtable.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
  • A generic layout that works for any base: every table, field and record your token can see.
  • record.fields holds each record's cell values as JSON keyed by field name, e.g. JSON_EXTRACT_PATH_TEXT(fields, 'Status').
  • Records deleted in Airtable are not removed from the warehouse yet.
table_meta.base_id → base.base_idfield.base_id,table_id → table_meta.base_id,table_idrecord.base_id,table_id → table_meta.base_id,table_idtable_meta.base_id,table_id,primary_field_id joins field.base_id,table_id,field_idfieldfield11_pk VARCHAR(32) · primary key_pkvarcharbase_id VARCHAR(32) · → table_meta.base_id,table_idbase_idvarchartable_id VARCHAR(32) · → table_meta.base_id,table_idtable_idvarcharfield_id VARCHAR(32)field_idvarcharname VARCHAR(1024)namevarchartype VARCHAR(64)typevarchardescription VARCHAR(65535)descriptionvarcharfield_order INTEGERfield_orderintis_primary BOOLEANis_primarybooloptions VARCHAR(65535)optionsvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamptable_metatable_meta9_pk VARCHAR(32) · primary key_pkvarcharbase_id VARCHAR(32) · → base.base_id · → field.base_id,table_id,field_idbase_idvarchartable_id VARCHAR(32) · → field.base_id,table_id,field_idtable_idvarcharprimary_field_id VARCHAR(32) · → field.base_id,table_id,field_idprimary_field_idvarcharname VARCHAR(1024)namevarchardescription VARCHAR(65535)descriptionvarcharfield_count INTEGERfield_countintview_count INTEGERview_countint_jsdata_synced TIMESTAMP_jsdata_syncedtimestampbasebase4base_id VARCHAR(32) · primary keybase_idvarcharname VARCHAR(1024)namevarcharpermission_level VARCHAR(32)permission_levelvarchar_jsdata_synced TIMESTAMP_jsdata_syncedtimestamprecordrecord9_pk VARCHAR(32) · primary key_pkvarcharbase_id VARCHAR(32) · → table_meta.base_id,table_idbase_idvarchartable_id VARCHAR(32) · → table_meta.base_id,table_idtable_idvarchartable_name VARCHAR(1024)table_namevarcharrecord_id VARCHAR(32)record_idvarcharcreated_time TIMESTAMPcreated_timetimestampfields VARCHAR(65535)fieldsvarcharfields_truncated BOOLEANfields_truncatedbool_jsdata_synced TIMESTAMP_jsdata_syncedtimestamp
Primary keyForeign keyReferencesJoins on (not a key)

Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.

Table reference

4 tables · click a table for its columns
base4 columnsshow in diagram

Primary key: base_id

ColumnTypeKeyDescription
base_idPrimary key.varchar(32)PK Primary key.
namevarchar(1024)
permission_levelvarchar(32)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
table_meta9 columnsshow in diagram

Primary key: _pk

ColumnTypeKeyDescription
_pkPrimary key.varchar(32)PK Primary key.
base_idReferences base.base_id. Joins to field.base_id,table_id,field_id.varchar(32)FKReferences base.base_id. Joins to field.base_id,table_id,field_id.
table_idJoins to field.base_id,table_id,field_id.varchar(32)FKJoins to field.base_id,table_id,field_id.
namevarchar(1024)
primary_field_idJoins to field.base_id,table_id,field_id.varchar(32)FKJoins to field.base_id,table_id,field_id.
descriptionvarchar(65535)
field_countinteger
view_countinteger
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
field11 columnsshow in diagram

Primary key: _pk

ColumnTypeKeyDescription
_pkPrimary key.varchar(32)PK Primary key.
base_idReferences table_meta.base_id,table_id.varchar(32)FKReferences table_meta.base_id,table_id.
table_idReferences table_meta.base_id,table_id.varchar(32)FKReferences table_meta.base_id,table_id.
field_idvarchar(32)
namevarchar(1024)
typevarchar(64)
descriptionvarchar(65535)
field_orderinteger
is_primaryboolean
optionsvarchar(65535)
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.
record9 columnsshow in diagram

Primary key: _pk

ColumnTypeKeyDescription
_pkPrimary key.varchar(32)PK Primary key.
base_idReferences table_meta.base_id,table_id.varchar(32)FKReferences table_meta.base_id,table_id.
table_idReferences table_meta.base_id,table_id.varchar(32)FKReferences table_meta.base_id,table_id.
table_namevarchar(1024)
record_idvarchar(32)
created_timetimestamp
fieldsThe record's cell values as a JSON object keyed by field name. Unpack with JSON_EXTRACT_PATH_TEXT(fields, 'Field name').varchar(65535)The record's cell values as a JSON object keyed by field name. Unpack with JSON_EXTRACT_PATH_TEXT(fields, 'Field name').
fields_truncatedboolean
_jsdata_syncedWhen jsdata last wrote this row.timestampWhen jsdata last wrote this row.

Connect Airtable All connectors