PRODUCT
LEARN
CAREERS
ABOUT US

Hide navigation sidebar

Hide table of contents sidebar

Toggle site navigation sidebar

documentation

Toggle table of contents sidebar

Learn about Observe

Getting Started with Observe
Key Observe Concepts
Toggle navigation of Key Observe Concepts
- Advanced Observe Concepts
- Exploring Data
About Queries and On-demand Acceleration
Observe Datasets and Time
Toggle navigation of Observe Datasets and Time
Navigating the Workspace
Toggle navigation of Navigating the Workspace
Observe Tutorials
Toggle navigation of Observe Tutorials

Get Data into Observe

Observe Integrations
Toggle navigation of Observe Integrations
- Observe Apps
- Amazon Web Services (AWS) Integration
  Toggle navigation of Amazon Web Services (AWS) Integration
  - Amazon CloudFront
  - Amazon EC2
  - Amazon Elastic Container Service
    Toggle navigation of Amazon Elastic Container Service
    - Amazon Elastic Container Service Metrics
  - Amazon RDS
    Toggle navigation of Amazon RDS
    - Amazon RDS Metrics
  - AWS Lambda
    Toggle navigation of AWS Lambda
    - AWS Lambda metrics
  - Elastic Load Balancing
    Toggle navigation of Elastic Load Balancing
    - Elastic Load Balancing Metrics
- Basic Threat Intel Integration
  Toggle navigation of Basic Threat Intel Integration
  - Installing the Basic Threat Intel App
  - Using Unified Basic Threat Intel Datasets with Observe
    Toggle navigation of Using Unified Basic Threat Intel Datasets with Observe
- Drata App (Public Preview)
  Toggle navigation of Drata App (Public Preview)
  - Installing the Drata App
- Fastly (Public Preview)
  Toggle navigation of Fastly (Public Preview)
  - Fastly app installation guide
  - Uninstalling the Fastly App
- Google Cloud Platform (GCP) App
  Toggle navigation of Google Cloud Platform (GCP) App
  - GCP Asset Inventory
  - GCP BigQuery
  - GCP Cloud Functions
    Toggle navigation of GCP Cloud Functions
    - GCP Cloud Functions metrics
  - GCP Cloud Load Balancing
    Toggle navigation of GCP Cloud Load Balancing
    - GCP Cloud Load Balancing Metrics
  - GCP Cloud Run
    Toggle navigation of GCP Cloud Run
    - GCP Cloud Run Metrics
  - GCP Cloud SQL
    Toggle navigation of GCP Cloud SQL
    - GCP Cloud SQL Metrics
  - GCP Cloud Storage
    Toggle navigation of GCP Cloud Storage
    - GCP Cloud Storage Metrics
  - GCP Compute
    Toggle navigation of GCP Compute
    - GCP Compute Metrics
  - GCP Logging
  - GCP Cloud Metrics
  - Google Kubernetes Engine
  - Memorystore Redis
- Google Cloud Platform Quickstart (Preview)
- GitHub
  Toggle navigation of GitHub
- GitLab
  Toggle navigation of GitLab
- Host Monitoring
  Toggle navigation of Host Monitoring
  - Installing the Host Monitoring App
    Toggle navigation of Installing the Host Monitoring App
  - Uninstalling the Host Monitoring App
- Host Quickstart (Preview)
- Jenkins CI/CD Integration
  Toggle navigation of Jenkins CI/CD Integration
  - Installing the Jenkins App
  - Uninstalling the Jenkins App
- Kubernetes
  Toggle navigation of Kubernetes
  - Installing the Kubernetes App
  - Collecting Pod Metrics and cAdvisor Metrics
- Microsoft Azure
  Toggle navigation of Microsoft Azure
- MongoDB Atlas
  Toggle navigation of MongoDB Atlas
  - Installing the MongoDB Atlas App
  - Updating the MongoDB Atlas App and Poller
- MySQL Database Service
  Toggle navigation of MySQL Database Service
  - Installing the MySQL DB App
  - Uninstalling the MySQL DB App
- Node Exporter
- OpenAI (Public Preview)
- OpenTelemetry App
- Orca Security App (Public Preview)
  Toggle navigation of Orca Security App (Public Preview)
  - Installing the Orca Security App
- PostgreSQL Database Service
  Toggle navigation of PostgreSQL Database Service
  - Installing the PostgreSQL DB App
  - Uninstalling the PostgreSQL DB App
- Prometheus Metrics (Public Preview)
  Toggle navigation of Prometheus Metrics (Public Preview)
  - Installing the Prometheus Metrics App
  - Tutorial: Getting Started with Observe and Prometheus
- Security Onion App (Public Preview)
  Toggle navigation of Security Onion App (Public Preview)
  - Installing the Security Onion App
- Service Level Objectives (SLOs)
  Toggle navigation of Service Level Objectives (SLOs)
  - Installing the Service Level Objective App
Data Ingestion
Toggle navigation of Data Ingestion
- Datastreams
- Sources
  Toggle navigation of Sources
- Forwarders
  Toggle navigation of Forwarders
- Endpoints
  Toggle navigation of Endpoints
- Troubleshooting Data Ingestion
Collecting and Using Metrics
Toggle navigation of Collecting and Using Metrics
Using custom trace & span datasets

