Skip to content

Powerful Functions to Supercharge BigQuery

150+ Ready-to-Go Functions from the community (no install needed)

Discover the Functions

functions examples
BigQuery can now perform any task with SQL


A Framework for BigQuery functions

Build your own catalog of advanced functions.

Discover the Framework

bigfun command line interface


Keep it Simple
with SQL-Data-Stack

BigQuery, BigFunctions and dataform
is all you need

Discover the SQL Data Stack

  • BigQuery runs SQL

    bigquery logo

  • BigFunctions supercharges SQL

    bigfunctions logo

  • dataform orchestrates SQL

    dataform logo

*dataform can be replaced by any sql orchestrator (dbt, sqlmesh, scheduled queries, etc)

Want BigQuery to send you an email with your KPIs of the day?

It's as easy as a copy & paste!

To send you an email with your KPIs of the day, simply copy the following code and run it in BigQuery. One Click & you got your email. No install needed!

with 

--- Compute the KPIs of the day ---
kpis_of_the_day as (
  select 
    1584  as total_users,
    74863.35 as total_revenue
),

--- Set email recipients (you in this case) ---
recipients as (
  select 
    session_user() as email,
    initcap(replace(split(session_user(), '@')[offset(0)], '.', ' ')) as username,
)


--- Send an Email to recipients (you) with the KPIs of the day ---
select bigfunctions.eu.send_mail(

  email,                    --- Recipient

  "Daily Metrics Summary",  --- Email Subject

  format(                   --- Email Body in markdown format
    """
    ## Hi %s

    *Here is your Daily Metrics Summary*

    - **Total users**: %d
    - **Total revenue**: %.2f $

    Enjoy your day!    
    """,
    username,
    total_users,
    total_revenue
  ),
  null,                     --- Optional Attached file name
  null                      --- Optional Attached file content
)

from kpis_of_the_day, recipients

Taking the most of

gcp