Hi Airbyte, We are seeing failed syncs when syncing with a GA (Universal Analytics) sources. The Error appears to be related to the type of a ga_datehourminute__dbt_alter column:

Message: Normalization failed during the dbt run. This may indicate a problem with the data itself.

2022-11-01 18:56:57 [42mnormalization[0m > 25 of 27 OK created incremental model public.table_ga_session_descriptors_2............................................. [[32mINSERT 0 185295[0m in 59.57s]
2022-11-01 18:56:57 [42mnormalization[0m > Finished running 27 incremental models in 104.87s.
2022-11-01 18:56:57 [42mnormalization[0m > [31mCompleted with 1 error and 0 warnings:[0m
2022-11-01 18:56:57 [42mnormalization[0m > [33mDatabase Error in model table_ga_session_descriptors_1 (models/generated/airbyte_incremental/public/table_ga_session_descriptors_1.sql)[0m
2022-11-01 18:56:57 [42mnormalization[0m >   column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text
2022-11-01 18:56:57 [42mnormalization[0m >   LINE 4: ...scriptors_1" set "ga_datehourminute__dbt_alter" = "ga_dateho...
2022-11-01 18:56:57 [42mnormalization[0m >                                                                ^
2022-11-01 18:56:57 [42mnormalization[0m >   HINT:  You will need to rewrite or cast the expression.
2022-11-01 18:56:57 [42mnormalization[0m > Done. PASS=26 WARN=0 ERROR=1 SKIP=0 TOTAL=27
2022-11-01 18:56:57 [32mINFO[m i.a.w.p.KubePodProcess(close):737 - (pod: homelander-airbyte-external / normalization-normalize-4-0-aclyw) - Closed all resources for pod
2022-11-01 18:56:57 [32mINFO[m i.a.w.g.DefaultNormalizationWorker(run):82 - Normalization executed in 2 minutes 13 seconds.
2022-11-01 18:56:57 [1;31mERROR[m i.a.w.g.DefaultNormalizationWorker(run):90 - Normalization Failed.
2022-11-01 18:56:57 [32mINFO[m i.a.w.g.DefaultNormalizationWorker(run):95 - Normalization summary: io.airbyte.config.NormalizationSummary@5c90d2f3[startTime=1667328884085,endTime=1667329017823,failures=[io.airbyte.config.FailureReason@52784d4d[failureOrigin=normalization,failureType=system_error,internalMessage=column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@26f99ec5[additionalProperties={attemptNumber=0, jobId=4, from_trace_message=true}],stacktrace=AirbyteDbtError: 
20 of 27 ERROR creating incremental model public.table_ga_session_descriptors_1......................................... [[31mERROR[0m in 37.84s]
[33mDatabase Error in model table_ga_session_descriptors_1 (models/generated/airbyte_incremental/public/table_ga_session_descriptors_1.sql)[0m
  column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text
  LINE 4: ...scriptors_1" set "ga_datehourminute__dbt_alter" = "ga_dateho...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
20 of 27 ERROR creating incremental model public.table_ga_session_descriptors_1......................................... [[31mERROR[0m in 37.84s]
[33mDatabase Error in model table_ga_session_descriptors_1 (models/generated/airbyte_incremental/public/table_ga_session_descriptors_1.sql)[0m
  column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text
  LINE 4: ...scriptors_1" set "ga_datehourminute__dbt_alter" = "ga_dateho...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.,retryable=<null>,timestamp=1667329017641], io.airbyte.config.FailureReason@1be29b24[failureOrigin=normalization,failureType=system_error,internalMessage=column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text,externalMessage=Normalization failed during the dbt run. This may indicate a problem with the data itself.,metadata=io.airbyte.config.Metadata@41bfd5e1[additionalProperties={attemptNumber=0, jobId=4, from_trace_message=true}],stacktrace=AirbyteDbtError: 
20 of 27 ERROR creating incremental model public.table_ga_session_descriptors_1......................................... [[31mERROR[0m in 37.84s]
[33mDatabase Error in model table_ga_session_descriptors_1 (models/generated/airbyte_incremental/public/table_ga_session_descriptors_1.sql)[0m
  column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text
  LINE 4: ...scriptors_1" set "ga_datehourminute__dbt_alter" = "ga_dateho...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.
20 of 27 ERROR creating incremental model public.table_ga_session_descriptors_1......................................... [[31mERROR[0m in 37.84s]
[33mDatabase Error in model table_ga_session_descriptors_1 (models/generated/airbyte_incremental/public/table_ga_session_descriptors_1.sql)[0m
  column "ga_datehourminute__dbt_alter" is of type bigint but expression is of type text
  LINE 4: ...scriptors_1" set "ga_datehourminute__dbt_alter" = "ga_dateho...
                                                               ^
  HINT:  You will need to rewrite or cast the expression.,retryable=<null>,timestamp=1667329017641]]]
2022-11-01 18:56:57 [32mINFO[m i.a.c.i.LineGobbler(voidCall):114 - 
2022-11-01 18:56:57 [32mINFO[m i.a.c.i.LineGobbler(voidCall):114 - ----- END DEFAULT NORMALIZATION -----

Is this a problem with how GA is providing the ga_datehourminute values? Thanks

Hey thanks for reaching out. As I can see this is failing in DBT and hoping that unchecking of DBT is leading to sync success. The best way to see is to compare the connection catalog to the data and see if there is a mismatch

Hi @Harshith (Airbyte), thanks for your help. Where would I disable DBT? Is that an option that can be disabled through the airbyte webapp?

Hey you will find it on the connection settings page.

Hello Coleman Kelleghan, it's been a while without an update from us. Are you still having problems or did you find a solution?