Explore Your Data

Working with the Log Explorer
Working with the Metrics Explorer
Working with the Trace Explorer
Working with the Resource Explorer
Creating Dashboards
Toggle navigation of Creating Dashboards
- Using Dashboards
Creating and Sharing Worksheets
Toggle navigation of Creating and Sharing Worksheets
- Working with Data Formats and Types

Create Alerts and Monitors

Introduction to Monitors and Alerts
Toggle navigation of Introduction to Monitors and Alerts
Overview of Shared Actions
Toggle navigation of Overview of Shared Actions
- Customizing Alert Messages
- Shared Action Integrations
  Toggle navigation of Shared Action Integrations

Manage Observe

Authentication and Authorization in Observe
Toggle navigation of Authentication and Authorization in Observe
- Role Based Access Control
- Single Sign On (SSO) Configurations for Observe
  Toggle navigation of Single Sign On (SSO) Configurations for Observe
- Observe API Authentication
- Adding Role-Based Access Control with Terraform
Customizing the Home Page
Creating and Using Favorites
Using O11y GPT Help
Settings
Using Acceleration Manager with Datasets
Using Credit Manager
Understanding the Usage Dashboard
Working with Observe and Terraform
Toggle navigation of Working with Observe and Terraform

Develop with Observe

Exporting Query Results in CSV or JSON Format
Developer Toolkit Overview
URL Query Parameters
Observe Command Line Interface Tool Overview
Toggle navigation of Observe Command Line Interface Tool Overview
Snowflake Outbound Sharing

Reference

