---
title: SQL cache functions
description: Retrieve cached data from InfluxDB 3 Core caches.
url: https://docs.influxdata.com/influxdb3/core/reference/sql/functions/cache/
estimated_tokens: 906
product: InfluxDB 3 Core
version: core
---

# SQL cache functions

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

-   [distinct\_cache](#distinct_cache)
-   [last\_cache](#last_cache)

## distinct\_cache

Returns data from an InfluxDB 3 Core distinct value cache.

```sql
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)

View `distinct_cache` query example

```sql
SELECT * FROM distinct_cache('example_table', 'exampleCacheName')
```

## last\_cache

Returns data from an InfluxDB 3 Core last value cache.

```sql
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)

View `last_cache` query example

```sql
SELECT * FROM last_cache('example_table', 'exampleCacheName')
```