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

Tables

The cmdlet 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 cmdlet will discover a draft version of every table that has been published.

Views

The cmdlet 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.