In matillion, object_construct() within the stored procedure causes SQL compilation error SQLCode: 904], [SQLState: 42000]

anupama.gangadhar January 26, 2023, 2:28am 1

The json key is enclosed in single quotes in the error message. Is identifier required when constructing the json. This a stored procedure for execution on Snowflake.

Topic		Replies	Views
Check properties for unmatched parenthesis, quotes or illegal characters Error Matillion ETL	4	9	April 4, 2022
Matillion not consider as ERROR When Snowflake Stored Proc Failed Matillion ETL	1	5	August 29, 2023
Setting up Oracle CDC following Matillion docs. When attempting trasnfer to Snowflake getting numerous ORA-06512 errors on SYS.DBMS_LOGMINER_INTERNAL, wht are we doing wrong? Matillion ETL	2	1	December 15, 2023
S3 Unload appears to produce invalid JSON? Matillion ETL	4	0	February 10, 2023
Can we push unflatten JSON (API call) data through Matillion to Snowflake? Matillion ETL	1	7	June 10, 2024

In matillion, object_construct() within the stored procedure causes SQL compilation error SQLCode: 904], [SQLState: 42000]

Related topics