René's URL Explorer Experiment


Title: Tipos de dados estruturados | 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
Introduçãohttps://docs.snowflake.com/pt/user-guide-getting-started
Guiashttps://docs.snowflake.com/pt/guides
Desenvolvedorhttps://docs.snowflake.com/pt/developer
Referênciahttps://docs.snowflake.com/pt/reference
Notas de lançamentohttps://docs.snowflake.com/pt/release-notes/overview
Tutoriaishttps://docs.snowflake.com/pt/tutorials
Statushttps://status.snowflake.com
Visão geralhttps://docs.snowflake.com/pt/reference
Referência dos tipos de dados SQLhttps://docs.snowflake.com/pt/sql-reference-data-types
Resumohttps://docs.snowflake.com/pt/sql-reference/intro-summary-data-types
Numéricohttps://docs.snowflake.com/pt/sql-reference/data-types-numeric
Cadeias de caracteres e binárioshttps://docs.snowflake.com/pt/sql-reference/data-types-text
Lógicohttps://docs.snowflake.com/pt/sql-reference/data-types-logical
Data e horahttps://docs.snowflake.com/pt/sql-reference/data-types-datetime
Semiestruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured
Estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured
Não estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-unstructured
Geoespacialhttps://docs.snowflake.com/pt/sql-reference/data-types-geospatial
UUIDhttps://docs.snowflake.com/pt/sql-reference/data-types-uuid
Vetorhttps://docs.snowflake.com/pt/sql-reference/data-types-vector
User-definedhttps://docs.snowflake.com/pt/sql-reference/data-types-user-defined
Sem suportehttps://docs.snowflake.com/pt/sql-reference/data-types-unsupported
Conversãohttps://docs.snowflake.com/pt/sql-reference/data-type-conversion
Referência de comando de SQLhttps://docs.snowflake.com/pt/sql-reference-commands
Referência de funções e procedimentos armazenadoshttps://docs.snowflake.com/pt/sql-reference-functions
Referência de classehttps://docs.snowflake.com/pt/sql-reference-classes
Referência de scripthttps://docs.snowflake.com/pt/sql-reference-snowflake-scripting
Referência geralhttps://docs.snowflake.com/pt/sql-reference
Referência de APIhttps://docs.snowflake.com/pt/api-reference
Referênciahttps://docs.snowflake.com/pt/reference
Referência dos tipos de dados SQLhttps://docs.snowflake.com/pt/sql-reference-data-types
https://docs.snowflake.com/pt/sql-reference/data-types-structured#structured-data-types
tipos de dados Snowflake específicoshttps://docs.snowflake.com/pt/sql-reference-data-types
Apache Iceberg™https://docs.snowflake.com/pt/user-guide/tables-iceberg
Apache Iceberg™https://docs.snowflake.com/pt/user-guide/tables-iceberg-data-types
ARRAYhttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-data-type-array
OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-data-type-object
VARIANThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-data-type-variant
https://docs.snowflake.com/pt/sql-reference/data-types-structured#specifying-a-structured-type
Como especificar um tipo ARRAY estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-specifying-array
Como especificar um tipo OBJECT estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-specifying-object
Especificando um tipo de MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-specifying-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#specifying-a-structured-array-type
tipo de dados Snowflakehttps://docs.snowflake.com/pt/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/pt/sql-reference/functions/system_typeof
https://docs.snowflake.com/pt/sql-reference/data-types-structured#specifying-a-structured-object-type
tipo de dados Snowflakehttps://docs.snowflake.com/pt/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/pt/sql-reference/functions/system_typeof
https://docs.snowflake.com/pt/sql-reference/data-types-structured#specifying-a-map-type
tipo de dados Snowflakehttps://docs.snowflake.com/pt/sql-reference-data-types
tipo de dados Snowflakehttps://docs.snowflake.com/pt/sql-reference-data-types
SYSTEM$TYPEOFhttps://docs.snowflake.com/pt/sql-reference/functions/system_typeof
https://docs.snowflake.com/pt/sql-reference/data-types-structured#creating-a-table-with-a-structured-type-column
CREATE TABLEhttps://docs.snowflake.com/pt/sql-reference/sql/create-table
Como especificar um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-specifying
Exemplo de criação de uma tabela com uma coluna de ARRAY estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-cols-create-table-array
Exemplo de criação de uma tabela com uma coluna de OBJECT estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-cols-create-table-object
Exemplo de criação de uma tabela com uma coluna MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-cols-create-table-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-of-creating-a-table-with-a-structured-array-column
constante de ARRAYhttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-array-constant
não é compatívelhttps://docs.snowflake.com/pt/sql-reference/sql/insert.html#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/array_construct
uma constante ARRAY especifica um ARRAY semiestruturado (e não um ARRAY estruturado)https://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-of-creating-a-table-with-a-structured-object-column
constante de OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-object-constant
não é compatívelhttps://docs.snowflake.com/pt/sql-reference/sql/insert.html#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/array_construct
uma constante OBJECT especifica um OBJECT semiestruturado (e não um OBJECT estruturado)https://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-of-creating-a-table-with-a-map-column
constante de OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-object-constant
não é compatívelhttps://docs.snowflake.com/pt/sql-reference/sql/insert.html#label-insert-command-usage-notes
OBJECT_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/object_construct
ARRAY_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/array_construct
uma constante OBJECT especifica um OBJECT semiestruturado (não um MAP)https://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-constants
https://docs.snowflake.com/pt/sql-reference/data-types-structured#adding-a-structured-type-column
ALTER TABLE … ADD COLUMNhttps://docs.snowflake.com/pt/sql-reference/sql/alter-table
Como especificar um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-specifying
https://docs.snowflake.com/pt/sql-reference/data-types-structured#dropping-and-renaming-structured-type-columns
ALTER TABLE … DROP COLUMNhttps://docs.snowflake.com/pt/sql-reference/sql/alter-table
ALTER TABLE … RENAME COLUMNhttps://docs.snowflake.com/pt/sql-reference/sql/alter-table
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-structured-types-in-semi-structured-types
OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-object-constant
ARRAYhttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-array-constant
função de construtorhttps://docs.snowflake.com/pt/sql-reference/functions-semistructured
https://docs.snowflake.com/pt/sql-reference/data-types-structured#converting-structured-and-semi-structured-types
converterhttps://docs.snowflake.com/pt/sql-reference/data-type-conversion
Conversívelhttps://docs.snowflake.com/pt/sql-reference/data-type-conversion.html#label-data-type-explicit-casting
Coercívelhttps://docs.snowflake.com/pt/sql-reference/data-type-conversion.html#label-when-coercion-occurs
Conversão explícita de um tipo semiestruturado em um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object
Conversão explícita de um tipo estruturado em um tipo semiestruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-structured
Conversão implícita de um valor (coerção)https://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
Conversão de um tipo estruturado em outrohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct
https://docs.snowflake.com/pt/sql-reference/data-types-structured#explicitly-casting-a-semi-structured-type-to-a-structured-type
chamar a função CAST ou usar o operador ::https://docs.snowflake.com/pt/sql-reference/functions/cast
Converter valores semiestruturados de ARRAY e VARIANT em valores ARRAY estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object-array
Converter valores semiestruturados de OBJECT e VARIANT em valores OBJECT estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object-object
Como converter valores OBJECT e VARIANT semiestruturados em valores MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#casting-semi-structured-array-and-variant-values-to-structured-array-values
valores nulos JSONhttps://docs.snowflake.com/pt/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/pt/sql-reference/data-types-structured#casting-semi-structured-object-and-variant-values-to-structured-object-values
valor nulo JSONhttps://docs.snowflake.com/pt/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/pt/sql-reference/data-types-structured#casting-semi-structured-object-and-variant-values-to-map-values
valor nulo JSONhttps://docs.snowflake.com/pt/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/pt/sql-reference/data-types-structured#explicitly-casting-a-structured-type-to-a-semi-structured-type
chamar a função CAST, usar o operador ::https://docs.snowflake.com/pt/sql-reference/functions/cast
TO_ARRAYhttps://docs.snowflake.com/pt/sql-reference/functions/to_array
TO_OBJECThttps://docs.snowflake.com/pt/sql-reference/functions/to_object
TO_VARIANThttps://docs.snowflake.com/pt/sql-reference/functions/to_variant
valores nulos JSONhttps://docs.snowflake.com/pt/user-guide/semistructured-considerations.html#label-variant-null
https://docs.snowflake.com/pt/sql-reference/data-types-structured#implicit-casting-a-value-coercion
conversão (coerção) implícitahttps://docs.snowflake.com/pt/sql-reference/data-type-conversion.html#label-when-coercion-occurs
https://docs.snowflake.com/pt/sql-reference/data-types-structured#casting-from-one-structured-type-to-another
chamar a função CAST ou usar o operador ::https://docs.snowflake.com/pt/sql-reference/functions/cast
É possível converter um valor ARRAY de um tipo em um valor ARRAY de outro tipohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-array-types
alterar a ordem dos pares chave-valorhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-order
alterar os nomes das chaveshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-names
adicionar chaveshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct-object-key-add
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-casting-from-one-type-of-array-value-to-another
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-changing-the-order-of-key-value-pairs-in-an-object-value
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-changing-the-key-names-in-an-object-value
https://docs.snowflake.com/pt/sql-reference/data-types-structured#example-adding-keys-to-an-object-value
OBJECT_INSERThttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-object-insert
https://docs.snowflake.com/pt/sql-reference/data-types-structured#constructing-structured-array-structured-object-and-map-values
Uso das funções SQL para construir valores estruturados ARRAY e OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-functions
Como usar constantes ARRAY e OBJECT para construir valores estruturados ARRAY e OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-constants
Construção de um valor MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-constructing-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-sql-functions-to-construct-structured-array-and-object-values
ARRAY_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/array_construct
ARRAY_CONSTRUCT_COMPACThttps://docs.snowflake.com/pt/sql-reference/functions/array_construct_compact
ARRAY_AGGhttps://docs.snowflake.com/pt/sql-reference/functions/array_agg
TO_ARRAYhttps://docs.snowflake.com/pt/sql-reference/functions/to_array
OBJECT_CONSTRUCThttps://docs.snowflake.com/pt/sql-reference/functions/object_construct
OBJECT_CONSTRUCT_KEEP_NULLhttps://docs.snowflake.com/pt/sql-reference/functions/object_construct_keep_null
OBJECT_AGGhttps://docs.snowflake.com/pt/sql-reference/functions/object_agg
TO_OBJECThttps://docs.snowflake.com/pt/sql-reference/functions/to_object
Conversão explícita de um tipo semiestruturado em um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object
Conversão implícita de um valor (coerção)https://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-array-and-object-constants-to-construct-structured-array-and-object-values
constante ARRAYhttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-array-constant
OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-semistructured.html#label-object-constant
Conversão explícita de um tipo semiestruturado em um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object
https://docs.snowflake.com/pt/sql-reference/data-types-structured#constructing-a-map-value
Como converter valores OBJECT e VARIANT semiestruturados em valores MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-semi-object-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#working-with-keys-values-and-elements-in-values-of-structured-types
Como obter a lista de chaves de um valor estruturado OBJECThttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-key-list
Como obter a lista de chaves de um valor MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-key-list-map
Acesso a valores e elementos a partir de valores de tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-val-access
Determinação do tamanho de um valor ARRAY estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-size
Determinação do tamanho de um valor MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-size-map
Consulta de elementos em um valor ARRAY estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-lookup
Como determinar se um valor MAP contém uma chavehttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-kv-elem-key
https://docs.snowflake.com/pt/sql-reference/data-types-structured#getting-the-list-of-keys-from-a-structured-object-value
OBJECT_KEYShttps://docs.snowflake.com/pt/sql-reference/functions/object_keys
https://docs.snowflake.com/pt/sql-reference/data-types-structured#getting-the-list-of-keys-from-a-map-value
MAP_KEYShttps://docs.snowflake.com/pt/sql-reference/functions/map_keys
https://docs.snowflake.com/pt/sql-reference/data-types-structured#accessing-values-and-elements-from-values-of-structured-types
GEThttps://docs.snowflake.com/pt/sql-reference/functions/get
GET_IGNORE_CASEhttps://docs.snowflake.com/pt/sql-reference/functions/get_ignore_case
GET_PATHhttps://docs.snowflake.com/pt/sql-reference/functions/get_path
Notação de pontoshttps://docs.snowflake.com/pt/user-guide/querying-semistructured.html#label-querying-semistructured-data-dot-notation
Notação de parênteseshttps://docs.snowflake.com/pt/user-guide/querying-semistructured.html#label-bracket-notation-when-querying-semistructured-data
SYSTEM$TYPEOFhttps://docs.snowflake.com/pt/sql-reference/functions/system_typeof
https://docs.snowflake.com/pt/sql-reference/data-types-structured#determining-the-size-of-a-structured-array-value
ARRAY_SIZEhttps://docs.snowflake.com/pt/sql-reference/functions/array_size
https://docs.snowflake.com/pt/sql-reference/data-types-structured#determining-the-size-of-a-map-value
MAP_SIZEhttps://docs.snowflake.com/pt/sql-reference/functions/map_size
https://docs.snowflake.com/pt/sql-reference/data-types-structured#looking-up-elements-in-a-structured-array-value
ARRAY_CONTAINShttps://docs.snowflake.com/pt/sql-reference/functions/array_contains
ARRAY_POSITIONhttps://docs.snowflake.com/pt/sql-reference/functions/array_position
um tipo que seja comparávelhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare
https://docs.snowflake.com/pt/sql-reference/data-types-structured#determining-if-a-map-value-contains-a-key
MAP_CONTAINS_KEYhttps://docs.snowflake.com/pt/sql-reference/functions/map_contains_key
https://docs.snowflake.com/pt/sql-reference/data-types-structured#comparing-values
Comparação de valores estruturados com valores semiestruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare-struct-semi
Comparação de valores estruturados com outros valores estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
Como determinar se dois valores ARRAY se sobrepõemhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare-array-overlap
https://docs.snowflake.com/pt/sql-reference/data-types-structured#comparing-structured-values-with-semi-structured-values
https://docs.snowflake.com/pt/sql-reference/data-types-structured#comparing-structured-values-with-other-structured-values
convertidohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/pt/sql-reference/data-types-structured#determining-if-two-array-values-overlap
ARRAYS_OVERLAPhttps://docs.snowflake.com/pt/sql-reference/functions/arrays_overlap
tipos comparáveishttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
https://docs.snowflake.com/pt/sql-reference/data-types-structured#transforming-values-of-structured-types
Transformação de valores ARRAY estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-array
Transformação de valores OBJECT estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-object
Transformação dos valores MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-map
https://docs.snowflake.com/pt/sql-reference/data-types-structured#transforming-structured-array-values
ARRAY_APPENDhttps://docs.snowflake.com/pt/sql-reference/functions/array_append
ARRAY_CAThttps://docs.snowflake.com/pt/sql-reference/functions/array_cat
ARRAY_COMPACThttps://docs.snowflake.com/pt/sql-reference/functions/array_compact
ARRAY_EXCEPThttps://docs.snowflake.com/pt/sql-reference/functions/array_except
ARRAY_INSERThttps://docs.snowflake.com/pt/sql-reference/functions/array_insert
ARRAY_INTERSECTIONhttps://docs.snowflake.com/pt/sql-reference/functions/array_intersection
ARRAY_PREPENDhttps://docs.snowflake.com/pt/sql-reference/functions/array_prepend
ARRAY_SLICEhttps://docs.snowflake.com/pt/sql-reference/functions/array_slice
ARRAY_UNION_AGGhttps://docs.snowflake.com/pt/sql-reference/functions/array_union_agg
Funções que adicionam elementos aos valores ARRAYhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-array-add-elements
Funções que aceitam múltiplos valores ARRAY como entradahttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-array-multiple
https://docs.snowflake.com/pt/sql-reference/data-types-structured#functions-that-add-elements-to-array-values
ARRAY_APPENDhttps://docs.snowflake.com/pt/sql-reference/functions/array_append
ARRAY_INSERThttps://docs.snowflake.com/pt/sql-reference/functions/array_insert
ARRAY_PREPENDhttps://docs.snowflake.com/pt/sql-reference/functions/array_prepend
compatívelhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/pt/sql-reference/data-types-structured#functions-that-accept-multiple-array-values-as-input
ARRAY_CAThttps://docs.snowflake.com/pt/sql-reference/functions/array_cat
ARRAY_EXCEPThttps://docs.snowflake.com/pt/sql-reference/functions/array_except
ARRAY_INTERSECTIONhttps://docs.snowflake.com/pt/sql-reference/functions/array_intersection
coercívelhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
comparávelhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-compare-struct-struct
https://docs.snowflake.com/pt/sql-reference/data-types-structured#transforming-structured-object-values
Remoção dos pares chave-valorhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-object-delete
Inserção de pares chave-valor e atualização de valoreshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-object-insert
Seleção de pares chave-valor de um OBJECT existentehttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-transform-object-pick
CAST ou o operador ::https://docs.snowflake.com/pt/sql-reference/functions/cast
Conversão de um tipo estruturado em outrohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-struct-struct
https://docs.snowflake.com/pt/sql-reference/data-types-structured#removing-key-value-pairs
OBJECT_DELETEhttps://docs.snowflake.com/pt/sql-reference/functions/object_delete
https://docs.snowflake.com/pt/sql-reference/data-types-structured#inserting-key-value-pairs-and-updating-values
OBJECT_INSERThttps://docs.snowflake.com/pt/sql-reference/functions/object_insert
impostohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/pt/sql-reference/data-types-structured#selecting-key-value-pairs-from-an-existing-object
OBJECT_PICKhttps://docs.snowflake.com/pt/sql-reference/functions/object_pick
https://docs.snowflake.com/pt/sql-reference/data-types-structured#transforming-map-values
MAP_CAThttps://docs.snowflake.com/pt/sql-reference/functions/map_cat
MAP_DELETEhttps://docs.snowflake.com/pt/sql-reference/functions/map_delete
MAP_INSERThttps://docs.snowflake.com/pt/sql-reference/functions/map_insert
MAP_PICKhttps://docs.snowflake.com/pt/sql-reference/functions/map_pick
https://docs.snowflake.com/pt/sql-reference/data-types-structured#working-with-structured-types
Uso da função FLATTEN com valores de tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-working-flatten
Uso da função PARSE_JSONhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-working-parse-json
Como usar tipos estruturados com operadores de conjunto e expressões CASEhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-working-set-operators
Como trabalhar com outras funções semiestruturadashttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-working-other-functions
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-the-flatten-function-with-values-of-structured-types
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-the-parse-json-function
PARSE_JSONhttps://docs.snowflake.com/pt/sql-reference/functions/parse_json
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-structured-types-with-set-operators-and-case-expressions
Expressões de consulta combinadas por operadores de conjunto (por exemplo, UNION ALL)https://docs.snowflake.com/pt/sql-reference/operators-query
Expressões CASEhttps://docs.snowflake.com/pt/sql-reference/functions/case
convertidohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-casting-implicit
https://docs.snowflake.com/pt/sql-reference/data-types-structured#working-with-other-semi-structured-functions
AS_ARRAYhttps://docs.snowflake.com/pt/sql-reference/functions/as_array
AS_OBJECThttps://docs.snowflake.com/pt/sql-reference/functions/as_object
IS_ARRAYhttps://docs.snowflake.com/pt/sql-reference/functions/is_array
IS_OBJECThttps://docs.snowflake.com/pt/sql-reference/functions/is_object
TYPEOFhttps://docs.snowflake.com/pt/sql-reference/functions/typeof
https://docs.snowflake.com/pt/sql-reference/data-types-structured#accessing-structured-types-in-applications-using-drivers
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
SQLhttps://docs.snowflake.com/pt/developer-guide/udf/sql/udf-sql-introduction
Script Snowflakehttps://docs.snowflake.com/pt/developer-guide/stored-procedure/stored-procedures-snowflake-scripting
Javahttps://docs.snowflake.com/pt/developer-guide/udf/java/udf-java-introduction
Pythonhttps://docs.snowflake.com/pt/developer-guide/udf/python/udf-python-introduction
Scalahttps://docs.snowflake.com/pt/developer-guide/udf/scala/udf-scala-introduction
https://docs.snowflake.com/pt/sql-reference/data-types-structured#viewing-information-about-structured-types
Como usar o comando SHOW COLUMNS para visualizar informações de tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-info-show-cols
Como usar os comandos DESCRIBE e outros SHOW para visualizar informações de tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-info-desc-show
Exibição de informações sobre os tipos estruturados usados em um banco de dadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#label-structured-types-info-views
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-the-show-columns-command-to-view-structured-type-information
SHOW COLUMNShttps://docs.snowflake.com/pt/sql-reference/sql/show-columns
https://docs.snowflake.com/pt/sql-reference/data-types-structured#using-the-describe-and-other-show-commands-to-view-structured-type-information
DESCRIBE TABLEhttps://docs.snowflake.com/pt/sql-reference/sql/desc-table
DESCRIBE RESULThttps://docs.snowflake.com/pt/sql-reference/sql/desc-result
DESCRIBE FUNCTIONhttps://docs.snowflake.com/pt/sql-reference/sql/desc-function
DESCRIBE PROCEDUREhttps://docs.snowflake.com/pt/sql-reference/sql/desc-procedure
SHOW FUNCTIONShttps://docs.snowflake.com/pt/sql-reference/sql/show-functions
SHOW PROCEDUREShttps://docs.snowflake.com/pt/sql-reference/sql/show-procedures
https://docs.snowflake.com/pt/sql-reference/data-types-structured#viewing-information-about-the-structured-types-used-in-a-database
Exibição COLUMNShttps://docs.snowflake.com/pt/sql-reference/info-schema/columns
ELEMENT_TYPES em INFORMATION_SCHEMAhttps://docs.snowflake.com/pt/sql-reference/info-schema/element_types
ELEMENT_TYPES em ACCOUNT_USAGEhttps://docs.snowflake.com/pt/sql-reference/account-usage/element_types
FIELDS em INFORMATION_SCHEMAhttps://docs.snowflake.com/pt/sql-reference/info-schema/fields
FIELDS em ACCOUNT_USAGEhttps://docs.snowflake.com/pt/sql-reference/account-usage/fields
Visite Snowflakehttps://www.snowflake.com
Participe da conversahttps://community.snowflake.com/s/
Como desenvolver com Snowflakehttps://developers.snowflake.com
Compartilhe seu feedbackhttps://docs.snowflake.com/feedback
Leia as novidades em nosso bloghttps://www.snowflake.com/blog/
Tenha sua própria certificaçãohttps://learn.snowflake.com
Aviso de privacidadehttps://www.snowflake.com/privacy-policy/
Termos do sitehttps://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
Como especificar um tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#specifying-a-structured-type
Criação de uma tabela com uma coluna de tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#creating-a-table-with-a-structured-type-column
Adição de uma coluna de tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#adding-a-structured-type-column
Descarte e renomeação de colunas de tipo estruturadohttps://docs.snowflake.com/pt/sql-reference/data-types-structured#dropping-and-renaming-structured-type-columns
Como usar tipos estruturados em tipos semiestruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#using-structured-types-in-semi-structured-types
Conversão de tipos estruturados e semiestruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#converting-structured-and-semi-structured-types
Construção de valores estruturados ARRAY, OBJECT e MAPhttps://docs.snowflake.com/pt/sql-reference/data-types-structured#constructing-structured-array-structured-object-and-map-values
Trabalho com chaves, valores e elementos em valores de tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#working-with-keys-values-and-elements-in-values-of-structured-types
Comparação de valoreshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#comparing-values
Transformando valores de tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#transforming-values-of-structured-types
Como trabalhar com tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#working-with-structured-types
Acesso a tipos estruturados em aplicativos usando drivershttps://docs.snowflake.com/pt/sql-reference/data-types-structured#accessing-structured-types-in-applications-using-drivers
Como usar tipos estruturados com funções definidas pelo usuário (UDFs) e procedimentos armazenadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#using-structured-types-with-user-defined-functions-udfs-and-stored-procedures
Exibição de informações sobre tipos estruturadoshttps://docs.snowflake.com/pt/sql-reference/data-types-structured#viewing-information-about-structured-types

Viewport: width=device-width

URLs of crawlers that visited me.