PARQUET_PARSE

Parses Parquet data into an array of objects.

Syntax 

PARQUET_PARSE(text)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"base64_encoded_binary_data": "UEFSMRUEFRgVGEwVBhUAEgAAAAAAAAEAAAACAAAAFQAVFBUULBUGFRAVBhUGHDYAKAQCAAAAGAQAAAAAAAAAAgAAAAYBAgMkACaSARwVAhk1EAAGGRgCaWQVABYGFooBFooBJjwmCBw2ACgEAgAAABgEAAAAAAAZLBUEFQAVAgAVABUQFQIAAAAVBBU2FTZMFQYVABIAAAUAAABBbGljZQMAAABCb2IHAAAAQ2hhcmxpZRUAFRQVFCwVBhUQFQYVBhw2ACgHQ2hhcmxpZRgFQWxpY2UAAAACAAAABgECAyQAJsIDHBUMGTUQAAYZGARuYW1lFQAWBhawARawASbkAiaSAhw2ACgHQ2hhcmxpZRgFQWxpY2UAGSwVBBUAFQIAFQAVEBUCAAAAFQQVMBUwTBUGFQASAADNzMzMzMz0PwAAAAAAAAAAmpmZmZmZDUAVABUUFRQsFQYVEBUGFQYcGAiamZmZmZkNQBgIAAAAAAAAAIAWACgImpmZmZmZDUAYCAAAAAAAAACAAAAAAgAAAAYBAgMkACasBhwVChk1EAAGGRgFc2NvcmUVABYGFtoBFtoBJp4FJtIEHBgImpmZmZmZDUAYCAAAAAAAAACAFgAoCJqZmZmZmQ1AGAgAAAAAAAAAgAAZLBUEFQAVAgAVABUQFQIAAAAVABUOFQ4sFQYVABUGFQYcGAEBGAEAFgAoAQEYAQAAAAACAAAABgEGJr4IHBUAGSUABhkYB2VuYWJsZWQVABYGFlAWUCbuBzwYAQEYAQAWACgBARgBAAAZHBUAFQAVAgAAABUEGVw1ABgGc2NoZW1hFQgAFQIlAhgCaWQlGkysEyASAAAAFQwlAhgEbmFtZSUATBwAAAAVCiUCGAVzY29yZQAVACUCGAdlbmFibGVkABYGGRwZTCaSARwVAhk1EAAGGRgCaWQVABYGFooBFooBJjwmCBw2ACgEAgAAABgEAAAAAAAZLBUEFQAVAgAVABUQFQIAAAAmwgMcFQwZNRAABhkYBG5hbWUVABYGFrABFrABJuQCJpICHDYAKAdDaGFybGllGAVBbGljZQAZLBUEFQAVAgAVABUQFQIAAAAmrAYcFQoZNRAABhkYBXNjb3JlFQAWBhbaARbaASaeBSbSBBwYCJqZmZmZmQ1AGAgAAAAAAAAAgBYAKAiamZmZmZkNQBgIAAAAAAAAAIAAGSwVBBUAFQIAFQAVEBUCAAAAJr4IHBUAGSUABhkYB2VuYWJsZWQVABYGFlAWUCbuBzwYAQEYAQAWACgBARgBAAAZHBUAFQAVAgAAABbkBBYGJggW5AQUAAAoIHBhcnF1ZXQtY3BwLWFycm93IHZlcnNpb24gMTEuMC4wGUwcAAAcAAAcAAAcAAAAtQEAAFBBUjE="
4
}
5
}

Formula

PARQUET_PARSE(BASE64_DECODE(my_action.base64_encoded_binary_data))

Output

1
[
2
{
3
"enabled": false,
4
"id": 0,
5
"name": "Alice",
6
"score": 1.3
7
},
8
{
9
"enabled": true,
10
"id": 1,
11
"name": "Bob",
12
"score": 0
13
},
14
{
15
"enabled": true,
16
"id": 2,
17
"name": "Charlie",
18
"score": 3.7
19
}
20
]
Was this helpful?