Skip to main content

Airtable_Export

Node

Node Description

Reads table(s) from Ganymede data lake and uploads to Airtable.

Node Attributes

  • input_table_bq
    • Table from data lake to read in
  • airtable_base_id
    • Base ID used in Airtable API
  • airtable_id
    • ID used in Airtable API

Notes

Prior to usage, the following secrets must be configured in your Ganymede environment:

  • airtable_api_key: API key from Airtable

Secrets can be configured by clicking on your username in the upper-right hand of the Ganymede application, then selecting Environment Settings and navigating to the Secrets tab. If you need assistance, please don't hesitate to reach out to Ganymede.

User-Defined Python

Process tabular data from user-defined SQL query, writing results to Airtable

Parameters

  • df_sql_result : pd.DataFrame | list[pd.DataFrame]
    • Table(s) or list of tables retrieved from user-defined SQL query
  • ganymede_context : GanymedeContext
    • Ganymede context variable, which stores flow run metadata

Returns

NodeReturn Object containing data to store in data lake and/or file storage