Summary
User encounters an error during follow-up data syncs from HubSpot to Databricks, indicating that the target table already exists. The issue persists despite previous resolutions in the Databricks beta channel.
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.