Visualization Types Reference
Observe OPAL Query Language Reference
Toggle navigation of Observe OPAL Query Language Reference
- OPAL — Observe Processing and Analysis Language
  Toggle navigation of OPAL — Observe Processing and Analysis Language
  - Data Types and Operators
  - Language syntax
  - Performance
  - Examples
  - All OPAL functions
    Toggle navigation of All OPAL functions
    - OPAL Functions By Category
      Toggle navigation of OPAL Functions By Category
      - OPAL Aggregate Functions
        Toggle navigation of OPAL Aggregate Functions
        
        any
        
        any_not_null
        
        array_agg
        
        array_agg_distinct
        
        array_union_agg
        
        avg
        
        count
        
        count_distinct
        
        count_distinct_exact
        
        delta
        
        delta_monotonic
        
        deriv
        
        first
        
        first_not_null
        
        last
        
        last_not_null
        
        max
        
        median
        
        median_exact
        
        min
        
        object_agg
        
        percentile
        
        percentile_cont
        
        percentile_disc
        
        prom_quantile
        
        rate
        
        stddev
        
        string_agg
        
        string_agg_distinct
        
        sum
        
        tdigest_agg
        
        tdigest_combine
        
        topk_agg
      - OPAL Boolean Functions
        Toggle navigation of OPAL Boolean Functions
        
        array_contains
        
        arrays_overlap
        
        bool
        
        bool_null
        
        contains
        
        ends_with
        
        eq
        
        gt
        
        gte
        
        in
        
        ipv4_address_in_network
        
        is_null
        
        like
        
        lt
        
        lte
        
        match_regex
        
        ne
        
        path_exists
        
        same
        
        search
        
        starts_with
      - OPAL Misc Functions
        Toggle navigation of OPAL Misc Functions
        
        asc
        
        coalesce
        
        desc
        
        float64
        
        frame
        
        frame_exact
        
        hash
        
        if
        
        if_null
        
        int64
        
        m_tdigest
        
        nullsfirst
        
        nullslast
        
        on
        
        order_by
        
        parse_hex
        
        strlen
        
        tdigest_null
        
        tdigest_quantile
        
        variant_null
      - OPAL Networking Functions
        Toggle navigation of OPAL Networking Functions
        
        int64_to_ipv4
        
        ipv4
        
        ipv4_address_in_network
        
        ipv4_network_int64
        
        ipv4_to_int64
        
        parse_ip
      - OPAL Numeric Functions
        Toggle navigation of OPAL Numeric Functions
        
        abs
        
        ceil
        
        count
        
        delta
        
        delta_monotonic
        
        dense_rank
        
        exp
        
        float64_null
        
        floor
        
        haversine_distance_km
        
        int64_null
        
        int_div
        
        ln
        
        log
        
        mod
        
        numeric_null
        
        percentile_disc
        
        pow
        
        prom_quantile
        
        rank
        
        round
        
        row_number
        
        sqrt
        
        uniform
        
        width_bucket
        
        zipf
      - OPAL Regex Functions
        Toggle navigation of OPAL Regex Functions
        
        get_regex
        
        get_regex_all
        
        match_regex
        
        regex
        
        replace_regex
      - OPAL Semistructured Functions
        Toggle navigation of OPAL Semistructured Functions
        
        append_item
        
        array
        
        array_agg
        
        array_agg_distinct
        
        array_contains
        
        array_distinct
        
        array_length
        
        array_max
        
        array_min
        
        array_null
        
        array_to_string
        
        array_union_agg
        
        arrays_overlap
        
        concat_arrays
        
        detect_browser
        
        drop_fields
        
        embed_sql_params
        
        get_field
        
        get_item
        
        get_jmespath
        
        get_regex_all
        
        index_of_item
        
        insert_item
        
        intersect_arrays
        
        make_array
        
        make_array_range
        
        make_fields
        
        make_object
        
        merge_objects
        
        object
        
        object_agg
        
        object_keys
        
        object_null
        
        parse_csv
        
        parse_ip
        
        parse_json
        
        parse_kvs
        
        parse_url
        
        path_exists
        
        pick_fields
        
        pivot_array
        
        prepend_item
        
        slice_array
        
        sort_array
        
        split
        
        tokenize
        
        topk_agg
        
        unpivot_array
      - OPAL Special Functions
        Toggle navigation of OPAL Special Functions
        
        case
        
        group_by
        
        m
        
        metric
        
        options
        
        primary_key
        
        pk
        
        valid_for
        
        window
      - OPAL String Functions
        Toggle navigation of OPAL String Functions
        
        array_to_string
        
        concat_strings
        
        contains
        
        decode_base64
        
        decode_uri
        
        decode_uri_component
        
        detect_browser
        
        editdistance
        
        embed_sql_params
        
        encode_base64
        
        encode_uri
        
        encode_uri_component
        
        ends_with
        
        format_time
        
        get_regex
        
        int64_to_ipv4
        
        left
        
        like
        
        lower
        
        lpad
        
        ltrim
        
        parse_csv
        
        parse_kvs
        
        parse_timestamp
        
        pivot_array
        
        position
        
        regex
        
        replace
        
        replace_regex
        
        right
        
        rpad
        
        rtrim
        
        search
        
        split
        
        split_part
        
        starts_with
        
        string
        
        string_agg
        
        string_agg_distinct
        
        string_null
        
        substring
        
        tokenize
        
        tokenize_part
        
        trim
        
        unpivot_array
        
        upper
        
        variant_type_name
      - OPAL Time Functions
        Toggle navigation of OPAL Time Functions
        
        abs
        
        avg
        
        bin_end_time
        
        bin_size
        
        bin_start_time
        
        delta
        
        delta_monotonic
        
        deriv
        
        duration
        
        duration_hr
        
        duration_min
        
        duration_ms
        
        duration_null
        
        duration_sec
        
        format_time
        
        from_milliseconds
        
        timestamp_ms
        
        from_nanoseconds
        
        timestamp_ns
        
        from_seconds
        
        timestamp_s
        
        median
        
        median_exact
        
        now
        
        parse_duration
        
        parse_isotime
        
        parse_timestamp
        
        percentile
        
        percentile_cont
        
        percentile_disc
        
        query_end_time
        
        query_start_time
        
        rate
        
        row_end_time
        
        row_timestamp
        
        row_start_time
        
        stddev
        
        sum
        
        tdigest_agg
        
        timestamp_null
        
        to_days
        
        to_hours
        
        to_milliseconds
        
        to_minutes
        
        to_nanoseconds
        
        to_seconds
        
        to_weeks
        
        valid_for
      - OPAL Window Functions
        Toggle navigation of OPAL Window Functions
        
        any
        
        any_not_null
        
        array_union_agg
        
        avg
        
        count
        
        count_distinct
        
        count_distinct_exact
        
        delta
        
        delta_monotonic
        
        dense_rank
        
        deriv
        
        first
        
        first_not_null
        
        lag
        
        lag_not_null
        
        last
        
        last_not_null
        
        lead
        
        lead_not_null
        
        max
        
        median
        
        median_exact
        
        min
        
        object_agg
        
        percentile
        
        percentile_cont
        
        percentile_disc
        
        rank
        
        rate
        
        row_number
        
        stddev
        
        sum
        
        tdigest_agg
        
        tdigest_combine
        
        topk_agg
      - OPAL Deprecated Function Aliases
        Toggle navigation of OPAL Deprecated Function Aliases
        
        any_null
        
        array_pivot
        
        array_unpivot
        
        countdistinct
        
        countdistinctexact
        
        decodebase64
        
        denserank
        
        encodebase64
        
        endswith
        
        groupby
        
        ifnull
        
        isnull
        
        makeobject
        
        match_regex_all
        
        medianexact
        
        milliseconds
        
        nanoseconds
        
        orderby
        
        parsehex
        
        parseip
        
        parseisotime
        
        parsejson
        
        parsekvs
        
        parseurl
        
        percentilecont
        
        percentiledisc
        
        primarykey
        
        queryendtime
        
        querystarttime
        
        regex_match
        
        regex_replace
        
        row_endtime
        
        rownumber
        
        seconds
        
        startswith
        
        strcat
        
        string_concat
        
        validfor
  - All OPAL verbs
    Toggle navigation of All OPAL verbs
    - OPAL Verbs By Category
      Toggle navigation of OPAL Verbs By Category
      - OPAL Aggregate Verbs
        Toggle navigation of OPAL Aggregate Verbs
        
        aggregate
        
        align
        
        dedup
        
        distinct
        
        histogram
        
        make_session
        
        merge_events
        
        pivot
        
        rollup
        
        statsby
        
        timechart
        
        bucketize
        
        timestats
        
        unpivot
      - OPAL Filter Verbs
        Toggle navigation of OPAL Filter Verbs
        
        always
        
        bottomk
        
        ever
        
        filter
        
        filter_last
        
        limit
        
        never
        
        topk
      - OPAL Join Verbs
        Toggle navigation of OPAL Join Verbs
        
        exists
        
        follow
        
        follow_not
        
        fulljoin
        
        join
        
        leftjoin
        
        lookup
        
        lookup_ip_info
        
        not_exists
        
        surrounding
        
        union
        
        update_resource
      - OPAL Metadata Verbs
        Toggle navigation of OPAL Metadata Verbs
        
        add_key
        
        drop_interface
        
        interface
        
        make_event
        
        make_interval
        
        make_resource
        
        make_session
        
        make_table
        
        merge_events
        
        set_col_enum
        
        set_col_immutable
        
        set_col_searchable
        
        set_col_visible
        
        set_label
        
        set_link
        
        set_metric
        
        set_metric_metadata
        
        set_primary_key
        
        set_pk
        
        set_valid_from
        
        set_valid_to
        
        sort
        
        unset_all_links
        
        unset_keys
        
        unset_link
        
        unsort
      - OPAL Metrics Verbs
        Toggle navigation of OPAL Metrics Verbs
        
        aggregate
        
        align
        
        rollup
        
        set_metric
      - OPAL Projection Verbs
        Toggle navigation of OPAL Projection Verbs
        
        drop_col
        
        extract_regex
        
        make_col
        
        pick_col
        
        rename_col
      - OPAL Semistructured Verbs
        Toggle navigation of OPAL Semistructured Verbs
        
        extract_regex
        
        flatten
        
        flatten_all
        
        flatten_leaves
        
        flatten_single
      - OPAL Deprecated Verb Aliases
        Toggle navigation of OPAL Deprecated Verb Aliases
        
        addfk
        
        addkey
        
        addmetric
        
        changelog
        
        coldrop
        
        colenum
        
        colimmutable
        
        colmake
        
        colpick
        
        colregex
        
        colrename
        
        colshow
        
        droptime
        
        fkdrop
        
        flattenall
        
        flattenleaves
        
        flattensingle
        
        makeresource
        
        makesession
        
        merge_event
        
        mergeevent
        
        reaggregate
        
        setlabel
        
        setpk
        
        setvf
        
        setvt
  - Language syntax
  - Examples
  - Performance
  - Data Types and Operators
