CODEWITHSUNDEEP
avrosnowflake-cloud-data-platform
gopinath kolanchi
gopinath kolanchi

Reputation: 180

Avro file load and read from Snowflake table

I am aware that VARIANT data type can be used to load unstructured files, however does this data type support UNION data type of Avro ie - Day 1 Name was record type in avro file and day 2 it is changed to Array. In that case in Hive i will be able to read both records with the help of UNION data type, do snowflake provide same kind of support to read both record and array element from the table?

Regards, Gopi

Upvotes: 0

Views: 717

Answers (1)

user13472370
user13472370

Reputation:

Yes, the union type in Avro is supported in Snowflake, along with most other complex data types.

The VARIANT produced upon read of each separate row will reflect the discovered Avro field data-type, including the true data-type found after evaluating a union-type field.

Upvotes: 0

Related Questions