SqlExecutor2 does not handle Snowflake ARRAY data type * Bug?

Hello,

I am using the SQLExecutor2 to read a temporary table and write to a Snowflake dataset in a Python recipe. Here is the column data type:

{"type":"ARRAY","length":16777216,"byteLength":16777216,"nullable":true,"fixed":false}

Here is my Python code:

Expression type does not match column data type, expecting VARCHAR(16777216) but got ARRAY for column DOWNED_CCD_ZONE_RADIAL_H_ARRAY

from dataiku.core.sql import SQLExecutor2

executor = SQLExecutor2(connection="MYCONNECTION")

# Create the temporary data table using internal API

mydataset = dataiku.Dataset("mydataset")
executor.exec_recipe_fragment(output_dataset=mydataset,
                              query=f"select * from {my_temp_table}",
                              overwrite_output_schema=True) 

Why would Dataiku expect a VARCHAR when the existing table it is reading from clearly states it is an ARRAY? I believe this to be a bug?

Is there a workaround where I can force Dataiku to cast certain columns with specific datatypes?

thx

Operating system used: Windows 10

Operating system used: Windows 10