- Language syntax
- Data Types and Operators
- Observe Performance Cookbook
  Toggle navigation of Observe Performance Cookbook
- Examples
- All OPAL functions
  Toggle navigation of All OPAL functions
  - OPAL Functions By Category
    Toggle navigation of OPAL Functions By Category
    - OPAL Aggregate Functions
      Toggle navigation of OPAL Aggregate Functions
      - any
      - any_not_null
      - array_agg
      - array_agg_distinct
      - array_union_agg
      - avg
      - count
      - count_distinct
      - count_distinct_exact
      - delta
      - delta_monotonic
      - deriv
      - first
      - first_not_null
      - last
      - last_not_null
      - max
      - median
      - median_exact
      - min
      - object_agg
      - percentile
      - percentile_cont
      - percentile_disc
      - prom_quantile
      - rate
      - stddev
      - string_agg
      - string_agg_distinct
      - sum
      - tdigest_agg
      - tdigest_combine
      - topk_agg
    - OPAL Boolean Functions
      Toggle navigation of OPAL Boolean Functions
      - array_contains
      - arrays_overlap
      - bool
      - bool_null
      - contains
      - ends_with
      - eq
      - gt
      - gte
      - in
      - ipv4_address_in_network
      - is_null
      - like
      - lt
      - lte
      - match_regex
      - ne
      - path_exists
      - same
      - search
      - starts_with
    - OPAL Misc Functions
      Toggle navigation of OPAL Misc Functions
      - asc
      - coalesce
      - desc
      - float64
      - frame
      - frame_exact
      - hash
      - if
      - if_null
      - int64
      - m_tdigest
      - nullsfirst
      - nullslast
      - on
      - order_by
      - parse_hex
      - strlen
      - tdigest_null
      - tdigest_quantile
      - variant_null
    - OPAL Networking Functions
      Toggle navigation of OPAL Networking Functions
    - OPAL Numeric Functions
      Toggle navigation of OPAL Numeric Functions
      - abs
      - ceil
      - count
      - delta
      - delta_monotonic
      - dense_rank
      - exp
      - float64_null
      - floor
      - haversine_distance_km
      - int64_null
      - int_div
      - ln
      - log
      - mod
      - numeric_null
      - percentile_disc
      - pow
      - prom_quantile
      - rank
      - round
      - row_number
      - sqrt
      - uniform
      - width_bucket
      - zipf
    - OPAL Regex Functions
      Toggle navigation of OPAL Regex Functions
    - OPAL Semistructured Functions
      Toggle navigation of OPAL Semistructured Functions
    - OPAL Special Functions
      Toggle navigation of OPAL Special Functions
      - case
      - group_by
      - m
      - metric
      - options
      - primary_key
      - pk
      - valid_for
      - window
    - OPAL String Functions
      Toggle navigation of OPAL String Functions
      - array_to_string
      - concat_strings
      - contains
      - decode_base64
      - decode_uri
      - decode_uri_component
      - detect_browser
      - editdistance
      - embed_sql_params
      - encode_base64
      - encode_uri
      - encode_uri_component
      - ends_with
      - format_time
      - get_regex
      - int64_to_ipv4
      - left
      - like
      - lower
      - lpad
      - ltrim
      - parse_csv
      - parse_kvs
      - parse_timestamp
      - pivot_array
      - position
      - regex
      - replace
      - replace_regex
      - right
      - rpad
      - rtrim
      - search
      - split
      - split_part
      - starts_with
      - string
      - string_agg
      - string_agg_distinct
      - string_null
      - substring
      - tokenize
      - tokenize_part
      - trim
      - unpivot_array
      - upper
      - variant_type_name
    - OPAL Time Functions
      Toggle navigation of OPAL Time Functions
      - abs
      - avg
      - bin_end_time
      - bin_size
      - bin_start_time
      - delta
      - delta_monotonic
      - deriv
      - duration
      - duration_hr
      - duration_min
      - duration_ms
      - duration_null
      - duration_sec
      - format_time
      - from_milliseconds
      - timestamp_ms
      - from_nanoseconds
      - timestamp_ns
      - from_seconds
      - timestamp_s
      - median
      - median_exact
      - now
      - parse_duration
      - parse_isotime
      - parse_timestamp
      - percentile
      - percentile_cont
      - percentile_disc
      - query_end_time
      - query_start_time
      - rate
      - row_end_time
      - row_timestamp
      - row_start_time
      - stddev
      - sum
      - tdigest_agg
      - timestamp_null
      - to_days
      - to_hours
      - to_milliseconds
      - to_minutes
      - to_nanoseconds
      - to_seconds
      - to_weeks
      - valid_for
    - OPAL Window Functions
      Toggle navigation of OPAL Window Functions
      - any
      - any_not_null
      - array_union_agg
      - avg
      - count
      - count_distinct
      - count_distinct_exact
      - delta
      - delta_monotonic
      - dense_rank
      - deriv
      - first
      - first_not_null
      - lag
      - lag_not_null
      - last
      - last_not_null
      - lead
      - lead_not_null
      - max
      - median
      - median_exact
      - min
      - object_agg
      - percentile
      - percentile_cont
      - percentile_disc
      - rank
      - rate
      - row_number
      - stddev
      - sum
      - tdigest_agg
      - tdigest_combine
      - topk_agg
    - OPAL Deprecated Function Aliases
      Toggle navigation of OPAL Deprecated Function Aliases
      - any_null
      - array_pivot
      - array_unpivot
      - countdistinct
      - countdistinctexact
      - decodebase64
      - denserank
      - encodebase64
      - endswith
      - groupby
      - ifnull
      - isnull
      - makeobject
      - match_regex_all
      - medianexact
      - milliseconds
      - nanoseconds
      - orderby
      - parsehex
      - parseip
      - parseisotime
      - parsejson
      - parsekvs
      - parseurl
      - percentilecont
      - percentiledisc
      - primarykey
      - queryendtime
      - querystarttime
      - regex_match
      - regex_replace
      - row_endtime
      - rownumber
      - seconds
      - startswith
      - strcat
      - string_concat
      - validfor
