Notion connector reference

Important

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 Azure 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

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

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

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

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