How to provide custom ksql queries to ksql-server

[shashanksapre]

Hi,

We are running the ksql-server using the helm charts. We have automated the deployment. For development and testing we run the ksql queries using CLI connecting to the ksql server. However, for a production system we would like to run ksql-server in headless mode so nobody would be able to access it except for the applications running in the same cluster. Is there a way to provide our custom queries. As I understand currently one can achieve that by forking the project and modifying queries.sql file to include one's own queries. But a way to provide that using values.yaml would be nice. If it's already available, could you please guide me on how to achieve that?

[nbonavia]

You can use the KSQL Migration Tool (https://docs.ksqldb.io/en/latest/operate-and-deploy/migrations-tool/) to deploy your queries in production. The tool also maintains the versions of the queries executed.