GoogleCloudPlatform/bigquery-utils issues and pull requests

#452 - update embedding default batch size

Pull Request - State: open - Opened by saurabh-net 5 days ago

#451 - Update job_execution.sql

Pull Request - State: closed - Opened by franklinWhaite 13 days ago

#450 - fix: honor `offset` when `occurence` is 0

Pull Request - State: open - Opened by shobsi 20 days ago - 1 comment

#449 - Per table usage in big query ?

Issue - State: closed - Opened by upgradedcloud 27 days ago - 1 comment

#448 - Add necessary infrastructure to support unit testing ml stored procs

Pull Request - State: closed - Opened by danieldeleo about 1 month ago

#447 - Fix README links

Pull Request - State: closed - Opened by saurabh-net about 1 month ago - 1 comment

#446 - Bqml gen text

Pull Request - State: closed - Opened by saurabh-net about 1 month ago - 4 comments

#445 - Minor fixes to BQML Generate Embedding

Pull Request - State: closed - Opened by saurabh-net about 1 month ago - 4 comments

#444 - Per user cost in BigQuery

Issue - State: closed - Opened by upgradedcloud about 1 month ago - 2 comments

#443 - Convert stored procedures to SQLX and globally deploy them in bqutil project

Pull Request - State: closed - Opened by danieldeleo about 1 month ago - 10 comments

#442 - Dataform versions >=2.8.2 break UDF unit testing

Issue - State: closed - Opened by danieldeleo about 1 month ago

#441 - Change ts_tumble UDF implementation to use TIMESTAMP_BUCKET function

Pull Request - State: closed - Opened by avityuk about 1 month ago - 4 comments

#440 - Some minor updates to the BQML Generate Embedding procedure

Pull Request - State: closed - Opened by saurabh-net about 2 months ago

#439 - Fix community UDF README links

Pull Request - State: closed - Opened by nicklamiller about 2 months ago - 3 comments

#438 - [Sketch] Make merge more defensive for calling order

Pull Request - State: closed - Opened by bdw-g about 2 months ago - 1 comment

#437 - Add stored procedure for BQML Generate Embedding

Pull Request - State: closed - Opened by saurabh-net about 2 months ago

#436 - Make xml_to_json UDF emit JSON that is closer to the XML structure

Pull Request - State: closed - Opened by danieldeleo about 2 months ago - 2 comments

#435 - fix typo in payload example

Pull Request - State: open - Opened by regadas about 2 months ago

#434 - Add xml_to_json udf

Pull Request - State: closed - Opened by danieldeleo about 2 months ago - 4 comments

#433 - Missing UDF in region europe-west3

Issue - State: closed - Opened by ex0ns 2 months ago - 2 comments

#432 - Exporting protobuf column with nested message definitions

Issue - State: closed - Opened by kball-pa 2 months ago - 1 comment

#431 - updating README and UD(A)F descriptions for datasketches functions

Pull Request - State: closed - Opened by nikunjbhartia 3 months ago - 2 comments

#430 - Bump semver from 5.7.1 to 5.7.2 in /tools/vscode_sql_extraction

Pull Request - State: open - Opened by dependabot[bot] 3 months ago
Labels: dependencies, javascript

#429 - Bump minimist from 1.2.5 to 1.2.8 in /tools/vscode_sql_extraction

Pull Request - State: open - Opened by dependabot[bot] 3 months ago
Labels: dependencies, javascript

#428 - Bump path-parse from 1.0.6 to 1.0.7 in /tools/vscode_sql_extraction

Pull Request - State: open - Opened by dependabot[bot] 3 months ago
Labels: dependencies, javascript

#427 - Bump com.google.guava:guava from 30.0-jre to 32.0.0-jre in /tools/query_breakdown

Pull Request - State: open - Opened by dependabot[bot] 3 months ago
Labels: dependencies, java

#426 - Add support for non-aggregate inputs to UDAFs

Pull Request - State: closed - Opened by danieldeleo 3 months ago - 2 comments

#425 - Add support for unit testing UDAFs (user defined aggregate functions)…

Pull Request - State: closed - Opened by danieldeleo 3 months ago - 1 comment

#424 - Bump braces from 3.0.2 to 3.0.3 in /tools/vscode_automatic_query_fixer

Pull Request - State: open - Opened by dependabot[bot] 3 months ago
Labels: dependencies, javascript

#423 - add support for datasketches js udafs using wasm libraries

Pull Request - State: closed - Opened by nikunjbhartia 3 months ago - 5 comments

#422 - Add a queries_grouped_by_session.sql script to the optimization/ scripts

Issue - State: open - Opened by danieldeleo 3 months ago - 1 comment
Labels: enhancement

#421 - Adding studentt_cdf UDF

Pull Request - State: closed - Opened by dqmis 4 months ago - 2 comments

#420 - BQ Simba JDBC Driver Custom Java Client Sample