- OPAL Functions By Category
  Toggle navigation of OPAL Functions By Category
  - OPAL Aggregate Functions
    Toggle navigation of OPAL Aggregate Functions
    - any
    - any_not_null
    - array_agg
    - array_agg_distinct
    - array_union_agg
    - avg
    - count
    - count_distinct
    - count_distinct_exact
    - delta
    - delta_monotonic
    - deriv
    - first
    - first_not_null
    - last
    - last_not_null
    - max
    - median
    - median_exact
    - min
    - object_agg
    - percentile
    - percentile_cont
    - percentile_disc
    - prom_quantile
    - rate
    - stddev
    - string_agg
    - string_agg_distinct
    - sum
    - tdigest_agg
    - tdigest_combine
    - topk_agg
  - OPAL Boolean Functions
    Toggle navigation of OPAL Boolean Functions
    - array_contains
    - arrays_overlap
    - bool
    - bool_null
    - contains
    - ends_with
    - eq
    - gt
    - gte
    - in
    - ipv4_address_in_network
    - is_null
    - like
    - lt
    - lte
    - match_regex
    - ne
    - path_exists
    - same
    - search
    - starts_with
  - OPAL Misc Functions
    Toggle navigation of OPAL Misc Functions
    - asc
    - coalesce
    - desc
    - float64
    - frame
    - frame_exact
    - hash
    - if
    - if_null
    - int64
    - m_tdigest
    - nullsfirst
    - nullslast
    - on
    - order_by
    - parse_hex
    - strlen
    - tdigest_null
    - tdigest_quantile
    - variant_null
  - OPAL Networking Functions
    Toggle navigation of OPAL Networking Functions
  - OPAL Numeric Functions
    Toggle navigation of OPAL Numeric Functions
    - abs
    - ceil
    - count
    - delta
    - delta_monotonic
    - dense_rank
    - exp
    - float64_null
    - floor
    - haversine_distance_km
    - int64_null
    - int_div
    - ln
    - log
    - mod
    - numeric_null
    - percentile_disc
    - pow
    - prom_quantile
    - rank
    - round
    - row_number
    - sqrt
    - uniform
    - width_bucket
    - zipf
  - OPAL Regex Functions
    Toggle navigation of OPAL Regex Functions
  - OPAL Semistructured Functions
    Toggle navigation of OPAL Semistructured Functions
  - OPAL Special Functions
    Toggle navigation of OPAL Special Functions
    - case
    - group_by
    - m
    - metric
    - options
    - primary_key
    - pk
    - valid_for
    - window
  - OPAL String Functions
    Toggle navigation of OPAL String Functions
    - array_to_string
    - concat_strings
    - contains
    - decode_base64
    - decode_uri
    - decode_uri_component
    - detect_browser
    - editdistance
    - embed_sql_params
    - encode_base64
    - encode_uri
    - encode_uri_component
    - ends_with
    - format_time
    - get_regex
    - int64_to_ipv4
    - left
    - like
    - lower
    - lpad
    - ltrim
    - parse_csv
    - parse_kvs
    - parse_timestamp
    - pivot_array
    - position
    - regex
    - replace
    - replace_regex
    - right
    - rpad
    - rtrim
    - search
    - split
    - split_part
    - starts_with
    - string
    - string_agg
    - string_agg_distinct
    - string_null
    - substring
    - tokenize
    - tokenize_part
    - trim
    - unpivot_array
    - upper
    - variant_type_name
  - OPAL Time Functions
    Toggle navigation of OPAL Time Functions
    - abs
    - avg
    - bin_end_time
    - bin_size
    - bin_start_time
    - delta
    - delta_monotonic
    - deriv
    - duration
    - duration_hr
    - duration_min
    - duration_ms
    - duration_null
    - duration_sec
    - format_time
    - from_milliseconds
    - timestamp_ms
    - from_nanoseconds
    - timestamp_ns
    - from_seconds
    - timestamp_s
    - median
    - median_exact
    - now
    - parse_duration
    - parse_isotime
    - parse_timestamp
    - percentile
    - percentile_cont
    - percentile_disc
    - query_end_time
    - query_start_time
    - rate
    - row_end_time
    - row_timestamp
    - row_start_time
    - stddev
    - sum
    - tdigest_agg
    - timestamp_null
    - to_days
    - to_hours
    - to_milliseconds
    - to_minutes
    - to_nanoseconds
    - to_seconds
    - to_weeks
    - valid_for
  - OPAL Window Functions
    Toggle navigation of OPAL Window Functions
    - any
    - any_not_null
    - array_union_agg
    - avg
    - count
    - count_distinct
    - count_distinct_exact
    - delta
    - delta_monotonic
    - dense_rank
    - deriv
    - first
    - first_not_null
    - lag
    - lag_not_null
    - last
    - last_not_null
    - lead
    - lead_not_null
    - max
    - median
    - median_exact
    - min
    - object_agg
    - percentile
    - percentile_cont
    - percentile_disc
    - rank
    - rate
    - row_number
    - stddev
    - sum
    - tdigest_agg
    - tdigest_combine
    - topk_agg
  - OPAL Deprecated Function Aliases
    Toggle navigation of OPAL Deprecated Function Aliases
    - any_null
    - array_pivot
    - array_unpivot
    - countdistinct
    - countdistinctexact
    - decodebase64
    - denserank
    - encodebase64
    - endswith
    - groupby
    - ifnull
    - isnull
    - makeobject
    - match_regex_all
    - medianexact
    - milliseconds
    - nanoseconds
    - orderby
    - parsehex
    - parseip
    - parseisotime
    - parsejson
    - parsekvs
    - parseurl
    - percentilecont
    - percentiledisc
    - primarykey
    - queryendtime
    - querystarttime
    - regex_match
    - regex_replace
    - row_endtime
    - rownumber
    - seconds
    - startswith
    - strcat
    - string_concat
    - validfor
