Configuring Custom KSQL Services
A Custom KSQL service defines and executes custom KSQL to perform streaming operations. You can execute almost any KSQL statement required for integrations, such as data management statements. You configure
Adapter for Apache Kafka services using
Designer. For more information about adapter services, see
Using Adapter Services.
If you need to write custom KSQL, you can create a service that uses customized KSQL statements. This allows you the flexibility to execute almost any KSQL statements required, such as data management statements and data definition statements, including terminate, drop, create etc.
Because Custom KSQL service provides no check on KSQL syntax validations, be sure that your KSQL statement works correctly. You can verify KSQL statement accuracy using your vendor's KSQL CLI. For details, see your vendor documentation.
Be sure to review the section
Before Configuring or Managing Adapter Services before you configure adapter services.
To create a Custom KSQL service
1. In Designer, right-click the package in which the service should be contained and select New > Adapter Service.
2. Select the parent namespace, type a name for the adapter service, and click Next.
3. Select Adapter for Apache Kafka as the adapter type and click Next.
4. Select the appropriate KSQL connection as Adapter Connection Name and click Next.
5. From the list of available templates, select the Custom KSQL template and click Finish.
The adapter service editor for the adapter service appears. You can select the Adapter Settings tab at any time to confirm adapter service properties such as the Adapter Name, Adapter Connection Name, and Adapter Service Template, as necessary.
6. Select the KSQL tab to specify a KSQL statement.
If you want to specify additional properties at runtime.
a. Use the
icon to create new rows as needed. You can use the 
icon to fill in all rows to the table. 7. From the File menu, select Save.