Issue with Redshift destination V2 and Hubspot connection

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Data is not updating in the final table in Redshift destination V2 after rerunning the Hubspot connection. Incremental normalization models have run successfully but there is no data in the tables, and it does not match the new V2 schema.


Question

Hi team, we have updated our Redshift destination to V2, and tried rerunning our Hubspot connection. Data is updating in airbyte_internal raw table just fine, but not the final table. It says the incremental normalization models have run successfully but there is no data in these tables, and it does not match the new V2 schema.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["redshift-destination-v2", "hubspot-connection", "incremental-normalization", "data-update", "schema-mismatch"]
2

Did you follow the instructions here? https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2

3

No, because we are having problems creating a new connector- we get an http error

4

This error only shows for Hubspot, and I see nothing in our logs. Should I file a ticket?

5

Now I’ve created a new connection and it is creating a raw data table with the old fields in the old schema… not the new airbyte_internal one

6

Any insights onto why this would be?