- OPAL Aggregate Functions
  Toggle navigation of OPAL Aggregate Functions
  - any
  - any_not_null
  - array_agg
  - array_agg_distinct
  - array_union_agg
  - avg
  - count
  - count_distinct
  - count_distinct_exact
  - delta
  - delta_monotonic
  - deriv
  - first
  - first_not_null
  - last
  - last_not_null
  - max
  - median
  - median_exact
  - min
  - object_agg
  - percentile
  - percentile_cont
  - percentile_disc
  - prom_quantile
  - rate
  - stddev
  - string_agg
  - string_agg_distinct
  - sum
  - tdigest_agg
  - tdigest_combine
  - topk_agg
- OPAL Alignment Functions
  Toggle navigation of OPAL Alignment Functions
  - any
  - any_not_null
  - avg
  - count
  - count_distinct
  - count_distinct_exact
  - delta
  - delta_monotonic
  - deriv
  - first
  - first_not_null
  - last
  - last_not_null
  - max
  - median
  - median_exact
  - min
  - object_agg
  - percentile
  - percentile_cont
  - percentile_disc
  - prom_quantile
  - rate
  - stddev
  - sum
  - tdigest_agg
  - tdigest_combine
  - topk_agg
- OPAL Boolean Functions
  Toggle navigation of OPAL Boolean Functions
  - array_contains
  - arrays_overlap
  - bool
  - bool_null
  - contains
  - ends_with
  - eq
  - gt
  - gte
  - in
  - ipv4_address_in_network
  - is_null
  - like
  - lt
  - lte
  - match_regex
  - ne
  - path_exists
  - same
  - search
  - starts_with
