To start querying, click the SQL button and have at it. So what was Product Inventory in Airtable is now product_inventory in your database. Note that we convert your table names to snake_case (i.e lowercase words delineated by an underscore). You'll now see your entire Airtable base represented in Postgres tables! Step 5: Then simply name your your TablePlus connection (we recommend reusing the name of your Airtable base) and click Create. Step 4:Copy and paste the Connect URL from Sequin into the Connection URL in TablePlus then click Import. TablePlus is a modern, native, and friendly GUI tool for relational databases including MySQL, PostgreSQL, SQLite & more. Step 2: Open TablePlus and click Create a new connection. Step 1: Download and install TablePlus from. Once ssl on, the server will negotiate SSL connections in case they are possible. There are a couple of parameters which are related to encryption: sslciphers HIGH:MEDIUM:+3DES:aNULL allowed SSL ciphers. You can connect to your database in all the ways you're used to. The first thing we have to do to set up OpenSSL is to change nf. Sequin provisioned you a Postgres database. Now that your database is setup, you can connect to it. For larger bases of around ~10,000 records, the sync might take around 30 seconds to complete. You can sync to a Sequin-hosted database or sync to your self-hosted database.Īfter you click Create, we'll immediately connect to Airtable and begin syncing with your base.įor most Airtable bases, the sync will complete in a couple seconds. Step 5: Select the destination database you want to sync your data to. Step 4: Select the Airtable base you want to sync. Click the the Where do I find this? link if you need a little help finding your API key on your Airtable account page. Step 3: Provide us with your Airtable API key. Step 2: Select Airtable as the platform you want to sync. Feel free to join along or use another great sample from the Airtable Universe!) ( For this quickstart, we'll be using the Inventory Tracking template. Add your Airtable base to Sequin įirst, let's connect your Airtable base to Sequin: In 2 minutes, you will sync all your Airtable data to a Postgres database and begin querying your base with SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |