How to Execute SQL Statements from a File in ksqlDB

To execute all the SQL statements in a file, u se the RUN SCRIPT command.

Let’s imagine you have a file called statements.sql containing a list of SQL statements that you want to run. You can pass the full path of that file alongside the command from within a ksqlDB session.

RUN SCRIPT /path/to/statements.sql