CData Python Connector for HubDB

Build 24.0.9062

Data Model

The 本製品 uses the HubDB endpoints in the HubSpot CMS API to model HubDB tables as relational tables and views.

Tables

The 本製品 models draft tables as SQL tables. Most tables in HubDB are dynamic, but all share the following columns: Id, CreatedAt, UpdatedAt, PublishedAt, PagePath, PageName and ChildTableId.

Note that the 本製品 will discover a draft version of every table that has been published.

Views

The 本製品 models published tables as read-only SQL views.

Aside from the Owners view, which lists owners available for an account, views in HubDB are dynamic.

All dynamic views share these columns: Id, CreatedAt, UpdatedAt, PublishedAt, PagePath, PageName and ChildTableId.

Stored Procedures

Stored Procedures are function-like interfaces to HubDB. They can be used to perform tasks such as importing data and publishing tables.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062