Pull Request - State: closed - Opened by dmedora 4 months ago

#419 - Add optimized partitioning UDF for `MATCH_RECOGNIZE`.

Pull Request - State: closed - Opened by mswapnilG 4 months ago - 2 comments

#418 - Translation Engine UDF for GETBIT on binary type.

Pull Request - State: closed - Opened by damian-compilerworks 4 months ago - 1 comment

#417 - fixes jaccard bug

Pull Request - State: closed - Opened by afleisc 4 months ago - 4 comments

#416 - Update typeof function for new RANGE datatype

Issue - State: closed - Opened by vlulla 4 months ago - 1 comment

#415 - Case statements for the RANGE type.

Pull Request - State: closed - Opened by vlulla 4 months ago - 6 comments

#414 - Translation Engine UDF for emulating WIDTH_BUCKET.

Pull Request - State: closed - Opened by damian-compilerworks 4 months ago - 2 comments

#413 - simplified query insights

Pull Request - State: open - Opened by afleisc 4 months ago - 1 comment

#412 - Refactor run_unit_tests.sh to allow users to build UDFs in their own Cloud Build env

Pull Request - State: closed - Opened by danieldeleo 4 months ago - 2 comments

#411 - Specify workerpool via command line args to allow users to run builds…

Pull Request - State: closed - Opened by danieldeleo 4 months ago - 1 comment

#410 - Add `MATCH_RECOGNIZE` related UDFs to the community UDFs.

Pull Request - State: closed - Opened by mswapnilG 4 months ago - 3 comments

#409 - remove / for broken links in system_tables

Pull Request - State: closed - Opened by afleisc 4 months ago

#408 - feat: add json_extract_key_value_pairs UDF

Pull Request - State: closed - Opened by plaflamme 5 months ago - 3 comments

#407 - update var_n_days to num_days_to_scan in daily_reservation_analysis.sql

Pull Request - State: closed - Opened by afleisc 5 months ago - 1 comment

#406 - Add checks to only run regional builds for UDFs

Pull Request - State: closed - Opened by danieldeleo 5 months ago - 1 comment

#405 - Terraform for GCS buckets and Build triggers to deploy UDF to all regions

Pull Request - State: closed - Opened by afleisc 5 months ago - 3 comments

#404 - Deploy UDFs to all regions in bqutil

Pull Request - State: closed - Opened by afleisc 5 months ago - 3 comments

#403 - day variable name "var_n_days " should be replaced by "num_days_to_scan"

Issue - State: closed - Opened by celiajmd 5 months ago - 1 comment

#402 - Bump protobufjs from 7.2.3 to 7.2.5 in /tools/protobuf_export

Pull Request - State: open - Opened by dependabot[bot] 6 months ago
Labels: dependencies, javascript

#401 - Ensure all UDFs have description set in their DDL #354

Pull Request - State: open - Opened by magar51 6 months ago

#400 - Initialize workspace

Pull Request - State: closed - Opened by ParitoshGit12 6 months ago - 1 comment

#399 - making anti pattern opitmization script generic for any input table

Pull Request - State: closed - Opened by franklinWhaite 6 months ago - 3 comments

#398 - adding code for bigquery policy tag extractor

Pull Request - State: open - Opened by karcot1 6 months ago - 2 comments

#397 - Adding Anti-pattern Recognition tool to the Optimization Scripts

Pull Request - State: closed - Opened by franklinWhaite 6 months ago

#396 - Export data as protocol buffer does not work for more than one field

Issue - State: closed - Opened by sanimesa 8 months ago - 2 comments

#395 - Update typeof. Support of single quoted JSON

Pull Request - State: open - Opened by tartas1 8 months ago - 1 comment

#394 - BigQuery CAI Scripts

Pull Request - State: open - Opened by timothymanuel 8 months ago

#393 - Adding the distinction between resource-based and spend-based CUDs

Pull Request - State: open - Opened by Bento-87 9 months ago

#392 - Add the Reservation Analysis script

Pull Request - State: closed - Opened by timothymanuel 9 months ago

#391 - Update README.md to include optimization directory

Pull Request - State: closed - Opened by ryanmcdowell 9 months ago

#390 - Update queries_grouped_by_hash.sql

Pull Request - State: closed - Opened by afleisc 9 months ago

#389 - Translation Engine UDF for parsing TD number strings.

Pull Request - State: closed - Opened by damian-compilerworks 11 months ago

#388 - Add an implementation of Snowflake's 'flatten' function.

Pull Request - State: closed - Opened by Hackerpilot 11 months ago

#387 - Configure Renovate

Pull Request - State: closed - Opened by renovate-bot 12 months ago - 1 comment

#386 - [UDF] strtok null safety

Pull Request - State: closed - Opened by bdw-g 12 months ago

#385 - [UDF] Add strtok function for teradata emulation

