SQL deployment

Overview

Ververica Platform: Self-Managed allows you to edit drafts and run deployments using SQL code. This topic explains how to perform various operations, such as accessing Ververica Platform: Self-Managed, creating SQL drafts, and running SQL deployments.

Watch this video to learn more about SQL deployments on Ververica Platform: Self-Managed.

Procedure

The procedure consists of three steps:

• Step 1: Create an SQL draft and write business code on the SQL Editor page.
• Step 2: Start the deployment
• Step 3: View the results of the deployment

Step 1: Create an SQL Draft

To create your first SQL draft:

1. In the left navigation, click the Namespace selector and select the namespace that you want to open. The inital namespace that was created during installation is called default.
2. Click SQL Editor page, then click New.
3. In the New Draft dialog box, select the Blank Stream Draft template and click Next.
4. Enter a Name (e.g. My_first_SQL) and click Create.

1. Copy the deployment code below and paste it into the code editor panel on the right.

1CREATE TEMPORARY TABLE datagen_source( 
2randstr VARCHAR 
3) WITH ( 
4'connector' = 'datagen' 
5); 
6
7CREATE TEMPORARY TABLE print_table( 
8randstr  VARCHAR 
9) WITH ( 
10'connector' = 'print', 
11'logger' = 'true' 
12); 
13
14INSERT INTO print_table 
15SELECT SUBSTRING(randstr,0,8) from datagen_source;

1. Click Validate to check the syntax. It should pass with no issues, and a confirmation will be displayed under the SQL code panel.
2. Click Deploy.
3. In the Deploy draft dialog box, click Confirm.
4. The draft name will be displayed with a green success icon, and you’ll see a notification in the top right of the Console toolbar. Click the notification icon to view the message.

Step 2: Start the Deployment

To start the SQL deployment:

1. In the Console, click Deployments.
2. Find the new Deployment and click Start in the Actions column.
3. In the Start Job dialog box, select Initial mode and click Start. Initially, the status will be STARTING.
4. After the deployment is started, the deployment status changes to RUNNING. This indicates that the deployment is running properly.

Step 3: View the Results

To view the results:

1. On the Deployments page, click the name of the Deployment.
2. Click the Diagnostics > Stdout tab.
3. On the Logs tab, click Running Task Managers.
4. Click the value in the Path, ID column.

1. Display the Stdout tab to see the results.

More Information

For more details, see:

• Create and delete an SQL draft
• Deploy an SQL draft