Connector Improvement: Update the logic to capture same status as Fivetran dashboard in PROD_CONS360NONPII_LOAD.FIVETRANLOG_SOURCE_FIVETRAN_PLATFORM.FIVETRAN_PLATFORM__CONNECTION_STATUS
Answered
Referring to Ticket Number:285138
Below was the reply from Support:
I understand you are concerned about the incorrect connector health shown in the FIVETRAN_PLATFORM__CONNECTION_STATUS destination table of the fivetranlog_source connector
I reviewed this case further and found that FIVETRAN_PLATFORM__CONNECTION_STATUS is updated through the dbt model fivetran_platform__connection_status (reference document).
I see this model is being executed more frequently (screenshot for reference).
However, the connector health value is not updated to connected.
I reviewed the connection_health_status query and could see there are 2 conditions to set the connector health to broken (screenshot for reference)
I believe this is the reason why the connector_health is not updated to connected, and the status should be updated once the connector sync is successful.
Fivetran and Logs Discrepency:
-
Official comment
Hey Rohit, It looks like the Quickstart may have been blocking execution of your connection at the time. However, I believe this is sorted at this point in your account. If not please raise with the support team.
Please sign in to leave a comment.
Comments
1 comment