Last updated: September 20, 2023
Available with any of the following subscriptions, except where noted:
Marketing Hub Enterprise
|
CMS Hub Professional, Enterprise
|
HubDB is a relational database that allows you to create tables with flexible schema to store data you can use on your website pages, or query externally via the HubDB API.
Please note: to use HubDB data to create dynamic pages, you need CMS Hub Professional or Enterprise.
Create a table
- In your HubSpot account, navigate to Marketing > Files and Templates > HubDB.
- In the upper right, click Create table.
- In the dialog box, enter a Table label and Table name. You cannot change the name of a table after you create it.
- Click Create.
Add and edit table data
Edit a HubDB tables directly in your HubSpot account or upload a CSV to automatically merge in existing data with your table rows.
Add a custom table column
- On the HubDB dashboard, click the label of one of your tables.
- In the upper right, click Actions, then select Add column.
- In the dialog box, configure your column:
- Enter a Column label.
- Enter a Column name. You can use this name to query your data with the HubDB API.
- Enter a Column description. This description will appear when a user hovers over the info icon next to the column name.
- Enter a Column type.
- Click Add column.
- To modify or remove a column, hover over it and click the arrow icon, then select Edit or Remove.
Add table rows
- On the HubDB dashboard, click an existing table's label.
- In the upper right, click Actions, then select Add row.
- A new row will be automatically created beneath any existing rows. Enter a value for each column you've configured for the table.
- To clone or remove a row, hover over the row's ID and click the arrow icon, then select Clone or Remove.
Import table data via a CSV
If you have an existing spreadsheet with data that matches your HubDB table schema, you can import it into HubSpot to automatically merge its data with your table.
Please note:
- To import an image into a HubDB table, add the image's URL to the CSV file. To set dimensions for the image, add the width and height to the end of the URL, offset by commas. For example: http://www.hubspot.com/sample-image.jpg,100,300.
- Imported dates must use MM/DD/YYYY formatting. For example, November 6th, 2022 would be 11/06/2022.
- On the HubDB dashboard, click the label of one of your tables.
- In the upper right, click Actions, then select Import.
- Click the Add or Replace tile:
- Add: rows from your spreadsheet will be added to your existing data.
- Replace: rows from your spreadsheet will overwrite and replace any existing data in your table.
- Click Next.
- Click Choose file.
- Browse your computer's hard drive for the CSV to upload and click Open.
- By default, HubSpot will detect the encoding of the data in your CSV. To manually specify the data encoding:
- Click Advanced options.
- Click the Customize data encoding dropdown menu, then select an encoding.
- Click Next.
- Specify how you want to map each field from your CSV to the corresponding HubDB table column:
- Click the HubDB Table Column dropdown menu, then select a column.
- If you haven't configured an associated column for the CSV field, click Add column. In the dialog box, enter a label, name, and select a type. When you're done, click Add column.
- Click Import.
- When your import is complete, click Done.
Publish tables
When you finish populating your HubDB table with data, you can publish it to use on your website pages and make it accessible to query via the HubSpot API.
- In the upper right, click Publish.
- In the dialog box, confirm that you're ready to take your table public, then click Publish.
Export table data
- On the HubDB dashboard, click the label of one of your tables.
- In the upper right, click the Actions dropdown menu and select Export, then select a file format. The HubDB data will begin downloading immediately.
Please note: images exported from a HubDB table will be formatted as image URLs. If the image's dimensions have been customized, they will appear at the end of the URL.
View table dependents
Once a table has been created, you can view where a HubDB table is being used in your content from the HubDB dashboard. In addition, when deleting a HubDB table, HubSpot will warn you if the table is currently being used by any assets.
To view assets that are using a HubDB table, on the HubDB dashboard, click the Actions dropdown menu next to a table, then select Show dependents.
Learn more about HubDB in HubSpot's developer documentation.
