--- title: Airtable description: Connect Airtable, understand its sync behavior, and query every table and column it writes. species: reference --- # Airtable Connect Airtable with a personal access token and a base id. The source writes tables discovered from the selected base under `titan.airtable_`. ## Connect Airtable 1. Open **Apps**, choose **Connect app**, and select **Airtable**. 2. Enter a personal access token and a base id. 3. Review the tables, then save the source. 4. Watch **Sync history** until the first run completes. Credentials are stored as secrets. They never become lake columns or appear in query results. ## Sync behavior A base becomes one lake schema. Supernova refuses base-name collisions instead of merging two bases into one schema. A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely. Every lake table also has the [system columns](/v2/docs/concepts/your-lake#the-system-columns) `_synced_at` and `_deleted`; the column reference below lists source columns only. ## Table reference Supernova discovers this reference from the connected account. The Airtable metadata API supplies table and field names for your base. Field types are derived during discovery. Open **Apps → Airtable → Tables** after the first discovery run to see every exact table name, column name, type, and sync selection. Dynamic fields cannot be listed truthfully before an account is connected. ## Deletes and history Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.