Pinned Loading

1. GoogleCloudPlatform/cloud-data-quality GoogleCloudPlatform/cloud-data-quality Public

   Data Quality Engine for BigQuery

   Python 258 57

2. Colab Notebook/Python code to get Pu... Colab Notebook/Python code to get PubSub Stackdriver Metric

   1

   {

   2

     "nbformat": 4,

   3

     "nbformat_minor": 0,

   4

     "metadata": {

   5

       "colab": {

3. BQ-GIS-LondonCycle-Demo BQ-GIS-LondonCycle-Demo

   1

   {

   2

    "cells": [

   3

     {

   4

      "cell_type": "code",

   5

      "execution_count": 1,

4. Merkle Tree Calculations in BigQuery... Merkle Tree Calculations in BigQuerySQL based on https://datprotocol.github.io/book/ch01-02-merkle-tree.html

   1

   CREATE OR REPLACE FUNCTION udf_sql.uint64be(x INT64) RETURNS BYTES AS (

   2

       CAST((SELECT STRING_AGG(FORMAT("%x",x >> bit & 0x1), "" ORDER BY bit DESC)

   3

      FROM UNNEST(GENERATE_ARRAY(0, 63)) AS bit) AS BYTES)

   4

   )

   5

   ;