Title
#advice-data-transformation
m

Matias Ordoñez

08/16/2022, 1:16 PM
Hello , im just a newbie starting with dbt and airbyte , im triying to test a conection between mongodb and mysql , the job runs ok , but when is time to load the data into the destination i have this error and i cant understand it : Any help ?? Thank You!!
Normalization summary: io.airbyte.config.NormalizationSummary@261c0c9[startTime=1660542571869,endTime=1660542596009,failures=[io.airbyte.config.FailureReason@e57673c[failureOrigin=normalization,failureType=system_error,internalMessage=1 of 1 ERROR creating table model morphconsultores.items_view........................................................... [[31mERROR[0m in 2.36s]
	[33mDatabase Error in model items_view (models/generated/airbyte_tables/morphconsultores/items_view.sql)[0m
	  1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '__dbt__cte__items_view_ab1 as (
	  
	  -- SQL model to parse JSON blob stored in a sin' at line 8
	  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/morphconsultores/items_view.sql
	1 of 1 ERROR creating table model morphconsultores.items_view........................................................... [[31mERROR[0m in 2.36s]
	[33mDatabase Error in model items_view (models/generated/airbyte_tables/morphconsultores/items_view.sql)[0m
	  1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '__dbt__cte__items_view_ab1 as (