<a id="ksqldb-reference-run-script"></a>

# RUN SCRIPT statement in ksqlDB for Confluent Platform

## Synopsis

```sql
RUN SCRIPT <path-to-query-file>;
```

## Description

The RUN SCRIPT command runs a list of predefined queries and commands
from a file.

The RUN SCRIPT command supports a subset of ksqlDB statements:

- Persistent queries:
  - [CREATE STREAM](create-stream.md#ksqldb-reference-create-stream)
  - [CREATE TABLE](create-table.md#ksqldb-reference-create-table)
  - [CREATE STREAM AS SELECT](create-stream-as-select.md#ksqldb-reference-create-stream-as-select)
  - [CREATE TABLE AS SELECT](create-table-as-select.md#ksqldb-reference-create-table-as-select)
- [DROP STREAM](drop-stream.md#ksqldb-reference-drop-stream) and
  [DROP TABLE](drop-table.md#ksqldb-reference-drop-table)
- SET, UNSET statements
- INSERT INTO statement

The RUN SCRIPT doesn’t support statements such as:

- SHOW TOPICS and SHOW STREAMS, *etc*.
- TERMINATE
- Non-persistent queries: SELECT, *etc*.

RUN SCRIPT is only available from the ksqlDB command line.

## Example

The following statement runs the queries in the file located at
`/local/path/to/queries.sql`.

```sql
RUN SCRIPT '/local/path/to/queries.sql';
```