error in your SQL using dbt_utils.union_relations (_dbt_source_relation)

In-Depth Discussions
1

Hi,

I get an SQL error using dbt_utils.union_relations :

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 'TEXT) as _dbt_source_relation,

Model code is :

{{ dbt_utils.union_relations(
relations=[
ref(‘view_1’),
ref(‘view_2’),
ref(‘view_3’)
]
) }}

Each model view_1.sql, view_2.sql, view_3.sql works good separatly

Using following syntax with my SQL client works good :

SELECT * FROM view_1
UNION ALL
SELECT * FROM view_2
UNION ALL
SELECT * FROM view_3

Thank you for your help