Summary
Error occurs when syncing data from HubSpot to Databricks due to table already existing. Issue persists despite updates. Seeking assistance on resolving the error.
Question
Hey,
I’m getting the below error when syncing data from hubspot to databricks. The first sync works fine, it’s the follow up syncs that fail. I’m using v3.3.0 and Appended/De-Duped method.
It seems like this issue was something that <Slack up> in the databricks beta channel and was resolved but I’m still getting the issue. <@U03SDJJNG5R> do you know what might be causing this?
Cannot create table or view airbyte_dev.hubspot_deals because it already exists. Choose a different name, drop the existing object, add the IF NOT EXISTS clause to tolerate pre-existing objects, add the OR REPLACE clause to replace the existing materialized view, or add the OR REFRESH clause to refresh the existing streaming table. SQLSTATE: 42P07 at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:49)
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.