snowflake-cloud-data-platform

Snowflake: OBJECT(field TYPE) not supported

I'm trying to create the following table in Snowflake:

CREATE OR ALTER TABLE TEST_TABLE (
    a OBJECT(b VARCHAR(100))
);

and I get the following error:

Unsupported data type 'OBJECT(b VARCHAR(100))'.

I expect this to work based on the documentation.

Any idea what is causing this? Or what is the syntax to create an object with a named field?

Solution

  • According to this, only Iceberg tables support structured types.