- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-22-2024 09:57 AM - edited 01-22-2024 09:58 AM
Hi @Lakshay
Thanks for reply,
Yes, my transformation query(i.e dlt view) will have the columns with type struct field like(Column_name) below
Column_O STRING,
Column_name STRUCT< vaccines
ARRAY<
STRUCT< vaccineId STRING, date STRING > >
satisfiedBy ARRAY< STRUCT< vaccineId STRING, orderId STRING, orderItemId STRING >>
serviceName STRING,
dueDate STRING,
completedAt STRING,
state ARRAY< STRUCT<id STRING, name STRING>>,
nextDueDate STRING
>,
Column_name_2 STRING,
.is it possible to create the column with above structure, basically it is combination of both structure and array of structure.
Thanks