search

confluentinc / cp-helm-charts

The Confluent Platform Helm charts enable you to deploy Confluent Platform services on Kubernetes for development, test, and proof of concept environments.
https://cnfl.io/getting-started-kafka-kubernetes
Apache License 2.0
787 stars 847 forks source link

How to provide custom ksql queries to ksql-server #547

Open shashanksapre opened 3 years ago

shashanksapre commented 3 years ago

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 commented 2 years ago

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.