However, you can turn this off on Airtable by editing a Linked Record field and toggling off "Allow linking to multiple records." If your table has another column named id or created_time then we will append an underscore ( _) to the end of the columns name like so:īy default, Linked Record fields on Airtable can refer to multiple records. created_time - this is the timestamp for when the record was created.id - this is the Airtable record_id for the that row.id and created_time Įvery table will contain an id and created_time column: See the linked records and lookups section to learn how. Note: You can toggle whether a Lookup will be stored as a text or text in your Postgres database using the Advanced settings for your resource. Airtable field types → Postgres column types īelow is a complete reference for how your Airtable data will be typed in your Sequin Postgres database. duration_last is the duration of the last sync, which in this example was 0.63 seconds.įor more information about our sync process, scroll down to " The syncing process". In the example above, because started_at is slightly more recent than completed_at, we know a sync is currently running. completed_at is a timestamp for when the last sync was completed. Started_at is a timestamp for when the last sync was started. You'll also see a table called _sync_meta in your schema. If you used emojis □ or punctuation in your table names, we'll remove them from the table names in your Sequin database so your queries are easy to write. So what was Product Inventory in Airtable is now product_inventory in your Sequin database. You'll see that we convert your table names to snake_case (i.e lowercase words delineated by an underscore). We don't sync any of your Airtable views. We sync all the data from your table including the record's id. If you would like multiple bases to be synced as different schemas within one database, send us a quick note ↙ Airtable table → table Įach table in your Airtable base maps one-to-one with a table in your Sequin database. public_swap: a schema that we use for our syncing operation.public: where all your tables are located.Your database name does not match the name of your Airtable base. The name of your database is randomly assigned. Your database is a read-only, follower database. If you would like your database located closer to you, please set up a self-hosted database. By default, this database runs in the AWS region us-west-2 (Oregon). Your Sequin database instance runs on a shared AWS Relational Database Service (RDS). Airtable base → database Įach Airtable base maps one-to-one with a Sequin database. Airtable Reference Querying Airtable with SQL īelow is how your Airtable data will be represented in your Sequin database. Join the waitlist and we'll notify you when we're ready.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |