Bring data from Notion to your Lakehouse.
databases
database_{database_id}
Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
last_edited_time
. Only extracts pages that have been created or modified since the last sync.Database
Property | Description |
---|---|
id | Unique identifier for the database |
title | Array containing the database title information |
object | Always “database” for database objects |
properties | Stringified JSON of the database schema/properties |
created_time | When the database was created |
created_by | User who created the database |
last_edited_by | User who last edited the database |
last_edited_time | When the database was last modified |
cover | Database cover image information |
icon | Database icon (emoji or image) |
parent | Information about where the database is located |
url | Internal Notion URL for the database |
public_url | Public URL if the database is shared |
archived | Whether the database is archived |
in_trash | Whether the database is in trash |
Database content
Property | Description |
---|---|
id | Unique identifier for the page/row |
object | Always “page” for database entries |
last_edited_time | When the page was last modified (used for incremental sync) |
properties | Stringified JSON containing all the page properties based on the database schema |
created_time | When the page was created |
created_by | User who created the page |
last_edited_by | User who last edited the page |
cover | Page cover image information |
icon | Page icon (emoji or image) |
parent | Reference to the parent database |
archived | Whether the page is archived |
in_trash | Whether the page is in trash |
url | Internal Notion URL for the page |
public_url | Public URL if the page is shared |