Category
IBM DB2 - CREATE TYPE
…definitions, and array types (CREATE [DISTINCT] TYPE ... AS <type> ARRAY[n]) are translated.
PostgreSQL / Greenplum / Netezza - CREATE TYPE
This page describes how source CREATE TYPE statements are translated for PostgreSQL - family dialects to Snowflake native user - defined types where supported.