Skip to main content

Source implementation for Airtable.

Project description

Airtable Source

This is the repository for the Airtable source connector, written in Python. For information about how to use this connector within Airbyte, see the documentation.

To iterate on this connector, make sure to complete this prerequisites section.

  • Create a base named users in your AirTable account.
  • Create two tables named Table 1 and Table 2 in the users base.

From this connector directory, create a virtual environment:

python -m venv .venv

This will generate a virtualenv for this module in .venv/. Make sure this venv is active in your development environment of choice. To activate it from the terminal, run:

source .venv/bin/activate
pip install -r requirements.txt
pip install '.[tests]'

If you are in an IDE, follow your IDE's instructions to activate the virtualenv.

Note that while we are installing dependencies from requirements.txt, you should only edit setup.py for your dependencies. requirements.txt is used for editable installs (pip install -e) to pull in Python dependencies from the monorepo and will call setup.py. If this is mumbo jumbo to you, don't worry about it, just put your deps in setup.py but install using pip install -r requirements.txt and everything should work as you expect.

If you are a community contributor, follow the instructions in the documentation to generate the necessary credentials. Then create a file secrets/config.json conforming to the source_airtable/spec.json file. Note that any directory named secrets is gitignored across the entire Airbyte repo, so there is no danger of accidentally checking in sensitive information. See integration_tests/sample_config.json for a sample config file.

If you are an Airbyte core member, copy the credentials in Lastpass under the secret name source airtable test creds and place them into secrets/config.json.

python main.py spec
python main.py check --config secrets/config.json
python main.py discover --config secrets/config.json
python main.py read --config secrets/config.json --catalog integration_tests/configured_catalog.json

The Airbyte way of building this connector is to use our airbyte-ci tool. You can follow install instructions here. Then running the following command will build your connector:

airbyte-ci connectors --name=source-airtable build

Once the command is done, you will find your connector image in your local docker registry: airbyte/source-airtable:dev.

When contributing on our connector you might need to customize the build process to add a system dependency or set an env var. You can customize our build process by adding a build_customization.py module to your connector. This module should contain a pre_connector_install and post_connector_install async function that will mutate the base image and the connector container respectively. It will be imported at runtime by our build process and the functions will be called if they exist.

Here is an example of a build_customization.py module:

from __future__ import annotations

from typing import TYPE_CHECKING

if TYPE_CHECKING:
from dagger import Container


async def pre_connector_install(base_image_container: Container) -> Container:
return await base_image_container.with_env_variable("MY_PRE_BUILD_ENV_VAR", "my_pre_build_env_var_value")

async def post_connector_install(connector_container: Container) -> Container:
return await connector_container.with_env_variable("MY_POST_BUILD_ENV_VAR", "my_post_build_env_var_value")

This connector is built using our dynamic built process in airbyte-ci. The base image used to build it is defined within the metadata.yaml file under the connectorBuildOptions. The build logic is defined using Dagger here. It does not rely on a Dockerfile.

If you would like to patch our connector and build your own a simple approach would be to:

  1. Create your own Dockerfile based on the latest version of the connector image.
FROM airbyte/source-airtable:latest

COPY . ./airbyte/integration_code
RUN pip install ./airbyte/integration_code

Please use this as an example. This is not optimized.

  1. Build your image:
docker build -t airbyte/source-airtable:dev .
docker run airbyte/source-airtable:dev spec

Then run any of the connector commands as follows:

docker run --rm airbyte/source-airtable:dev spec
docker run --rm -v $(pwd)/secrets:/secrets airbyte/source-airtable:dev check --config /secrets/config.json
docker run --rm -v $(pwd)/secrets:/secrets airbyte/source-airtable:dev discover --config /secrets/config.json
docker run --rm -v $(pwd)/secrets:/secrets -v $(pwd)/integration_tests:/integration_tests airbyte/source-airtable:dev read --config /secrets/config.json --catalog /integration_tests/configured_catalog.json

You can run our full test suite locally using airbyte-ci:

airbyte-ci connectors --name=source-airtable test

Customize acceptance-test-config.yml file to configure tests. See Connector Acceptance Tests for more information. If your connector requires to create or destroy resources for use during acceptance tests create fixtures for it and place them inside integration_tests/acceptance.py.

All of your dependencies should go in setup.py, NOT requirements.txt. The requirements file is only used to connect internal Airbyte dependencies in the monorepo for local development. We split dependencies between two groups, dependencies that are:

  • required for your connector to work need to go to MAIN_REQUIREMENTS list.
  • required for the testing need to go to TEST_REQUIREMENTS list

You've checked out the repo, implemented a million dollar feature, and you're ready to share your changes with the world. Now what?

  1. Make sure your changes are passing our test suite: airbyte-ci connectors --name=source-airtable test
  2. Bump the connector version in metadata.yaml: increment the dockerImageTag value. Please follow semantic versioning for connectors.
  3. Make sure the metadata.yaml content is up to date.
  4. Make the connector documentation and its changelog is up to date (docs/integrations/sources/airtable.md).
  5. Create a Pull Request: use our PR naming conventions.
  6. Pat yourself on the back for being an awesome contributor.
  7. Someone from Airbyte will take a look at your PR and iterate with you to merge it into master.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

airbyte-source-airtable-4.1.5.tar.gz (14.6 kB view details)

Uploaded Source

Built Distribution

airbyte_source_airtable-4.1.5-py3-none-any.whl (15.5 kB view details)

Uploaded Python 3

File details

Details for the file airbyte-source-airtable-4.1.5.tar.gz.

File metadata

File hashes

Hashes for airbyte-source-airtable-4.1.5.tar.gz
Algorithm Hash digest
SHA256 f7a7a8bf3f10521c82968192df2f8b05f78954f21e795a5361c02741a9abb8fb
MD5 370c2c36551f61aa18062ebbddc4e93d
BLAKE2b-256 18fc2b4b4632ab2bd5bd644fcaaf5acf5bafa03a321cdb12e5bb80df7a55a8dd

See more details on using hashes here.

File details

Details for the file airbyte_source_airtable-4.1.5-py3-none-any.whl.

File metadata

File hashes

Hashes for airbyte_source_airtable-4.1.5-py3-none-any.whl
Algorithm Hash digest
SHA256 bcc8a6cc63363c690cac465b74e7f67975f8f57747937e84be1de8b8032f6541
MD5 91df084a3588b21b960a0c8bb630872c
BLAKE2b-256 eb26aed29d478ce6c080c2b9a0bcf9d64affd465d996cbeea75267c7ee89979e

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page