Daniel De Leo

Javscript and Markdown formatting Upgrade dataform cli version in package.json to 1.20.0

Update UDF contributing docs

5

Update docs to address the issue that was surfaced in [thie PR](https://github.com/GoogleCloudPlatform/bigquery-utils/pull/216#issue-599026822)

https://github.com/GoogleCloudPlatform/bigquery-utils/blob/8677d0e2bf505430b10949bf67e3bd7f43d24691/udfs/tests/udf_test_utils.py#L86 os.getenv("SHORT_SHA") will return None in local testing

BigQuery query optimizer will invoke once and re-use the output of random_value UDF if the UDF is called within a SQL subquery. https://github.com/GoogleCloudPlatform/bigquery-utils/blob/master/udfs/community/random_value.sql Possible Solution: random_value(arr ANY TYPE, col ANY...

CLI command (dataform run) --tags flag does not accept a list of tags

4

The CLI help text describes --flags as: "A list of tags to filter the actions to run. [array]" Currently the only method that works for supplying multiple tags to the...

Ensure all UDFs have description set in their DDL

2

Make sure all UDFs have description set in the DDL definition [like this UDF](https://github.com/GoogleCloudPlatform/bigquery-utils/blob/896ce01a8a7d65e4517f2832fec8dbd32466bf00/udfs/community/bignumber_add.sqlx#L23)

Dag should load data from gcs to bq and then run a BigQuery script to transform data and materialize in a new table (a common ELT pattern)

Add a queries_grouped_by_session.sql script to the optimization/ scripts

1

DECLARE num_days_to_scan INT64 DEFAULT 30; CREATE TEMP FUNCTION num_stages_with_perf_insights(query_info ANY TYPE) AS ( COALESCE(( SELECT SUM(IF(i.slot_contention, 1, 0) + IF(i.insufficient_shuffle_quota, 1, 0)) FROM UNNEST(query_info.performance_insights.stage_performance_standalone_insights) i), 0) + COALESCE(ARRAY_LENGTH(query_info.performance_insights.stage_performance_change_insights), 0) );...