Skip to main content

Hi,

We had an issue where are runner VM was full and we needed to clear down some files.  Since then however whenever I have tried to build a pipeline that creates functions where the return type is a table and the field names contain spaces e.g. : 

       return_type: TABLE(

                           "DIVISION CODE" TEXT,

                           "DIVISION" TEXT,

                           "YPLAN" NUMBER)

 

The pipeline fails like so : 

> DATABASE-LEVEL ] - l INFO] - 12:11:06.0955] - Starting Validation on generated configuration

329

330│ Error: invalid data type: CODE" TEXT

 

with snowflake_function_sql.REPORTING_FB_DEV2_REPORTING_GETSALESBYWAREHOUSESTOREWTDANDTD,

344│ on resources.tf.json line 669, in f15].resource.snowflake_function_sql.REPORTING_FB_DEV2_REPORTING_GETSALESBYWAREHOUSESTOREWTDANDTD:

345│ 669: "return_type": "TABLE( \"DIVISION CODE\" TEXT, \"DIVISION\" TEXT, \"YPLAN\" NUMBER)",

 

Replacing the space within the column name with an underscore fixes this, but that would result more work downstream. Could refreshing the files on the runner VM cause this? Has then been any background changes? Is there a way to resolve this

 

 

Be the first to reply!

Reply