Error: SELECT List Must Not Be Empty
Issue
HubSpot Quickstart data models fail while running the stg_hubspot_merged_deal_tmp model. The following error appears:
SELECT list must not be empty.
Environment
HubSpot Quickstart data models
Resolution
To resolve this issue, manually create a table named merged_deal in your destination, then include the following two columns:
| Column Name | Data Type |
|---|---|
merged_deal_id | LONG |
deal_id | LONG |
Cause
This issue occurs when the HubSpot Quickstart data model fails to query or locate the merged_deal table in your destination. We don't create empty tables for HubSpot connectors. Therefore, this may happen if we haven't yet synced applicable data for the merged_deal table.