I am trying to batch insert 1000 records into Snowflake table. One of the column (entity) in my table (T1) is a Variant. This is setting the "arrayBindSupported" = false, which is resulting in 1000 single inserts.
SnowflakePreparedStatementV1.executeBatch() -> statementMetaData.isArrayBindSupported()
Insert query - "INSERT INTO T1 (id, name, TIMESTAMP, entity) SELECT ?, ?, CURRENT_TIMESTAMP::TIMESTAMP_NTZ, PARSE_JSON(?)"
Is this batch + Variant insert supported in Snowflake jdbc ?? I see a similar issue reported in past, but not sure if this was ever implemented. Other thread