Skip to main content
Documentation
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Deliver same schema or data structure even when data does not exist

Answered
Brittian User

For PBF customers, it would be great if each connector had a static schema that is always delivered no matter the customer that is connecting.  For example, if we have 100 customers that are connecting Hubspot, we would expect each customer to have the same standard schema + customizations.  Currently, we are observing that the connectors do not always have the same standard data structure depending on if data exists or not. This makes it extremely difficult to build a standard ETL flow because you cannot predict the schema delivered across a large group of customers. 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Alexa Maturana-Lowe User
    • Edited

    Brittian Thanks so much for sharing this! I'll work with our internal team (Drew) to see if/how we can prioritize delivering empty tables and columns within pre-defined schema connectors. I know we've already started delivering empty tables for some of our existing connectors such as: Google Ads, Facebook Ads, and several more. Can you share a prioritized list of connectors that would be helpful to have this feature for? I'd imagine Hubspot #1 based on your initial comment.