our product
about us
blog
resources
careers

Hide navigation sidebar

Hide table of contents sidebar

Toggle site navigation sidebar

documentation

Toggle table of contents sidebar

Getting started

Why Observe?
Introducing Observe Concepts
Toggle child pages in navigation
- Advanced Observe Concepts

Managing your workspace

Navigating the workspace
Toggle child pages in navigation
Observe apps

Working with data

About Queries and On-demand Acceleration
Data Ingestion
Toggle child pages in navigation
- Sources
  Toggle child pages in navigation
- Forwarders
  Toggle child pages in navigation
- Datastreams
- Endpoints
  Toggle child pages in navigation
  - HTTP
  - DDTrace
  - Elasticsearch
  - Kinesis
  - LogPlex
  - OpenTelemetry
  - Prometheus
  - Zipkin
- Troubleshooting Data Ingestion
Observe Integrations
Toggle child pages in navigation
- Amazon Web Services (AWS) Integration
  Toggle child pages in navigation
  - Amazon CloudFront
  - Amazon EC2
  - Amazon Elastic Container Service
    Toggle child pages in navigation
    - Amazon Elastic Container Service metrics
  - Amazon RDS
    Toggle child pages in navigation
    - Amazon RDS metrics
  - AWS Lambda
    Toggle child pages in navigation
    - AWS Lambda metrics
  - Elastic Load Balancing
    Toggle child pages in navigation
    - Elastic Load Balancing metrics
- Google Cloud Platform (GCP) App
  Toggle child pages in navigation
  - GCP Asset Inventory
  - GCP BigQuery
  - GCP Cloud Functions
    Toggle child pages in navigation
    - GCP Cloud Functions metrics
  - GCP Cloud Load Balancing
    Toggle child pages in navigation
    - GCP Cloud Load Balancing Metrics
  - GCP Cloud SQL
    Toggle child pages in navigation
    - GCP Cloud SQL metrics
  - GCP Cloud Storage
    Toggle child pages in navigation
    - GCP Cloud Storage metrics
  - GCP Compute
    Toggle child pages in navigation
    - GCP Compute metrics
  - GCP Logging
  - GCP Cloud Metrics
  - Google Kubernetes Engine
- GitHub
  Toggle child pages in navigation
  - Installing the GitHub App
  - Upgrading to GitHub App v0.7.0
- GitLab
  Toggle child pages in navigation
  - Installing the GitLab App
  - Upgrading the GitLab App to v0.4.0
- Host Monitoring
  Toggle child pages in navigation
  - Installing the Host Monitoring App
- Jenkins CI/CD Integration
  Toggle child pages in navigation
  - Installing the Jenkins App
- Kubernetes
  Toggle child pages in navigation
  - Installing the Kubernetes App
- Microsoft Azure (Public Preview)
  Toggle child pages in navigation
- MySQL Database Service
  Toggle child pages in navigation
  - Installing the MySQL DB App
- Node Exporter
- OpenTelemetry (Public Preview)
  Toggle child pages in navigation
  - Installing the Observe OpenTelemetry App
Observe Datasets and Time
Toggle child pages in navigation
Tutorial: Modeling Weather Data
Worksheets

Working with dashboards

Creating and using dashboards

Configuring monitors and alerts

Introduction to Monitors and Alerts
Toggle child pages in navigation
Overview of Channels and Channel Actions
Toggle child pages in navigation
- Customizing alert messages
- Channel Action Integrations
  Toggle child pages in navigation

Working with metrics

Introduction to Metrics
Metrics Shaping Example: Host System Data
Adding Metrics Using the Expression Builder

OPAL query Language

OPAL — Observe Processing and Analysis Language
Toggle child pages in navigation
All OPAL verbs
Toggle child pages in navigation
- OPAL Verbs By Category
  Toggle child pages in navigation
  - OPAL Aggregate Verbs
    Toggle child pages in navigation
    - aggregate
    - align
    - dedup
    - distinct
    - make_session
    - merge_events
    - rollup
    - statsby
    - timechart
    - bucketize
    - timestats
  - OPAL Filter Verbs
    Toggle child pages in navigation
    - always
    - bottomk
    - ever
    - filter
    - limit
    - never
    - topk
  - OPAL Join Verbs
    Toggle child pages in navigation
    - exists
    - flatten
    - flatten_all
    - flatten_leaves
    - flatten_single
    - follow
    - fulljoin
    - join
    - leftjoin
    - lookaround_join
    - lookup
    - surrounding
    - union
    - update_resource
  - OPAL Metadata Verbs
    Toggle child pages in navigation
  - OPAL Metrics Verbs
    Toggle child pages in navigation
    - aggregate
    - align
    - rollup
    - set_metric
  - OPAL Projection Verbs
    Toggle child pages in navigation
  - OPAL Semistructured Verbs
    Toggle child pages in navigation
  - OPAL Deprecated Verb Aliases
    Toggle child pages in navigation
    - 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