Pull Request - State: closed - Opened by bdw-g 12 months ago

#384 - BigQuery UDFs not available outside the US and documentation unclear?

Issue - State: closed - Opened by brabster 12 months ago - 1 comment

#383 - Bug: Jaccard UDF giving incorrect results in some cases

Issue - State: closed - Opened by j-svensmark about 1 year ago - 1 comment
Labels: bug

#382 - [UDF] Fix `cw_regexp_instr_3` assumption that `start` argument is 0-based.

Pull Request - State: closed - Opened by paolomorandini about 1 year ago

#381 - Discussion: Create bqutil UDFs in all other non-US datasets

Issue - State: closed - Opened by 1987yama3 about 1 year ago - 1 comment

#380 - Bump com.google.guava:guava from 30.0-jre to 32.0.0-jre in /tools/query_breakdown

Pull Request - State: closed - Opened by dependabot[bot] about 1 year ago - 1 comment
Labels: dependencies, java

#379 - Missing Datasource for Hourly Utilization Heatmap section

Issue - State: open - Opened by sethijaideep about 1 year ago
Labels: bug

#378 - Align code examples

Pull Request - State: closed - Opened by ron-gal about 1 year ago

#377 - UDF `cw_convert_base` should return NULL on NULL inputs.

Pull Request - State: closed - Opened by paolomorandini about 1 year ago

#376 - Adding BigQuery optimization scripts

Pull Request - State: closed - Opened by danieldeleo about 1 year ago

#375 - update largest tables scripts

Pull Request - State: closed - Opened by CYarros10 about 1 year ago - 1 comment

#367 - Add report showing projects using on demand slots

Issue - State: open - Opened by jdub55 about 1 year ago
Labels: enhancement

#365 - Some of the hyperlink is not working

Issue - State: closed - Opened by johanesalxd over 1 year ago

#354 - Ensure all UDFs have description set in their DDL

Issue - State: open - Opened by danieldeleo over 1 year ago - 2 comments
Labels: documentation

#350 - Request: Handling for objects in json_extract_values function

Issue - State: closed - Opened by sgoley over 1 year ago - 2 comments

#341 - Unable to view the images in bigquery-utils folder.

Issue - State: closed - Opened by saivasanth528 over 1 year ago - 1 comment

#340 - Security Policy violation Binary Artifacts

Issue - State: open - Opened by google-allstar-prod[bot] almost 2 years ago - 129 comments
Labels: allstar

#339 - Add json_merge UDF function

Pull Request - State: closed - Opened by ismailsimsek almost 2 years ago - 1 comment

#334 - Handling Invalid input for `fn.json_extract_keys`, `fn.json_extract_values`

Pull Request - State: closed - Opened by takegue almost 2 years ago - 4 comments

#285 - System Table Dashboards - Load Slot Estimator

Issue - State: open - Opened by sdeutscherkobayashi over 2 years ago
Labels: bug

#281 - Missing values are not taken into account in UDF "median".

Issue - State: closed - Opened by ryota-tanimoto over 2 years ago - 1 comment
Labels: bug

#280 - Documentation for new users is difficult to follow

Issue - State: open - Opened by kerryleith over 2 years ago - 4 comments
Labels: documentation

#275 - Too many subqueries or query is too complex for "Job Concurrency Slow"

Issue - State: open - Opened by charlibot over 2 years ago - 4 comments
Labels: bug

#272 - Add missing phone_assertions.js file

Pull Request - State: open - Opened by danieldeleo almost 3 years ago

#256 - Datastudio error

Issue - State: open - Opened by antoinecastex about 3 years ago
Labels: bug

#252 - Create bqutil UDFs in all other non-US datasets

Issue - State: closed - Opened by davidvanrooij about 3 years ago - 7 comments

#217 - Update UDF contributing docs

Issue - State: open - Opened by danieldeleo over 3 years ago - 5 comments
Labels: documentation

#214 - Errors while creating the BigQuery audit logs view

Issue - State: open - Opened by MonicaPC1 over 3 years ago - 1 comment
Labels: bug

#132 - replace_with_test_datasets function fails in local testing (not in cloud build)

Issue - State: open - Opened by danieldeleo about 4 years ago
Labels: bug

#54 - random_value UDF result is re-used by query optimizer when invoked in subquery

Issue - State: open - Opened by danieldeleo over 4 years ago
Labels: bug

#52 - Host UDF test framework on PyPi for ease of use in other projects

Issue - State: open - Opened by jaketf over 4 years ago
Labels: enhancement

#5 - Feature Request: Authorized View Generator / Refresher script

Issue - State: open - Opened by jaketf about 5 years ago
Labels: enhancement

#2 - Make Dataset Location Configurable

Issue - State: closed - Opened by ryanmcdowell about 5 years ago - 1 comment

GitHub / GoogleCloudPlatform/bigquery-utils issues and pull requests