- 2 Minutes to read
- 2 Minutes to read
A Guide for getting data from Airtable to Rivery.
How to pull data from Airtable using Rivery
First, select 'Create New River ' from the top right of the Rivery screen.
Choose 'Data Source to Target' as your river type.
In the 'General Info' tab, name your river, describe it and choose a group. Next, navigate to the 'Source' tab.
Find Airtable in the list of data sources and select it. (under Organization )
Under Source Connection, select the connection you created, or create a new one.
Next, enter the ID of the Base you would like to pull data from.
Enter the names of the tables in your base that you would like to pull data from.
Selecting more than 1 table will result in a joint table with fields and data from all selected tables.
If the tables have a mutual field name, but different data types for that field, then the field might be excluded from the pull.
Selecting more than 1 table should mostly occur when the same table is split into different tabs.
i.e., a table for a monthly report might have different tabs for different months, but have the same structure, and thus would make sense to union.
Optional: After filling out Base ID and Table Names, you can click on Validate to verify that all the details you entered are accurate. If not, an appropriate message will appear.
The following fields are optional and are used for filtering:
- Filter By Formula - An Airtable formula. More info can be found in Airtable's docs .
- View - The name or id of a view in your table. If set, only the records in that view would be returned.
- Limit Records - Choose to limit the maximum number of records to fetch from your tables.
(This can be combined with the sorting option, explained below, to fetch the top X records following a certain date, for example)
The last step in the source page is the Auto Mapping feature. Rivery's data pipeline ETL tool will automatically set your Schema based on the data returned from the tables you selected.
You may also choose which fields you want to fetch in the Mapping table, add fields on your own, or remove unwanted fields.
*Please note that there would also be 4 meta data fields: Base ID, Table Name, Record ID (generated by Airtable) and Created Time (creation time of the record, generated by Airtable).
Sorting the data
Once Auto Mapping has completed, it will show a table with the fields and their type.
The last column of the table is sort . You can choose to sort the returned data by whichever columns, either in ascending or descending order, by selecting asc/desc respectively.