Error during connection setup from PlanetScale to Redshift

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

Summary

The user encounters a normalization error indicating that the relation ‘public._airbyte_raw_active_products’ does not exist while setting up a connection from PlanetScale to Redshift using destination v2.


Question

Hi All,

getting this below error when I start to setup connection from planetscale to redshift (i.e I have choosed destination v2 in the connection settings)

        at io.temporal.internal.worker.ActivityWorker$TaskHandlerImpl.handle(ActivityWorker.java:179) ~[temporal-sdk-1.17.0.jar:?]
        at io.temporal.internal.worker.PollTaskExecutor.lambda$process$0(PollTaskExecutor.java:93) ~[temporal-sdk-1.17.0.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
        at java.lang.Thread.run(Thread.java:1583) ~[?:?]
2023-12-20 05:13:39 platform > Normalization executed in 14 seconds for job 7.
2023-12-20 05:13:39 platform > Normalization summary: io.airbyte.config.NormalizationSummary@31b16a2a[startTime=1703049204582,endTime=1703049219088,failures=[io.airbyte.config.FailureReason@c70fba0[failureOrigin=normalization,failureType=system_error,internalMessage=relation "public._airbyte_raw_active_products" does not exist,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@6c3c9365[additionalProperties={attemptNumber=9, jobId=7, from_trace_message=true}],stacktrace=AirbyteDbtError: 
1 of 6 ERROR creating view model _airbyte_public.active_products_stg.................................................... [ERROR in 0.32s]
2 of 6 ERROR creating view model _airbyte_public.users_stg.............................................................. [ERROR in 0.32s]
Database Error in model active_products_stg (models/generated/airbyte_views/public/active_products_stg.sql)
  relation "public._airbyte_raw_active_products" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/active_products_stg.sql
Database Error in model users_stg (models/generated/airbyte_views/public/users_stg.sql)
  relation "public._airbyte_raw_users" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/users_stg.sql
1 of 6 ERROR creating view model _airbyte_public.active_products_stg.................................................... [ERROR in 0.32s]
2 of 6 ERROR creating view model _airbyte_public.users_stg.............................................................. [ERROR in 0.32s]
Database Error in model active_products_stg (models/generated/airbyte_views/public/active_products_stg.sql)
  relation "public._airbyte_raw_active_products" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/active_products_stg.sql
Database Error in model users_stg (models/generated/airbyte_views/public/users_stg.sql)
  relation "public._airbyte_raw_users" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/users_stg.sql,retryable=<null>,timestamp=1703049219087,additionalProperties={}], io.airbyte.config.FailureReason@2672bf85[failureOrigin=normalization,failureType=system_error,internalMessage=relation "public._airbyte_raw_active_products" does not exist,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@1c28715b[additionalProperties={attemptNumber=9, jobId=7, from_trace_message=true}],stacktrace=AirbyteDbtError: 
1 of 6 ERROR creating view model _airbyte_public.active_products_stg.................................................... [ERROR in 0.32s]
2 of 6 ERROR creating view model _airbyte_public.users_stg.............................................................. [ERROR in 0.32s]
Database Error in model active_products_stg (models/generated/airbyte_views/public/active_products_stg.sql)
  relation "public._airbyte_raw_active_products" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/active_products_stg.sql
Database Error in model users_stg (models/generated/airbyte_views/public/users_stg.sql)
  relation "public._airbyte_raw_users" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/users_stg.sql
1 of 6 ERROR creating view model _airbyte_public.active_products_stg.................................................... [ERROR in 0.32s]
2 of 6 ERROR creating view model _airbyte_public.users_stg.............................................................. [ERROR in 0.32s]
Database Error in model active_products_stg (models/generated/airbyte_views/public/active_products_stg.sql)
  relation "public._airbyte_raw_active_products" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/active_products_stg.sql
Database Error in model users_stg (models/generated/airbyte_views/public/users_stg.sql)
  relation "public._airbyte_raw_users" does not exist
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_views/public/users_stg.sql,retryable=<null>,timestamp=1703049219087,additionalProperties={}]],additionalProperties={}]
2023-12-20 05:13:39 platform > 
2023-12-20 05:13:39 platform > ----- END DEFAULT NORMALIZATION -----```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1703049334133789) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['normalization-error', 'dbt-run', 'relation-not-exist', 'planetscale', 'redshift']
</sub>