Official

Premium

Notion

The Notion source plugin for CloudQuery loads data from Notion to any of the supported CloudQuery destinations

Publisher

cloudquery

Latest version

v2.5.0

Type

Source

Platforms

Date Published

October 22, 2024

Price per 1M rows

Starting from $15

monthly free quota

1M rows

Documentation Tables Changelog Destinations

Overview

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 notion.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

Notion Source Plugin

A Notion source plugin for CloudQuery that loads data from Notion to any of the supported CloudQuery destinations (e.g. PostgreSQL, BigQuery, Snowflake, and more).

Example Configuration #

This example syncs from Notion to a Postgres destination. The (top level) source spec section is described in the Source Spec Reference.

kind: source
spec:
  name: "notion"
  path: "cloudquery/notion"
  registry: "cloudquery"
  version: "v2.5.0"
  destinations:
    - "postgresql"
  # Learn more about the configuration options at https://cql.ink/notion_source
  spec:
    bearer_token: "${NOTION_SECRET_KEY}"

This example uses environment variable expansion to read the token from an NOTION_SECRET_KEY environment variable. You can also hardcode the value in the configuration file, but this is not advised for production settings.

Authentication #

In Order for CloudQuery to sync resources from your Notion setup, you will need to create a notion integration key and export the Token in NOTION_SECRET_KEY environment variable. How to create the notion integration key? see here. Make sure to give proper Content Capabilities and User Capabilities from capabilities settings. Also give your integration page permissions see here. Only pages and databases with permission will able to sync.

export NOTION_SECRET_KEY=<your_notion_integration_key>

Configuration Reference #

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

bearer_token (string, required)
The bearer token to use for authentication.
concurrency (integer, optional, default: 50000) A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
scheduler (string, optional, default: dfs) The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.
For more information about this, see performance tuning.