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
.
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.SELECT
statement is allowed to be executed through duckdb
. This, however, has no restriction on running machine learning algorithms against your data in Airtable using the CREATE PREDICTOR
statement.