对于“JSON”格式,直接复制只支持以下情况:接收器 Snowflake 表仅有一列且该列的数据类型是“VARIANT”、“OBJECT”或“ARRAY” 。 compression可为“无压缩”、gzip、bzip2或deflate。 encodingName保留为默认值或设置为utf-8。 列映射未指定。 在复制活动源中: ...
Type:Optionobject Required: No Database Specifies a Snowflake database for your node to use. Type: String Required: No IamRole Not currently used. Type:Optionobject Required: No MergeAction Specifies a merge action. Valid values:simple,custom. If simple, merge behavior is defined byMergeWhenMat...
type Schema.type string type nullable Schema.nullable boolean nullable byteLength Schema.byteLength integer byteLength collation Schema.collation string collation length Schema.length integer length Data Data array of object Data ID Data.ID integer ID FIRSTNAME Data.FIRSTNAME string FIRSTNAME ...
- If the deserialized JSON object was missing any required properties. schemaTypePropertiesSchema public Object schemaTypePropertiesSchema() Get the schema property: The schema name of the Snowflake database. Type: string (or Expression with resultType string). Returns: the schema value.table...
Name of the connection object. For more information, see: Using a connection URL (in this topic). Modifying the DNS settings for private connectivity to the Snowflake service (in this topic).Configuring Client Redirect and reader accounts If you are a data provider with reader accounts, you ...
AS_OBJECT( <variant_expr> ) Arguments variant_expr An expression that evaluates to a value of type VARIANT.Returns The function returns a value of type OBJECT or NULL: If the type of the value in the variant_expr argument is OBJECT, the function returns a value of type OBJECT. If the ...
type Schema.type string type nullable Schema.nullable boolean nullable byteLength Schema.byteLength integer byteLength collation Schema.collation string collation length Schema.length integer length Data Data array of object Data ID Data.ID integer ID FIRSTNAME Data.FIRSTNAME string FIRSTNAME ...
Modifier and TypeMethod and Description SnowflakeNodeData addAdditionalOptionsEntry(String key, String value) Add a single AdditionalOptions entry SnowflakeNodeData clearAdditionalOptionsEntries() Removes all the entries added into AdditionalOptions. SnowflakeNodeData clone() boolean equals(Object obj...
| { schemaObjectPrivileges | ALL [ PRIVILEGES ] } ON { <object_type> <object_name> | ALL <object_type_plural> IN { DATABASE <db_name> | SCHEMA <schema_name> } } | { schemaObjectPrivileges | ALL [ PRIVILEGES ] } ON FUTURE <object_type_plural> IN { DATABASE <db_name> | SCHEM...
VARIANT可以存储其它数据类型,包含OBJECT或ARRAY本身,只要其大小压缩后小于16MB就可以。OBJECT和ARRAY是VARIANT的一种特例,类似于JSON中的对象和数组。而且VARIANT、OBJECT、ARRAY都支持嵌套。所以,其表达能力是很强的。 关于半结构化的数据类型,详细可以参考:https://docs.snowflake.com/en/sql-reference/data-types-sem...