BigQuery Create Persistent Function

QueryStash

BigQuery Create Persistent Function

Example of using Persistent UDF functions on BigQuery.

This simple example takes a URL string and returns a Platform name by using a simple CASE statement to define our mapping logic.

To learn more about how to create and use UDF functions read the full tutorial here.

1CREATE OR REPLACE FUNCTION `query-stash.functions.DOMAIN_MAPPING`(url STRING) AS (
2  CASE
3    WHEN url IS NULL THEN NULL
4    WHEN REGEXP_CONTAINS(url, '(?i)(twitter.com)') THEN 'Twitter'
5    WHEN REGEXP_CONTAINS(url, '(?i)(youtube.com|youtu.be)') THEN 'YouTube'
6    ELSE 'Unknown'
7  END
8);

CREATE OR REPLACE FUNCTION `query-stash.functions.DOMAIN_MAPPING`(url STRING) AS (
  CASE
    WHEN url IS NULL THEN NULL
    WHEN REGEXP_CONTAINS(url, '(?i)(twitter.com)') THEN 'Twitter'
    WHEN REGEXP_CONTAINS(url, '(?i)(youtube.com|youtu.be)') THEN 'YouTube'
    ELSE 'Unknown'
  END
);

Public

udf bigquery

QueryStash

Created: Apr 7th 2022

QueryStash

Made with ❤️ by @Yekalb

Twitter Facebook Email

Resources

Blog Pricing Your First Query Search Your Stash

Examples

Merge Statements Persistent Functions Spike Detection QUALIFY Statement BigQuery ML Models

Stay up to date