Question list
List of questions
Related questions
Question 60 - DEA-C01 discussion
Elon, a Data Engineer, needs to Split Semi-structured Elements from the Source files and load them as an array into Separate Columns.
Source File:
A.
+----------------------------------------------------------------------+
B.
| $1 |
C.
|----------------------------------------------------------------------|
D.
| {"mac_address": {"host1": "197.128.1.1","host2": "197.168.0.1"}}, |
E.
| {"mac_address": {"host1": "197.168.2.1","host2": "197.168.3.1"}} |
F.
+----------------------------------------------------------------------+ Output: Splitting the Machine Address as below.
G.
COL1 | COL2 |
H.
|----------+----------|
I.
| [ | [ |
J.
| "197", | "197", |
K.
| "128", | "168", |
L.
| "1", | "0", |
M.
| "1" | "1" |
N.
| ] | ] |
O.
| [ | [ |10. | "197", | "197", |11. | "168", | "168", |12. | "2", | "3", |13. | "1" | "1" |14. | ] | ]Which SnowFlake Function can Elon use to transform this semi structured data in the output format?
P.
CONVERT_TO_ARRAY
Q.
SPLIT
R.
GROUP_BY_CONNECT
S.
NEST
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
