SQL cache functions

The InfluxDB 3 Enterprise SQL implementation supports the following functions that return data from InfluxDB 3 Enterprise caches.

distinct_cache

Returns data from an InfluxDB 3 Enterprise distinct value cache.

distinct_cache(table_name, cache_name)

Arguments

  • table_name: Name of the table associated with the distinct value cache (formatted as a string literal).
  • cache_name: Name of the distinct value cache to query (formatted as a string literal).

View distinct_cache query example

last_cache

Returns data from an InfluxDB 3 Enterprise last value cache.

last_cache(table_name, cache_name)

Arguments

  • table_name: Name of the table associated with the last value cache (formatted as a string literal).
  • cache_name: Name of the last value cache to query (formatted as a string literal).

View last_cache query example

Was this page helpful?

Thank you for your feedback!