LogoLogo
HOMEBLOG
  • Getting Started
  • Connect to Data
    • Projects
    • Data Connectors
      • Google BigQuery
      • Google Cloud Storage
      • Iceberg
      • Snowflake
      • AWS S3
      • AWS Athena
      • AWS Redshift
      • Databricks Delta
      • Azure Blob
      • Salesforce
      • SAP Hana
      • File Path Options
      • SQL Server
      • Trino
    • Connection Modes
    • Triggering Scans
    • Configuring a Data Source
  • Profiling Data
    • Data Health Metrics
    • Data Health Overview Page
    • Interactive Profiling Tool: Investigator
    • Data Diff
    • Compound Attributes
      • List of Supported Functions
  • Monitoring Data
    • Data Quality Metrics
    • Alert Policies
    • Data Trends and Alerts
    • Metrics Inspector
  • Data Quality Rules
    • Rules Expression Examples
  • PII Data Detection
  • Remediation
    • Data Binning
    • Circuit Breaker
  • Integrations
    • Jira Integration
    • Slack
    • Jobs Status Notification
  • User Management
    • Microsoft Entra IDP Setup
    • Auth0 Setup
    • Okta SSO Setup
    • SSO Configuration
  • API Reference
    • Authentication API
    • API Keys
    • Telmai IP List
    • Get Google Service Account API
  • Source APIs
    • Source APIs
  • Upload Data APIs
    • Upload data from Cloud
      • RedShift Request data
      • GCS Request data
      • Azure Request data
      • GBQ Request data
      • Snowflake Request data
      • Amazon S3 Request data
      • Delta Lake Request
      • Trino Request data
    • Track upload job
    • Check for alerts
  • Admin APIs
    • User Management
  • Telmai Releases
    • Release Notes
      • 25.2.1
      • 25.2.0
      • 25.1.3
      • 25.1.2
      • 25.1.0
Powered by GitBook
On this page
  1. Profiling Data
  2. Compound Attributes

List of Supported Functions

Below is a list of whitelisted functions:

// misc non-aggregate functions
        abs,
        coalesce,
        explode,
        explode_outer,
        greatest,
        if,
        inline,
        inline_outer,
        isnan,
        ifnull,
        isnull,
        isnotnull,
        least,
        nanvl,
        nullif,
        nvl,
        nvl2,
        posexplode,
        posexplode_outer,
        rand,
        random,
        randn,
        stack,
        when,

// math functions
        acos,
        acosh,
        asin,
        asinh,
        atan,
        atan2,
        atanh,
        bin,
        bround,
        cbrt,
        ceil,
        ceiling,
        cos,
        sec,
        cosh,
        conv,
        degrees,
        e,
        exp,
        expm1,
        floor,
        factorial,
        hex,
        hypot,
        log,
        log10,
        log1p,
        log2,
        ln,
        mod,
        negative,
        pi,
        pmod,
        positive,
        pow,
        power,
        radians,
        rint,
        round,
        shiftleft,
        shiftright,
        shiftrightunsigned,
        sign,
        signum,
        sin,
        csc,
        sinh,
        str_to_map,
        sqrt,
        tan,
        cot,
        tanh,
        width_bucket,
        try_add,
        try_divide,
        try_subtract,
        try_multiply,
        try_element_at,
        try_avg,
        try_sum,
        try_to_binary,
        
// string functions
        ascii,
        char,
        chr,
        contains,
        startswith,
        endswith,
        base64,
        bit_length,
        char_length,
        character_length,
        concat_ws,
        decode,
        elt,
        encode,
        find_in_set,
        format_number,
        format_string,
        to_number,
        try_to_number,
        get_json_object,
        initcap,
        instr,
        lcase,
        length,
        levenshtein,
        like,
        ilike,
        lower,
        octet_length,
        locate,
        lpad,
        ltrim,
        json_tuple,
        parse_url,
        position,
        printf,
        regexp_extract,
        regexp_extract_all,
        regexp_replace,
        repeat,
        replace,
        overlay,
        rlike,
        regexp_like,
        regexp,
        rpad,
        rtrim,
        sentences,
        soundex,
        space,
        split,
        split_part,
        substr,
        substring,
        left,
        right,
        substring_index,
        translate,
        trim,
        btrim,
        ucase,
        unbase64,
        unhex,
        upper,
        xpath,
        xpath_boolean,
        xpath_double,
        xpath_number,
        xpath_float,
        xpath_int,
        xpath_long,
        xpath_short,
        xpath_string,
        
// datetime functions
        add_months,
        current_date,
        current_timestamp,
        current_timezone,
        datediff,
        date_add,
        date_format,
        date_sub,
        day,
        dayofyear,
        dayofmonth,
        from_unixtime,
        from_utc_timestamp,
        hour,
        last_day,
        minute,
        month,
        months_between,
        next_day,
        now,
        quarter,
        second,
        to_timestamp,
        to_date,
        to_binary,
        to_unix_timestamp,
        to_utc_timestamp,
        trunc,
        date_trunc,
        unix_timestamp,
        dayofweek,
        weekday,
        weekofyear,
        year,
        window,
        session_window,
        make_date,
        make_timestamp,
        make_interval,
        make_dt_interval,
        make_ym_interval,
        extract,
        date_part,
        date_from_unix_date,
        unix_date,
        timestamp_seconds,
        timestamp_millis,
        timestamp_micros,
        unix_seconds,
        unix_millis,
        unix_micros,
        
// collection functions
        concat,
        
// misc functions
        assert_true,
        raise_error,
        crc32,
        md5,
        uuid,
        hash,
        xxhash64,
        sha,
        sha1,
        sha2,
        aes_encrypt,
        aes_decrypt,
        spark_partition_id,
        input_file_name,
        input_file_block_start,
        input_file_block_length,
        monotonically_increasing_id,
        current_database,
        current_catalog,
        current_user,
        reflect,
        java_method,
        version,
        typeof,
        
// bitwise
        bit_count,
        bit_and,
        bit_or,
        bit_xor,
        bit_get,
        getbit,
        
// json
        to_json,
        from_json,
        schema_of_json,
        json_array_length,
        json_object_keys,
        
// cast
        cast,
        
// Cast aliases
        boolean,
        tinyint,
        smallint,
        int,
        bigint,
        float,
        double,
        decimal,
        date,
        timestamp,
        binary,
        string,
PreviousCompound AttributesNextMonitoring Data

Last updated 9 months ago