René's URL Explorer Experiment


Title: Structured data types | Snowflake Documentation

direct link

Domain: docs.snowflake.com

Links:

DOCUMENTATIONhttps://docs.snowflake.com
Englishhttps://docs.snowflake.com/en/sql-reference/data-types-structured
Françaishttps://docs.snowflake.com/fr/sql-reference/data-types-structured
Deutschhttps://docs.snowflake.com/de/sql-reference/data-types-structured
日本語https://docs.snowflake.com/ja/sql-reference/data-types-structured
한국어https://docs.snowflake.com/ko/sql-reference/data-types-structured
Portuguêshttps://docs.snowflake.com/pt/sql-reference/data-types-structured
Get startedhttps://docs.snowflake.com/en/user-guide-getting-started
Guideshttps://docs.snowflake.com/en/guides
Developerhttps://docs.snowflake.com/en/developer
Referencehttps://docs.snowflake.com/en/reference
Release noteshttps://docs.snowflake.com/en/release-notes/overview
Tutorialshttps://docs.snowflake.com/en/tutorials
Statushttps://status.snowflake.com
Overviewhttps://docs.snowflake.com/en/reference
SQL data types referencehttps://docs.snowflake.com/en/sql-reference-data-types
Summaryhttps://docs.snowflake.com/en/sql-reference/intro-summary-data-types
Numerichttps://docs.snowflake.com/en/sql-reference/data-types-numeric
String & binaryhttps://docs.snowflake.com/en/sql-reference/data-types-text
Logicalhttps://docs.snowflake.com/en/sql-reference/data-types-logical
Date & timehttps://docs.snowflake.com/en/sql-reference/data-types-datetime
Semi-structuredhttps://docs.snowflake.com/en/sql-reference/data-types-semistructured
Structuredhttps://docs.snowflake.com/en/sql-reference/data-types-structured
Unstructuredhttps://docs.snowflake.com/en/sql-reference/data-types-unstructured
Geospatialhttps://docs.snowflake.com/en/sql-reference/data-types-geospatial
UUIDhttps://docs.snowflake.com/en/sql-reference/data-types-uuid
Vectorhttps://docs.snowflake.com/en/sql-reference/data-types-vector
User-definedhttps://docs.snowflake.com/en/sql-reference/data-types-user-defined
Unsupportedhttps://docs.snowflake.com/en/sql-reference/data-types-unsupported
Conversionhttps://docs.snowflake.com/en/sql-reference/data-type-conversion
SQL command referencehttps://docs.snowflake.com/en/sql-reference-commands
Function and stored procedure referencehttps://docs.snowflake.com/en/sql-reference-functions
Class referencehttps://docs.snowflake.com/en/sql-reference-classes
Scripting referencehttps://docs.snowflake.com/en/sql-reference-snowflake-scripting
General referencehttps://docs.snowflake.com/en/sql-reference
API referencehttps://docs.snowflake.com/en/api-reference
Referencehttps://docs.snowflake.com/en/reference
SQL data types referencehttps://docs.snowflake.com/en/sql-reference-data-types
https://docs.snowflake.com/sql-reference/data-types-structured#structured-data-types
Snowflake data typeshttps://docs.snowflake.com/sql-reference-data-types
Apache Iceberg™ tablehttps://docs.snowflake.com/user-guide/tables-iceberg
Apache Iceberg™ data typeshttps://docs.snowflake.com/user-guide/tables-iceberg-data-types
ARRAYhttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-array
OBJECThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-object
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
https://docs.snowflake.com/sql-reference/data-types-structured#specifying-a-structured-type
Specifying a structured ARRAY typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-specifying-array
Specifying a structured OBJECT typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-specifying-object
Specifying a MAP typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-specifying-map
https://docs.snowflake.com/sql-reference/data-types-structured#specifying-a-structured-array-type
Snowflake data typehttps://docs.snowflake.com/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/sql-reference/functions/system_typeof
https://docs.snowflake.com/sql-reference/data-types-structured#specifying-a-structured-object-type
Snowflake data typehttps://docs.snowflake.com/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/sql-reference/functions/system_typeof
https://docs.snowflake.com/sql-reference/data-types-structured#specifying-a-map-type
Snowflake data typehttps://docs.snowflake.com/sql-reference-data-types
Snowflake data typehttps://docs.snowflake.com/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/sql-reference/functions/system_typeof
https://docs.snowflake.com/sql-reference/data-types-structured#creating-a-table-with-a-structured-type-column
CREATE TABLEhttps://docs.snowflake.com/sql-reference/sql/create-table
Specifying a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-specifying
Example of creating a table with a structured ARRAY columnhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-cols-create-table-array
Example of creating a table with a structured OBJECT columnhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-cols-create-table-object
Example of creating a table with a MAP columnhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-cols-create-table-map
https://docs.snowflake.com/sql-reference/data-types-structured#example-of-creating-a-table-with-a-structured-array-column
ARRAY constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-array-constant
does not supporthttps://docs.snowflake.com/sql-reference/sql/insert#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/array_construct
an ARRAY constant specifies a semi-structured ARRAY (not a structured ARRAY)https://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/sql-reference/data-types-structured#example-of-creating-a-table-with-a-structured-object-column
OBJECT constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-object-constant
does not supporthttps://docs.snowflake.com/sql-reference/sql/insert#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/array_construct
an OBJECT constant specifies a semi-structured OBJECT (not a structured OBJECT)https://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/sql-reference/data-types-structured#example-of-creating-a-table-with-a-map-column
OBJECT constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-object-constant
does not supporthttps://docs.snowflake.com/sql-reference/sql/insert#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/array_construct
an OBJECT constant specifies a semi-structured OBJECT (not a MAP)https://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/sql-reference/data-types-structured#adding-a-structured-type-column
ALTER TABLE … ADD COLUMNhttps://docs.snowflake.com/sql-reference/sql/alter-table
Specifying a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-specifying
https://docs.snowflake.com/sql-reference/data-types-structured#dropping-and-renaming-structured-type-columns
ALTER TABLE … DROP COLUMNhttps://docs.snowflake.com/sql-reference/sql/alter-table
ALTER TABLE … RENAME COLUMNhttps://docs.snowflake.com/sql-reference/sql/alter-table
https://docs.snowflake.com/sql-reference/data-types-structured#using-structured-types-in-semi-structured-types
OBJECT constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-object-constant
ARRAY constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-array-constant
constructor functionhttps://docs.snowflake.com/sql-reference/functions-semistructured
https://docs.snowflake.com/sql-reference/data-types-structured#converting-structured-and-semi-structured-types
convertinghttps://docs.snowflake.com/sql-reference/data-type-conversion
Castablehttps://docs.snowflake.com/sql-reference/data-type-conversion#label-data-type-explicit-casting
Coerciblehttps://docs.snowflake.com/sql-reference/data-type-conversion#label-when-coercion-occurs
Explicitly casting a semi-structured type to a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object
Explicitly casting a structured type to a semi-structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-structured
Implicit casting a value (coercion)https://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
Casting from one structured type to anotherhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct
https://docs.snowflake.com/sql-reference/data-types-structured#explicitly-casting-a-semi-structured-type-to-a-structured-type
call the CAST function or use the :: operatorhttps://docs.snowflake.com/sql-reference/functions/cast
Casting semi-structured ARRAY and VARIANT values to structured ARRAY valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object-array
Casting semi-structured OBJECT and VARIANT values to structured OBJECT valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object-object
Casting semi-structured OBJECT and VARIANT values to MAP valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/sql-reference/data-types-structured#casting-semi-structured-array-and-variant-values-to-structured-array-values
JSON null valueshttps://docs.snowflake.com/user-guide/semistructured-considerations#label-variant-null
https://docs.snowflake.com/sql-reference/data-types-structured#casting-semi-structured-object-and-variant-values-to-structured-object-values
JSON null valuehttps://docs.snowflake.com/user-guide/semistructured-considerations#label-variant-null
https://docs.snowflake.com/sql-reference/data-types-structured#casting-semi-structured-object-and-variant-values-to-map-values
JSON null valuehttps://docs.snowflake.com/user-guide/semistructured-considerations#label-variant-null
https://docs.snowflake.com/sql-reference/data-types-structured#explicitly-casting-a-structured-type-to-a-semi-structured-type
call the CAST function, use the :: operatorhttps://docs.snowflake.com/sql-reference/functions/cast
TO_ARRAYhttps://docs.snowflake.com/sql-reference/functions/to_array
TO_OBJECThttps://docs.snowflake.com/sql-reference/functions/to_object
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
JSON null valueshttps://docs.snowflake.com/user-guide/semistructured-considerations#label-variant-null
https://docs.snowflake.com/sql-reference/data-types-structured#implicit-casting-a-value-coercion
implicitly casting (coercion)https://docs.snowflake.com/sql-reference/data-type-conversion#label-when-coercion-occurs
https://docs.snowflake.com/sql-reference/data-types-structured#casting-from-one-structured-type-to-another
call the CAST function or use the :: operatorhttps://docs.snowflake.com/sql-reference/functions/cast
You can cast an ARRAY value of one type to an ARRAY value of another typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-array-types
change the order of key-value pairshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-order
change the names of the keyshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-names
add keyshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-add
https://docs.snowflake.com/sql-reference/data-types-structured#example-casting-from-one-type-of-array-value-to-another
https://docs.snowflake.com/sql-reference/data-types-structured#example-changing-the-order-of-key-value-pairs-in-an-object-value
https://docs.snowflake.com/sql-reference/data-types-structured#example-changing-the-key-names-in-an-object-value
https://docs.snowflake.com/sql-reference/data-types-structured#example-adding-keys-to-an-object-value
OBJECT_INSERThttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-object-insert
https://docs.snowflake.com/sql-reference/data-types-structured#constructing-structured-array-structured-object-and-map-values
Using SQL functions to construct structured ARRAY and OBJECT valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-functions
Using ARRAY and OBJECT constants to construct structured ARRAY and OBJECT valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-constants
Constructing a MAP valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-constructing-map
https://docs.snowflake.com/sql-reference/data-types-structured#using-sql-functions-to-construct-structured-array-and-object-values
ARRAY_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/array_construct
ARRAY_CONSTRUCT_COMPACThttps://docs.snowflake.com/sql-reference/functions/array_construct_compact
ARRAY_AGGhttps://docs.snowflake.com/sql-reference/functions/array_agg
TO_ARRAYhttps://docs.snowflake.com/sql-reference/functions/to_array
OBJECT_CONSTRUCThttps://docs.snowflake.com/sql-reference/functions/object_construct
OBJECT_CONSTRUCT_KEEP_NULLhttps://docs.snowflake.com/sql-reference/functions/object_construct_keep_null
OBJECT_AGGhttps://docs.snowflake.com/sql-reference/functions/object_agg
TO_OBJECThttps://docs.snowflake.com/sql-reference/functions/to_object
Explicitly casting a semi-structured type to a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object
Implicit casting a value (coercion)https://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/sql-reference/data-types-structured#using-array-and-object-constants-to-construct-structured-array-and-object-values
ARRAY constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-array-constant
OBJECT constanthttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-object-constant
Explicitly casting a semi-structured type to a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object
https://docs.snowflake.com/sql-reference/data-types-structured#constructing-a-map-value
Casting semi-structured OBJECT and VARIANT values to MAP valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/sql-reference/data-types-structured#working-with-keys-values-and-elements-in-values-of-structured-types
Getting the list of keys from a structured OBJECT valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-key-list
Getting the list of keys from a MAP valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-key-list-map
Accessing values and elements from values of structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-val-access
Determining the size of a structured ARRAY valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-size
Determining the size of a MAP valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-size-map
Looking up elements in a structured ARRAY valuehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-lookup
Determining if a MAP value contains a keyhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-kv-elem-key
https://docs.snowflake.com/sql-reference/data-types-structured#getting-the-list-of-keys-from-a-structured-object-value
OBJECT_KEYShttps://docs.snowflake.com/sql-reference/functions/object_keys
https://docs.snowflake.com/sql-reference/data-types-structured#getting-the-list-of-keys-from-a-map-value
MAP_KEYShttps://docs.snowflake.com/sql-reference/functions/map_keys
https://docs.snowflake.com/sql-reference/data-types-structured#accessing-values-and-elements-from-values-of-structured-types
GEThttps://docs.snowflake.com/sql-reference/functions/get
GET_IGNORE_CASEhttps://docs.snowflake.com/sql-reference/functions/get_ignore_case
GET_PATHhttps://docs.snowflake.com/sql-reference/functions/get_path
Dot Notationhttps://docs.snowflake.com/user-guide/querying-semistructured#label-querying-semistructured-data-dot-notation
Bracket Notationhttps://docs.snowflake.com/user-guide/querying-semistructured#label-bracket-notation-when-querying-semistructured-data
SYSTEM$TYPEOFhttps://docs.snowflake.com/sql-reference/functions/system_typeof
https://docs.snowflake.com/sql-reference/data-types-structured#determining-the-size-of-a-structured-array-value
ARRAY_SIZEhttps://docs.snowflake.com/sql-reference/functions/array_size
https://docs.snowflake.com/sql-reference/data-types-structured#determining-the-size-of-a-map-value
MAP_SIZEhttps://docs.snowflake.com/sql-reference/functions/map_size
https://docs.snowflake.com/sql-reference/data-types-structured#looking-up-elements-in-a-structured-array-value
ARRAY_CONTAINShttps://docs.snowflake.com/sql-reference/functions/array_contains
ARRAY_POSITIONhttps://docs.snowflake.com/sql-reference/functions/array_position
a type that is comparablehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare
https://docs.snowflake.com/sql-reference/data-types-structured#determining-if-a-map-value-contains-a-key
MAP_CONTAINS_KEYhttps://docs.snowflake.com/sql-reference/functions/map_contains_key
https://docs.snowflake.com/sql-reference/data-types-structured#comparing-values
Comparing structured values with semi-structured valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare-struct-semi
Comparing structured values with other structured valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
Determining if two ARRAY values overlaphttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare-array-overlap
https://docs.snowflake.com/sql-reference/data-types-structured#comparing-structured-values-with-semi-structured-values
https://docs.snowflake.com/sql-reference/data-types-structured#comparing-structured-values-with-other-structured-values
coercedhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/sql-reference/data-types-structured#determining-if-two-array-values-overlap
ARRAYS_OVERLAPhttps://docs.snowflake.com/sql-reference/functions/arrays_overlap
comparable typeshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
https://docs.snowflake.com/sql-reference/data-types-structured#transforming-values-of-structured-types
Transforming structured ARRAY valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-array
Transforming structured OBJECT valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-object
Transforming MAP valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-map
https://docs.snowflake.com/sql-reference/data-types-structured#transforming-structured-array-values
ARRAY_APPENDhttps://docs.snowflake.com/sql-reference/functions/array_append
ARRAY_CAThttps://docs.snowflake.com/sql-reference/functions/array_cat
ARRAY_COMPACThttps://docs.snowflake.com/sql-reference/functions/array_compact
ARRAY_EXCEPThttps://docs.snowflake.com/sql-reference/functions/array_except
ARRAY_INSERThttps://docs.snowflake.com/sql-reference/functions/array_insert
ARRAY_INTERSECTIONhttps://docs.snowflake.com/sql-reference/functions/array_intersection
ARRAY_PREPENDhttps://docs.snowflake.com/sql-reference/functions/array_prepend
ARRAY_SLICEhttps://docs.snowflake.com/sql-reference/functions/array_slice
ARRAY_UNION_AGGhttps://docs.snowflake.com/sql-reference/functions/array_union_agg
Functions that add elements to ARRAY valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-array-add-elements
Functions that accept multiple ARRAY values as inputhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-array-multiple
https://docs.snowflake.com/sql-reference/data-types-structured#functions-that-add-elements-to-array-values
ARRAY_APPENDhttps://docs.snowflake.com/sql-reference/functions/array_append
ARRAY_INSERThttps://docs.snowflake.com/sql-reference/functions/array_insert
ARRAY_PREPENDhttps://docs.snowflake.com/sql-reference/functions/array_prepend
coerciblehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/sql-reference/data-types-structured#functions-that-accept-multiple-array-values-as-input
ARRAY_CAThttps://docs.snowflake.com/sql-reference/functions/array_cat
ARRAY_EXCEPThttps://docs.snowflake.com/sql-reference/functions/array_except
ARRAY_INTERSECTIONhttps://docs.snowflake.com/sql-reference/functions/array_intersection
coerciblehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
comparablehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
https://docs.snowflake.com/sql-reference/data-types-structured#transforming-structured-object-values
Removing key-value pairshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-object-delete
Inserting key-value pairs and updating valueshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-object-insert
Selecting key-value pairs from an existing OBJECThttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-transform-object-pick
CAST function or :: operatorhttps://docs.snowflake.com/sql-reference/functions/cast
Casting from one structured type to anotherhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-struct-struct
https://docs.snowflake.com/sql-reference/data-types-structured#removing-key-value-pairs
OBJECT_DELETEhttps://docs.snowflake.com/sql-reference/functions/object_delete
https://docs.snowflake.com/sql-reference/data-types-structured#inserting-key-value-pairs-and-updating-values
OBJECT_INSERThttps://docs.snowflake.com/sql-reference/functions/object_insert
coercedhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/sql-reference/data-types-structured#selecting-key-value-pairs-from-an-existing-object
OBJECT_PICKhttps://docs.snowflake.com/sql-reference/functions/object_pick
https://docs.snowflake.com/sql-reference/data-types-structured#transforming-map-values
MAP_CAThttps://docs.snowflake.com/sql-reference/functions/map_cat
MAP_DELETEhttps://docs.snowflake.com/sql-reference/functions/map_delete
MAP_INSERThttps://docs.snowflake.com/sql-reference/functions/map_insert
MAP_PICKhttps://docs.snowflake.com/sql-reference/functions/map_pick
https://docs.snowflake.com/sql-reference/data-types-structured#working-with-structured-types
Using the FLATTEN function with values of structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-working-flatten
Using the PARSE_JSON functionhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-working-parse-json
Using structured types with set operators and CASE expressionshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-working-set-operators
Working with other semi-structured functionshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-working-other-functions
https://docs.snowflake.com/sql-reference/data-types-structured#using-the-flatten-function-with-values-of-structured-types
https://docs.snowflake.com/sql-reference/data-types-structured#using-the-parse_json-function
PARSE_JSONhttps://docs.snowflake.com/sql-reference/functions/parse_json
https://docs.snowflake.com/sql-reference/data-types-structured#using-structured-types-with-set-operators-and-case-expressions
Query expressions combined by set operators (e.g. UNION ALL)https://docs.snowflake.com/sql-reference/operators-query
CASE expressionshttps://docs.snowflake.com/sql-reference/functions/case
coercedhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/sql-reference/data-types-structured#working-with-other-semi-structured-functions
AS_ARRAYhttps://docs.snowflake.com/sql-reference/functions/as_array
AS_OBJECThttps://docs.snowflake.com/sql-reference/functions/as_object
IS_ARRAYhttps://docs.snowflake.com/sql-reference/functions/is_array
IS_OBJECThttps://docs.snowflake.com/sql-reference/functions/is_object
TYPEOFhttps://docs.snowflake.com/sql-reference/functions/typeof
https://docs.snowflake.com/sql-reference/data-types-structured#accessing-structured-types-in-applications-using-drivers
https://docs.snowflake.com/sql-reference/data-types-structured#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
SQLhttps://docs.snowflake.com/developer-guide/udf/sql/udf-sql-introduction
Snowflake Scriptinghttps://docs.snowflake.com/developer-guide/stored-procedure/stored-procedures-snowflake-scripting
Javahttps://docs.snowflake.com/developer-guide/udf/java/udf-java-introduction
Pythonhttps://docs.snowflake.com/developer-guide/udf/python/udf-python-introduction
Scalahttps://docs.snowflake.com/developer-guide/udf/scala/udf-scala-introduction
https://docs.snowflake.com/sql-reference/data-types-structured#viewing-information-about-structured-types
Using the SHOW COLUMNS command to view structured type informationhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-info-show-cols
Using the DESCRIBE and other SHOW commands to view structured type informationhttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-info-desc-show
Viewing information about the structured types used in a databasehttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-info-views
https://docs.snowflake.com/sql-reference/data-types-structured#using-the-show-columns-command-to-view-structured-type-information
SHOW COLUMNShttps://docs.snowflake.com/sql-reference/sql/show-columns
https://docs.snowflake.com/sql-reference/data-types-structured#using-the-describe-and-other-show-commands-to-view-structured-type-information
DESCRIBE TABLEhttps://docs.snowflake.com/sql-reference/sql/desc-table
DESCRIBE RESULThttps://docs.snowflake.com/sql-reference/sql/desc-result
DESCRIBE FUNCTIONhttps://docs.snowflake.com/sql-reference/sql/desc-function
DESCRIBE PROCEDUREhttps://docs.snowflake.com/sql-reference/sql/desc-procedure
SHOW FUNCTIONShttps://docs.snowflake.com/sql-reference/sql/show-functions
SHOW PROCEDUREShttps://docs.snowflake.com/sql-reference/sql/show-procedures
https://docs.snowflake.com/sql-reference/data-types-structured#viewing-information-about-the-structured-types-used-in-a-database
COLUMNS viewhttps://docs.snowflake.com/sql-reference/info-schema/columns
ELEMENT_TYPES view in INFORMATION_SCHEMAhttps://docs.snowflake.com/sql-reference/info-schema/element_types
ELEMENT_TYPES view in ACCOUNT_USAGEhttps://docs.snowflake.com/sql-reference/account-usage/element_types
FIELDS view in INFORMATION_SCHEMAhttps://docs.snowflake.com/sql-reference/info-schema/fields
FIELDS view in ACCOUNT_USAGEhttps://docs.snowflake.com/sql-reference/account-usage/fields
Visit Snowflakehttps://www.snowflake.com
Join the conversationhttps://community.snowflake.com/s/
Develop with Snowflakehttps://developers.snowflake.com
Share your feedbackhttps://docs.snowflake.com/feedback
Read the latest on our bloghttps://www.snowflake.com/blog/
Get your own certificationhttps://learn.snowflake.com
Privacy Noticehttps://www.snowflake.com/privacy-policy/
Site Termshttps://www.snowflake.com/legal/snowflake-site-terms/
Snowflake Python APIshttps://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview
Snowflake REST APIshttps://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api
Snowflake CLIhttps://docs.snowflake.com/developer-guide/snowflake-cli/index
Specifying a structured typehttps://docs.snowflake.com/sql-reference/data-types-structured#specifying-a-structured-type
Creating a table with a structured type columnhttps://docs.snowflake.com/sql-reference/data-types-structured#creating-a-table-with-a-structured-type-column
Adding a structured type columnhttps://docs.snowflake.com/sql-reference/data-types-structured#adding-a-structured-type-column
Dropping and renaming structured type columnshttps://docs.snowflake.com/sql-reference/data-types-structured#dropping-and-renaming-structured-type-columns
Using structured types in semi-structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#using-structured-types-in-semi-structured-types
Converting structured and semi-structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#converting-structured-and-semi-structured-types
Constructing structured ARRAY, structured OBJECT, and MAP valueshttps://docs.snowflake.com/sql-reference/data-types-structured#constructing-structured-array-structured-object-and-map-values
Working with keys, values, and elements in values of structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#working-with-keys-values-and-elements-in-values-of-structured-types
Comparing valueshttps://docs.snowflake.com/sql-reference/data-types-structured#comparing-values
Transforming values of structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#transforming-values-of-structured-types
Working with structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#working-with-structured-types
Accessing structured types in applications using drivershttps://docs.snowflake.com/sql-reference/data-types-structured#accessing-structured-types-in-applications-using-drivers
Using structured types with user-defined functions (UDFs) and stored procedureshttps://docs.snowflake.com/sql-reference/data-types-structured#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
Viewing information about structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#viewing-information-about-structured-types

Viewport: width=device-width

URLs of crawlers that visited me.