Hi there,
When running the pipeline 'feature-creation-auto-audience-segmentation' we get the following error:
400 Error validating procedure body (add OPTIONS(strict_mode=false) to suppress): Query error: Query error: CREATE TABLE has columns with duplicate name at [11:17].
So it appears like the RegEx is creating a duplicate value, causing the pipeline to fail.
Could you guide us in how we add 'OPTIONS(strict_mode=false) to suppress this error? Alternatively, if we should change the RegEx? We are not able to identify the file where we add the OPTIONS-code.
Thank you.
Hi there,
When running the pipeline 'feature-creation-auto-audience-segmentation' we get the following error:
400 Error validating procedure body (add OPTIONS(strict_mode=false) to suppress): Query error: Query error: CREATE TABLE has columns with duplicate name at [11:17].
So it appears like the RegEx is creating a duplicate value, causing the pipeline to fail.
Could you guide us in how we add 'OPTIONS(strict_mode=false) to suppress this error? Alternatively, if we should change the RegEx? We are not able to identify the file where we add the OPTIONS-code.
Thank you.