Notion connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page by opting into the Notion connector preview. See Manage Databricks previews.

This page has reference information for the managed Notion connector, including supported source tables and destination table schemas.

Supported source tables

The Notion connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
`pages`	`id`	Pages in the workspace shared with the integration, including parent, properties, and edit metadata.	Incremental	`last_edited_time`
`data_sources`	`id`	Data sources (the queryable tables behind Notion databases), including title, schema properties, and parent.	Incremental	`last_edited_time`
`databases`	`id`, `data_source_id`	Databases discovered through each shared data source, including title, inline flag, and parent.	Full refresh only
`blocks`	`id`	Content blocks within pages and data sources, walked recursively up to 30 levels deep.	Full refresh only
`page_comments`	`id`	Page-level comments on shared pages.	Full refresh only
`block_comments`	`id`	Block-level (inline) comments attached to individual blocks.	Full refresh only
`users`	`id`	Users and bots in the workspace.	Full refresh only

Source table	Primary key	Description	Sync mode	Cursor field
`pages`	`id`	Pages in the workspace shared with the integration, including parent, properties, and edit metadata.	Incremental	`last_edited_time`
`data_sources`	`id`	Data sources (the queryable tables behind Notion databases), including title, schema properties, and parent.	Incremental	`last_edited_time`
`databases`	`id`, `data_source_id`	Databases discovered through each shared data source, including title, inline flag, and parent.	Full refresh only
`blocks`	`id`	Content blocks within pages and data sources, walked recursively up to 30 levels deep.	Full refresh only
`page_comments`	`id`	Page-level comments on shared pages.	Full refresh only
`block_comments`	`id`	Block-level (inline) comments attached to individual blocks.	Full refresh only
`users`	`id`	Users and bots in the workspace.	Full refresh only

note

The pages and data_sources tables sync incrementally on last_edited_time. The databases, blocks, page_comments, block_comments, and users tables are re-scanned in full on each sync because their Notion endpoints expose no change-time ordering. Upserts on the primary key keep the results idempotent. See Notion connector limitations.

Connector options

The Notion connector has no additional configuration options beyond the pipeline settings available for all managed connectors. See Ingest data from Notion.

Destination table schemas

The connector ingests nested Notion objects, such as parent, properties, icon, and cover, as JSON-encoded STRING values. See Notion connector limitations.

`pages`

Primary key: id Cursor field: last_edited_time

Field	Data type
`id`	`STRING`
`object`	`STRING`
`parent`	`STRING`
`properties`	`STRING`
`url`	`STRING`
`public_url`	`STRING`
`created_by`	`STRING`
`last_edited_by`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`
`is_locked`	`BOOLEAN`
`icon`	`STRING`
`cover`	`STRING`

Field	Data type
`id`	`STRING`
`object`	`STRING`
`parent`	`STRING`
`properties`	`STRING`
`url`	`STRING`
`public_url`	`STRING`
`created_by`	`STRING`
`last_edited_by`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`
`is_locked`	`BOOLEAN`
`icon`	`STRING`
`cover`	`STRING`

`data_sources`

Primary key: id Cursor field: last_edited_time

Field	Data type
`id`	`STRING`
`object`	`STRING`
`title`	`STRING`
`description`	`STRING`
`parent`	`STRING`
`database_parent`	`STRING`
`properties`	`STRING`
`url`	`STRING`
`public_url`	`STRING`
`is_inline`	`BOOLEAN`
`created_by`	`STRING`
`last_edited_by`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`

Field	Data type
`id`	`STRING`
`object`	`STRING`
`title`	`STRING`
`description`	`STRING`
`parent`	`STRING`
`database_parent`	`STRING`
`properties`	`STRING`
`url`	`STRING`
`public_url`	`STRING`
`is_inline`	`BOOLEAN`
`created_by`	`STRING`
`last_edited_by`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`

`databases`

Primary key: id, data_source_id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`data_source_id`	`STRING`
`object`	`STRING`
`title`	`STRING`
`description`	`STRING`
`is_inline`	`BOOLEAN`
`parent`	`STRING`
`data_sources`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`
`is_locked`	`BOOLEAN`
`icon`	`STRING`
`cover`	`STRING`
`url`	`STRING`
`public_url`	`STRING`

Field	Data type
`id`	`STRING`
`data_source_id`	`STRING`
`object`	`STRING`
`title`	`STRING`
`description`	`STRING`
`is_inline`	`BOOLEAN`
`parent`	`STRING`
`data_sources`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`
`is_locked`	`BOOLEAN`
`icon`	`STRING`
`cover`	`STRING`
`url`	`STRING`
`public_url`	`STRING`

`blocks`

Primary key: id Sync mode: Full refresh only

The content field holds the block's type-specific payload (for example, the paragraph, heading_1, or to_do object, including its rich text) as a JSON-encoded STRING. Use the type field to determine how to parse content.

Field	Data type
`id`	`STRING`
`object`	`STRING`
`type`	`STRING`
`content`	`STRING`
`parent`	`STRING`
`has_children`	`BOOLEAN`
`created_by`	`STRING`
`last_edited_by`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`in_trash`	`BOOLEAN`

`page_comments`

Primary key: id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`object`	`STRING`
`parent`	`STRING`
`discussion_id`	`STRING`
`rich_text`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`created_by`	`STRING`

`block_comments`

Primary key: id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`object`	`STRING`
`parent`	`STRING`
`discussion_id`	`STRING`
`rich_text`	`STRING`
`created_time`	`TIMESTAMP`
`last_edited_time`	`TIMESTAMP`
`created_by`	`STRING`

`users`

Primary key: id Sync mode: Full refresh only

Field	Data type
`id`	`STRING`
`object`	`STRING`
`type`	`STRING`
`name`	`STRING`
`avatar_url`	`STRING`
`person`	`STRING`
`bot`	`STRING`

Supported source tables​

Connector options​

Destination table schemas​

pages​

data_sources​

databases​

blocks​

page_comments​

block_comments​

users​

Supported source tables

Connector options

Destination table schemas

`pages`

`data_sources`

`databases`

`blocks`

`page_comments`

`block_comments`

`users`