> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Use this reference to learn about the metadata available for Firebolt streams using the information schema.

# Streams

You can use the `information_schema.streams` view to return information about each stream in your Firebolt [account](/managed-service/organizations-accounts#accounts). The view contains one row for each stream. Use a `SELECT` query to return information about each stream as shown in the example below.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  stream_name,
  stream_schema,
  stream_type,
  consumer_group,
  stream_owner,
  created
FROM
  information_schema.streams;
```

## Columns in information\_schema.streams

Each row has the following columns with information about each stream:

| Column Name     | Data Type   | Description                                                                                                                                             |
| :-------------- | :---------- | :------------------------------------------------------------------------------------------------------------------------------------------------------ |
| stream\_catalog | TEXT        | The name of the database that contains the stream.                                                                                                      |
| stream\_schema  | TEXT        | The name of the schema that contains the stream.                                                                                                        |
| stream\_name    | TEXT        | The name of the stream.                                                                                                                                 |
| stream\_type    | TEXT        | The type of the stream source. Currently always `KAFKA`.                                                                                                |
| stream\_owner   | TEXT        | The owner of the stream.                                                                                                                                |
| created         | TIMESTAMPTZ | The timestamp when the stream was created.                                                                                                              |
| ddl             | TEXT        | The `CREATE STREAM` statement used to create this stream, with credentials masked for security.                                                         |
| description     | TEXT        | Optional metadata describing the stream's purpose.                                                                                                      |
| consumer\_group | TEXT        | The Kafka consumer group identifier used by this stream.                                                                                                |
| offsets         | TEXT        | A JSON array of per-partition consumer offsets, for example `[{"partition_id":0,"offset":42}]`. This column is only populated when explicitly selected. |

## Examples

### View all streams

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  stream_name,
  stream_schema,
  stream_type,
  consumer_group,
  stream_owner,
  created
FROM
  information_schema.streams;
```

### View stream offsets

The `offsets` column returns a JSON array with per-partition consumer offset positions. It is only populated when explicitly selected:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  stream_name,
  offsets
FROM
  information_schema.streams
WHERE stream_name = 'my_stream';
```

**Example output:**

```
stream_name | offsets
------------|-------------------------------------------
my_stream   | [{"partition_id":0,"offset":150},{"partition_id":1,"offset":200}]
```

### View stream DDL

The `ddl` column contains the original `CREATE STREAM` statement with credentials masked:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  stream_name,
  ddl
FROM
  information_schema.streams;
```

### Filter streams by schema

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  stream_name,
  stream_type,
  consumer_group,
  created
FROM
  information_schema.streams
WHERE stream_schema = 'public'
ORDER BY created DESC;
```

## Notes

* All identifiers are case-insensitive unless enclosed in double-quotes.
* The `offsets` column is lazily evaluated and only populated when explicitly included in the `SELECT` list.
* The `ddl` column masks credential values for security.
* For more information about object identifiers, see [Object identifiers](/reference-sql/lexical-structure/object-identifiers).