JustFunctions for BigQuery
A collection of open-source functions (UDFs) that extend BigQuery capabilities to solve complex real-life business cases.
NLP
Operations
- convert_json_to_struct(string)
- dedup_table(table_name, timestamp_column, unique_column, output_table_suffix)
- generate_date_calendar(table_name, start_date, end_date)
- generate_date_calendar_with_holidays(table_name, start_date, end_date, country)
- generate_dbt_yml_schema(project_id, dataset_id)
- generate_hour_calendar(table_name)
- generate_justsql_schema(project_id, dataset_id, tables)
- greatest_not_null(arr)
- least_not_null(arr)
- parse_yaml(string)
- surrogate_key(string)
- surrogate_key_str(string)
URL
Date
Email
Statistics
Other
UserAgent
Analytics