@kapa.ai CB - HCS Profile Status CB - HCW Profile Status CB - LTC Profile Status CB - SL Profile Status these are all properties present in hubspot UI of contacts table. What can the name of the columns in airbyte contacts table dbName of hubspot connector

The knowledge sources do not contain enough information to answer this query with certainty. The available documentation does not specify the exact database column names (dbName) that Airbyte uses when syncing custom HubSpot contact properties like "CB - HCS Profile Status", "CB - HCW Profile Status", "CB - LTC Profile Status", or "CB - SL Profile Status". However, based on what the knowledge sources do reveal about how the HubSpot source connector handles properties, I can share the following: • Contact properties are stored nested under a

properties

object in the synced records. [Contacts List] • The connector also creates top-level flattened columns prefixed with

properties_

for each property name. For example, a property named

hs_time_in_prospect

would also appear as

properties_hs_time_in_prospect

at the top level. [source-hubspot components] So for your custom properties, the column names in the destination table would likely follow this pattern: •

properties_cb_-_hcs_profile_status

(or similar, depending on how HubSpot's internal API name is defined) Important caveat: The actual column name depends on the internal API name of the property in HubSpot (not the display label shown in the UI). For example, "CB - HCS Profile Status" in the UI might have an internal API name like

cb_hcs_profile_status

or something entirely different assigned when the property was created. To find the exact column names, I'd recommend: 1. Checking the HubSpot property settings to find the internal field name/API name for each property. 2. That internal name, prefixed with

properties_

, will typically be the column name in your destination table. The knowledge sources do not provide a definitive mapping for these specific custom properties. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

there are 658 columns in contacts table, but not able to fetch this

The knowledge sources do not contain enough information to directly troubleshoot why specific HubSpot contact properties are not appearing in your destination table despite 658 columns being present. However, based on what the knowledge sources do explain about the HubSpot connector, here are some relevant points: Why certain properties might be missing: 1. Sensitive properties: The HubSpot connector's CRM search streams use the v3 properties API, which excludes properties marked as sensitive (high

dataSensitivity

). If your "CB - HCS/HCW/LTC/SL Profile Status" properties are flagged as sensitive in HubSpot, they would be excluded from the sync. [fix source-hubspot] 2. Property chunking limits: The connector uses character-based property chunking with a 15,000 character limit per request. If the total length of all property names exceeds this limit across chunks, some properties could potentially be missed. [property chunking] 3. Schema discovery: The connector dynamically discovers properties via the HubSpot properties API. If the properties were created after the last schema refresh, they may not yet be reflected. Recommended next steps: • Check in HubSpot whether these properties have "Sensitive data" enabled — if so, they will be excluded by design. • Verify the internal API name of these properties in HubSpot's property settings (not the display label), as that determines the column name. • Try refreshing the connection schema in Airbyte to pick up any newly discovered properties. The knowledge sources do not provide more specific troubleshooting guidance for this scenario. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

@kapa.ai HCS/HCW/LTC/SL Profile Status" properties are flagged as sensitive in HubSpot, they would be excluded from the sync. How to check the properties flagged as sensitive or not

The knowledge sources do not contain specific instructions on how to check whether a HubSpot property is flagged as sensitive directly within the HubSpot UI or API. What the knowledge sources do confirm is: • HubSpot's Sensitive Data feature (which allows marking properties with

dataSensitivity: "high"

) is only available on HubSpot Enterprise plans (Marketing Hub Enterprise, Sales Hub Enterprise, Service Hub Enterprise, etc.). [fix source-hubspot] • The Airbyte HubSpot connector's v3 properties API (

/crm/v3/properties/{entity}

) excludes sensitive properties by default, which is why they won't appear in the sync. [fix source-hubspot] For checking whether a property is marked as sensitive, I'd recommend consulting HubSpot's own documentation or support, as the knowledge sources here don't cover the HubSpot UI navigation steps for this. Generally, you would look at the property settings in HubSpot under Settings → Properties, find the specific property, and check if the "Sensitive data" option is enabled. Alternatively, you can use the HubSpot v2 properties API (

/properties/v2/{entity}/properties

) to inspect the

dataSensitivity

field for each property — if it returns

"high"

, the property is flagged as sensitive and will be excluded from Airbyte syncs. The v3 API (

/crm/v3/properties/{entity}

) used by Airbyte simply omits those properties entirely. [fix source-hubspot] 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.