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.
This handler is implemented using
duckdb, a library that allows SQL queries to be executed on
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
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_idis the Airtable base ID.
table_nameis the Airtable table name.
api_keyis the API key for the Airtable API.
Updated 7 months ago