Airtable

This is the implementation of the Airtable data handler for Writer Knowledge Graph. Airtable is a powerful platform that makes it easy to build custom applications. These tools can streamline just about any process, workflow, or project. And best of all, you can build them without ever learning to write a single line of code. Airtable is a must-have for any organization that needs to make data-driven decisions.

​Implementation

This handler is implemented using duckdb, a library that allows SQL queries to be executed on pandas DataFrames.

In essence, when querying a particular table, the entire table is first pulled into a pandas DataFrame using the Airtable API. Once this is done, SQL queries can be run on the DataFrame using duckdb.

Since the entire table needs to be pulled into memory first (DataFrame), it is recommended to be somewhat careful when querying large tables so as not to overload your machine.

The required arguments to establish a connection are as follows:

• base_id is the Airtable base ID.
• table_name is the Airtable table name.
• api_key is the API key for the Airtable API.

​