ETL: JsonStringToBag

Parse a JSON array string into a bag (array) data structure for iteration. Use JSONSTRINGTOBAG for JSON array processing in ETL data pipelines.

Description

Converts a string expression that contains a json array to a bag (array).

Syntax

JsonStringToBag(string_expression)

Arguments

string_expression - JSON string

Examples

JsonStringToBag('[1,2,3,4,5]') returns a bag that contains the numbers 1,2,3,4,5 as items.

Return value datatype

Bag of strings.

Notes

For more information, read How do I process JSON data.

Impact of null value

If input is null, returns null.