RUN SCRIPT statement in ksqlDB for Confluent Platform

Synopsis

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

Description

You can run a list of predefined queries and commands from in a file by using the RUN SCRIPT command.

The RUN SCRIPT command supports a subset of ksqlDB statements:

• Persistent queries:

  • CREATE STREAM

  • CREATE TABLE

  • CREATE STREAM AS SELECT

  • CREATE TABLE AS SELECT

• DROP STREAM and 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.

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