Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hi,

we are considering using Airtable for a DB. We would need users who can access through UI (read only access) and also programmatic access and because Airtable is so user-friendly it is on our list to be considered.

Has anyone experience accessing programmatically Airtable via API? I heard the API is not very good and only supports HTTP.
Have you worked with any other DB that would fulfil these requirements? user-friendly UI for read-only-user and accessible securely via API

Also any suggested link about how to orchestrate the input/output from Airtable with Prefect?

Thanks in advance!

At my last job we had to interact with airtable. There's no official support, but there's this hero here who keeps this going: <https://github.com/gtalarico/pyairtable>

Also is there some kind of integration between Prefect and Airtable?
I saw <https://docs-legacy.prefect.io/api/0.11.5/tasks/airtable.html#writeairtablerow|this >but it is only for Prefect v1

Not that I know of. We just made our own custom tasks 

We don’t have the integration with Airtable, but you can consider <https://docs.prefect.io/collections/contribute/|contributing to the Prefect collections> if you’d like to see it