Query a Last Value Cache

Use the last_cache() SQL function in the FROM clause of an SQL SELECT statement to query data from the Last Value Cache (LVC).

last_cache() supports the following arguments:

• table_name: (Required) The name of the table the LVC is associated with formatted as a string literal.
• cache_name: The name of the LVC to query formatted as a string literal. This argument is only required if there is more than one LVC associated with the specified table.

SELECT * FROM last_cache('table_name', 'cache_name')

You can use other SQL clauses to modify query results. For example, you can use the WHERE clause to return the last value for a specific tag set:

SELECT
  room,
  temp
FROM
  last_cache('home', 'homeCache')
WHERE
  room = 'Kitchen'