Notion

Notion is a powerful all-in-one workspace that allows teams and individuals to collaborate, manage projects, and organize information seamlessly. With flexible databases, real-time collaboration, and extensive customization, Notion helps users structure their work efficiently.

Supported Features

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrueAll tables
Custom dataTrue
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

Data Schema

T
- Table
S
- Sub table
React Flow

πŸ”§ Setup Guide - ELT

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to allow Weld to access your Notion account.

Step 2 - Approve and Finalize

  1. Select the Notion pages you would like Weld to have access to.

Note that you need to have Full Access for a page to appear here. If it doesn't, it's likely because you don't have Full Access to the parent page, however, you can still manually search for the sub-page. Read more about access levels in Notion here.

  1. Approve Weld to access your Notion account.
  2. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 3 - Data To Sync

  1. Select the tables you wish to include in the sync.
    You can view the schema, remove columns or hash sensitive information.
    You can also adjust settings relating to full sync or mark tables as protected.

Step 4 - Configure Sync

  1. Select how often you would like the data to sync.
  2. Press Start Initial Sync.

Weld will take over from here and commence syncing data from your Notion account.

πŸ“‚ Table Summary

Weld supports data replication of Notion databases and their related objects, enabling access to both metadata and content-level information.

  • Databases

    • Description: Databases represent top-level Notion structures that organize data sources. They hold metadata such as titles, icons, covers, and permissions.

  • Data Sources

    • Description: Each data source represents a single Notion table. It defines the schema (properties) for that table, such as column names, data types, and configuration settings.

  • Pages

    • Description: Pages represent the rows or entries within a data source. Each page corresponds to a single record in the table and contains values for each property defined in the schema.

  • Properties

    • Description: Properties define both the structure and content of a Notion table. Schema-level details are stored in data_source_property, while page-level values are stored in page_property.

Object Overview

  • Hierarchical Structure: Notion data is organized in a nested model.
    • A Database can contain multiple Data Sources.
    • Each Data Source defines its own schema through Data Source Properties.
    • Each Data Source contains Pages (rows), which in turn have Page Properties (values).

Was this page helpful?