- OPAL Numeric Functions
  Toggle navigation of OPAL Numeric Functions
  - abs
  - ceil
  - count
  - delta
  - delta_monotonic
  - dense_rank
  - exp
  - float64_null
  - floor
  - haversine_distance_km
  - int64_null
  - int_div
  - ln
  - log
  - mod
  - numeric_null
  - percentile_disc
  - pow
  - prom_quantile
  - rank
  - round
  - row_number
  - sqrt
  - uniform
  - width_bucket
  - zipf
- OPAL Regex Functions
  Toggle navigation of OPAL Regex Functions
- OPAL Semistructured Functions
  Toggle navigation of OPAL Semistructured Functions
- OPAL Special Functions
  Toggle navigation of OPAL Special Functions
  - case
  - group_by
  - m
  - metric
  - options
  - primary_key
  - pk
  - valid_for
  - window
- OPAL Time Functions
  Toggle navigation of OPAL Time Functions
  - abs
  - avg
  - bin_end_time
  - bin_size
  - bin_start_time
  - delta
  - delta_monotonic
  - deriv
  - duration
  - duration_hr
  - duration_min
  - duration_ms
  - duration_null
  - duration_sec
  - format_time
  - from_milliseconds
  - timestamp_ms
  - from_nanoseconds
  - timestamp_ns
  - from_seconds
  - timestamp_s
  - median
  - median_exact
  - now
  - parse_duration
  - parse_isotime
  - parse_timestamp
  - percentile
  - percentile_cont
  - percentile_disc
  - query_end_time
  - query_start_time
  - rate
  - row_end_time
  - row_timestamp
  - row_start_time
  - stddev
  - sum
  - tdigest_agg
  - timestamp_null
  - to_days
  - to_hours
  - to_milliseconds
  - to_minutes
  - to_nanoseconds
  - to_seconds
  - to_weeks
  - valid_for
- OPAL Networking Functions
  Toggle navigation of OPAL Networking Functions
- OPAL Window Functions
  Toggle navigation of OPAL Window Functions
  - any
  - any_not_null
  - array_union_agg
  - avg
  - count
  - count_distinct
  - count_distinct_exact
  - delta
  - delta_monotonic
  - dense_rank
  - deriv
  - first
  - first_not_null
  - lag
  - lag_not_null
  - last
  - last_not_null
  - lead
  - lead_not_null
  - max
  - median
  - median_exact
  - min
  - object_agg
  - percentile
  - percentile_cont
  - percentile_disc
  - rank
  - rate
  - row_number
  - stddev
  - sum
  - tdigest_agg
  - tdigest_combine
  - topk_agg
- OPAL Misc Functions
  Toggle navigation of OPAL Misc Functions
  - asc
  - coalesce
  - desc
  - float64
  - frame
  - frame_exact
  - hash
  - if
  - if_null
  - int64
  - m_tdigest
  - nullsfirst
  - nullslast
  - on
  - order_by
  - parse_hex
  - strlen
  - tdigest_null
  - tdigest_quantile
  - variant_null
- OPAL Deprecated Function Aliases
  Toggle navigation of OPAL Deprecated Function Aliases
  - any_null
  - array_pivot
  - array_unpivot
  - countdistinct
  - countdistinctexact
  - decodebase64
  - denserank
  - encodebase64
  - endswith
  - groupby
  - ifnull
  - isnull
  - makeobject
  - match_regex_all
  - medianexact
  - milliseconds
  - nanoseconds
  - orderby
  - parsehex
  - parseip
  - parseisotime
  - parsejson
  - parsekvs
  - parseurl
  - percentilecont
  - percentiledisc
  - primarykey
  - queryendtime
  - querystarttime
  - regex_match
  - regex_replace
  - row_endtime
  - rownumber
  - seconds
  - startswith
  - strcat
  - string_concat
  - validfor
- All OPAL verbs
  Toggle navigation of All OPAL verbs
  - OPAL Verbs By Category
    Toggle navigation of OPAL Verbs By Category
    - OPAL Aggregate Verbs
      Toggle navigation of OPAL Aggregate Verbs
      - aggregate
      - align
      - dedup
      - distinct
      - histogram
      - make_session
      - merge_events
      - pivot
      - rollup
      - statsby
      - timechart
      - bucketize
      - timestats
      - unpivot
    - OPAL Filter Verbs
      Toggle navigation of OPAL Filter Verbs
      - always
      - bottomk
      - ever
      - filter
      - filter_last
      - limit
      - never
      - topk
    - OPAL Join Verbs
      Toggle navigation of OPAL Join Verbs
      - exists
      - follow
      - follow_not
      - fulljoin
      - join
      - leftjoin
      - lookup
      - lookup_ip_info
      - not_exists
      - surrounding
      - union
      - update_resource
    - OPAL Metadata Verbs
      Toggle navigation of OPAL Metadata Verbs
    - OPAL Metrics Verbs
      Toggle navigation of OPAL Metrics Verbs
      - aggregate
      - align
      - rollup
      - set_metric
    - OPAL Projection Verbs
      Toggle navigation of OPAL Projection Verbs
    - OPAL Semistructured Verbs
      Toggle navigation of OPAL Semistructured Verbs
    - OPAL Deprecated Verb Aliases
      Toggle navigation of OPAL Deprecated Verb Aliases
      - addfk
      - addkey
      - addmetric
      - changelog
      - coldrop
      - colenum
      - colimmutable
      - colmake
      - colpick
      - colregex
      - colrename
      - colshow
      - droptime
      - fkdrop
      - flattenall
      - flattenleaves
      - flattensingle
      - makeresource
      - makesession
      - merge_event
      - mergeevent
      - reaggregate
      - setlabel
      - setpk
      - setvf
      - setvt
