search

GoogleCloudPlatform / bigquery-utils

Useful scripts, udfs, views, and other utilities for migration and data warehouse operations in BigQuery.
https://cloud.google.com/bigquery/
Apache License 2.0
1.07k stars 269 forks source link

Add json_merge UDF function #339

Closed ismailsimsek closed 2 months ago

ismailsimsek commented 1 year ago

Combines given two json values and returns combined json. Attributes from second json are added to first json if missing and replaced if they are exists.

This enables incremental proces key value data(aggregated to json field), and enables appending,updating json field with new data.

ismailsimsek commented 1 year ago

Please could you move your test cases in udf/community/test_cases.js file. Please could you also provide description at udf/community/README.md file.

updated