Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync trello.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

The Trello Source plugin for CloudQuery extracts configuration from the Trello API and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Configuration #

To authenticate with the Trello API, you will need to create a power-up app and generate an API key and a token. You can find more information on how to do this here.

The following configuration syncs from Trello to a Postgres destination. The (top level) source spec section is described in the Source Spec Reference. The config for the postgresql destination is not shown here. See our Quickstart if you need help setting up the destination.

kind: source
spec:
  name: "trello"
  path: "cloudquery/trello"
  registry: "cloudquery"
  version: "v1.6.2"
  tables: ["*"]
  destinations:
    - "postgresql"
  # Learn more about the configuration options at https://cql.ink/trello_source
  spec:
    # required
    api_key: "${TRELLO_API_KEY}"
    # required
    token: "${TRELLO_APP_TOKEN}"

Trello Spec #

This is the (nested) spec used by the Trello source plugin:

api_key (string) (required)

API Key generated from a power-up app (as described here).

token (string) (required)

Token generated from a power-up app (as described here). Note this is NOT the "Trello secret".

base_url (string) (optional)

URL of the Trello API.

concurrency (integer) (optional) (default: 50000)
The best effort maximum number of Go routines to use. Lower this number to reduce memory usage.

Full config example #

Below is an example of the full config file with all the optional fields and their default values.

kind: source
spec:
  name: "trello"
  path: "cloudquery/trello"
  registry: "cloudquery"
  version: "v1.6.2"
  tables: ["*"]
  destinations:
    - "postgresql"
  spec:
    # required
    api_key: "${TRELLO_API_KEY}"
    # required
    token: "${TRELLO_APP_TOKEN}"
    # optional
    base_url: "https://api.trello.com/1"
    # optional
    concurrency: 50000