- OPAL Verbs By Category
  Toggle navigation of OPAL Verbs By Category
  - OPAL Aggregate Verbs
    Toggle navigation of OPAL Aggregate Verbs
    - aggregate
    - align
    - dedup
    - distinct
    - histogram
    - make_session
    - merge_events
    - pivot
    - rollup
    - statsby
    - timechart
    - bucketize
    - timestats
    - unpivot
  - OPAL Filter Verbs
    Toggle navigation of OPAL Filter Verbs
    - always
    - bottomk
    - ever
    - filter
    - filter_last
    - limit
    - never
    - topk
  - OPAL Join Verbs
    Toggle navigation of OPAL Join Verbs
    - exists
    - follow
    - follow_not
    - fulljoin
    - join
    - leftjoin
    - lookup
    - lookup_ip_info
    - not_exists
    - surrounding
    - union
    - update_resource
  - OPAL Metadata Verbs
    Toggle navigation of OPAL Metadata Verbs
  - OPAL Metrics Verbs
    Toggle navigation of OPAL Metrics Verbs
    - aggregate
    - align
    - rollup
    - set_metric
  - OPAL Projection Verbs
    Toggle navigation of OPAL Projection Verbs
  - OPAL Semistructured Verbs
    Toggle navigation of OPAL Semistructured Verbs
  - OPAL Deprecated Verb Aliases
    Toggle navigation of OPAL Deprecated Verb Aliases
    - addfk
    - addkey
    - addmetric
    - changelog
    - coldrop
    - colenum
    - colimmutable
    - colmake
    - colpick
    - colregex
    - colrename
    - colshow
    - droptime
    - fkdrop
    - flattenall
    - flattenleaves
    - flattensingle
    - makeresource
    - makesession
    - merge_event
    - mergeevent
    - reaggregate
    - setlabel
    - setpk
    - setvf
    - setvt
- OPAL Aggregate Verbs
  Toggle navigation of OPAL Aggregate Verbs
  - aggregate
  - align
  - dedup
  - distinct
  - histogram
  - make_session
  - merge_events
  - pivot
  - rollup
  - statsby
  - timechart
  - bucketize
  - timestats
  - unpivot
- OPAL Filter Verbs
  Toggle navigation of OPAL Filter Verbs
  - always
  - bottomk
  - ever
  - filter
  - filter_last
  - limit
  - never
  - topk
- OPAL Join Verbs
  Toggle navigation of OPAL Join Verbs
  - exists
  - follow
  - follow_not
  - fulljoin
  - join
  - leftjoin
  - lookup
  - lookup_ip_info
  - not_exists
  - surrounding
  - union
  - update_resource
- OPAL Metrics Verbs
  Toggle navigation of OPAL Metrics Verbs
  - aggregate
  - align
  - rollup
  - set_metric
- OPAL Projection Verbs
  Toggle navigation of OPAL Projection Verbs
- OPAL Semistructured Verbs
  Toggle navigation of OPAL Semistructured Verbs
- OPAL Metadata Verbs
  Toggle navigation of OPAL Metadata Verbs
- OPAL Deprecated Verb Aliases
  Toggle navigation of OPAL Deprecated Verb Aliases
  - addfk
  - addkey
  - addmetric
  - changelog
  - coldrop
  - colenum
  - colimmutable
  - colmake
  - colpick
  - colregex
  - colrename
  - colshow
  - droptime
  - fkdrop
  - flattenall
  - flattenleaves
  - flattensingle
  - makeresource
  - makesession
  - merge_event
  - mergeevent
  - reaggregate
  - setlabel
  - setpk
  - setvf
  - setvt
Observasaurus
Toggle navigation of Observasaurus
Observe Performance Cookbook
Toggle navigation of Observe Performance Cookbook
Conditional Formatting Reference
Units of Measurement
Helpful Hints

v: latest

Versions: latest; yasar-azure-troubleshooting; yasar-add-gcp-perm; visuals; trial-tutorial; token-search; toc-work; toc-chicks; test-panels; slobsv-prometheus-metrics-app; slack-integ; rn-121523; rn-112223; rn-111723; rn-102023; rn-090823; reorg-toc; rakeshgupta-staging; otel-fixes; opal-dash; monitor-updates; log-monitor; licensing-update; lambda-edits; kyle-request; joe-slo-app; filedrop-docs; filedrop; fastly; dashboard-tutorial; coates-ob-27541; champ-ob-31058; branching; add-all-stats

Downloads

On Read the Docs: Project Home; Builds

Back to top

Edit this page

Toggle table of contents sidebar

array_pivot¶

array_pivot is a deprecated alias of pivot_array.

Made with Furo

Have comments about the Observe docs?