All OPAL functions
Toggle child pages in navigation
- OPAL Functions By Category
  Toggle child pages in navigation
  - OPAL Aggregate Functions
    Toggle child pages in navigation
    - any
    - any_not_null
    - array_agg
    - array_agg_distinct
    - avg
    - count
    - count_distinct
    - count_distinct_exact
    - 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
  - OPAL Boolean Functions
    Toggle child pages in navigation
    - array_contains
    - 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 child pages in navigation
    - any_null
    - asc
    - coalesce
    - desc
    - editdistance
    - frame
    - frame_exact
    - if
    - if_null
    - make_object
    - on
    - order_by
    - position
    - string
    - string_null
    - variant_type_name
  - OPAL Networking Functions
    Toggle child pages in navigation
  - OPAL Numeric Functions
    Toggle child pages in navigation
    - abs
    - array_length
    - ceil
    - count
    - count_distinct
    - count_distinct_exact
    - dense_rank
    - exp
    - float64
    - float64_null
    - floor
    - hash
    - haversine_distance_km
    - int64
    - int64_null
    - int_div
    - ipv4_network_int64
    - ipv4_to_int64
    - ln
    - log
    - mod
    - numeric_null
    - parse_hex
    - percentile_disc
    - pow
    - prom_quantile
    - rank
    - round
    - row_number
    - sqrt
    - strlen
    - width_bucket
  - OPAL Regex Functions
    Toggle child pages in navigation
  - OPAL Semistructured Functions
    Toggle child pages in navigation
    - array
    - array_agg
    - array_agg_distinct
    - array_null
    - array_to_string
    - detect_browser
    - drop_fields
    - embed_sql_params
    - get_field
    - get_item
    - get_jmespath
    - get_regex_all
    - index_of_item
    - make_array
    - make_fields
    - match_regex
    - object
    - object_agg
    - object_keys
    - object_null
    - parse_csv
    - parse_ip
    - parse_json
    - parse_kvs
    - parse_url
    - path_exists
    - pick_fields
    - pivot_array
    - slice_array
    - split
    - tokenize
    - unpivot_array
  - OPAL Special Functions
    Toggle child pages in navigation
    - case
    - group_by
    - m
    - metric
    - options
    - primary_key
    - pk
    - valid_for
    - window
  - OPAL String Functions
    Toggle child pages in navigation
    - array_to_string
    - decode_base64
    - decode_uri
    - decode_uri_component
    - encode_base64
    - encode_uri
    - encode_uri_component
    - format_time
    - get_regex
    - left
    - lower
    - lpad
    - ltrim
    - replace
    - replace_regex
    - right
    - rpad
    - rtrim
    - split_part
    - string_agg
    - string_agg_distinct
    - string_concat
    - substring
    - tokenize_part
    - trim
    - upper
  - OPAL Time Functions
    Toggle child pages in navigation
    - abs
    - avg
    - bin_end_time
    - bin_start_time
    - 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_isotime
    - parse_timestamp
    - percentile
    - percentile_cont
    - percentile_disc
    - query_end_time
    - query_start_time
    - rate
    - row_end_time
    - row_timestamp
    - stddev
    - sum
    - timestamp_null
    - valid_for
  - OPAL Window Functions
    Toggle child pages in navigation
    - any
    - any_not_null
    - avg
    - count
    - count_distinct
    - count_distinct_exact
    - 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
  - OPAL Deprecated Function Aliases
    Toggle child pages in navigation
    - 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
    - validfor

Reference

Understanding the Usage Dashboard
Credit Manager
Single Sign On (SSO) Configurations for Observe
Toggle child pages in navigation
Observe Glossary
Helpful Hints
FAQ
Units of Measure

Release Notes

Observe Release Notes and Updates
Toggle child pages in navigation

Toggle table of contents sidebar

queryendtime¶

queryendtime is a deprecated alias of query_end_time.

Have comments about the Observe docs?