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