Create Draft#
This document explains how to create an SQL draft in fully managed Flink.
Procedure#
To enhance the efficiency of writing and managing Flink SQL jobs, fully managed Flink provides a set of Flink SQL features. You can use these features to manage metadata, register user-defined functions (UDFs), and use the SQL editor.
Log in to Ververica Cloud.
On the Dashboard page, locate the workspace you want to manage, click the title of the workspace or this icon ⋮, and select Open Console.
In the left-side navigation pane of the Console, click SQL editor and choose the Drafts tab.
Click New.
In the New Draft dialog box, select an SQL script template. Choose either a script without a code template (Blank Stream Draft) or a script with a code example (Flink Table, Temporary Table, Temporary View statement, INSERT INTO statement).
For a Blank Stream draft, click Blank Stream Draft. For scripts with a code template, click Flink Table, Temporary Table, Temporary View statement, INSERT INTO.
After clicking Next, configure the basic parameters of the draft.
Parameter |
Description |
|---|---|
Name |
The name of the draft that you want to create. Note: The draft name must be unique in the current project. |
Location |
The folder in which the code file of the draft is saved. |
Engine version |
The engine version of Flink that is used by the draft. |
Click Create.
Additional functionality#
Title |
Description |
Additional info |
|---|---|---|
Save as |
Save the Draft in the selected location/folder |
Button at the top of the screen |
Save |
Save changes in the Draft |
Button at the top of the screen |
Create temporary table |
Create a temporary table |
Inserts a code snippet of the DDL statement into the current SQL editor |
More |
Access functions such as Undo, Redo, Find, Format |
Button at the top of the screen |
Validate |
Perform code validation |
Button at the top of the screen |
Debug |
Supports statement types including Query, Insert, and Auxiliary, such as Explain. Specify a running session cluster when starting |
Button at the top of the screen |
Deploy |
Deploy your SQL draft, and the corresponding deployment appears at the top of the deployment list under the Deployments page |
Button at the top of the screen |
Operations |
Redirect to the corresponding deployment page (Deployment details, Overview, Metrics, Events, Exploration). Button disabled if the SQL draft hasn’t been deployed yet |
Button in the right-side navigation pane |
Configurations |
Configure Engine Version and Additional Dependencies of the SQL Draft |
Button in the right-side navigation pane |
Structure |
Display a data-flow diagram for the FlinkSQL in either DAG or tree mode |
Button in the right-side navigation pane |
Versions |
List the SQL draft’s deployed history, and revert to a particular version |
Button in the right-side navigation pane |
Additional functionality#
Log in to Ververica Cloud.
On the Dashboard page, find the workspace you want to manage, click the title of the workspace or this icon ⋮, and select Open Console.
In the left-side navigation pane of the Console, click SQL Editor and choose the Drafts tab.
Select the SQL Draft you want to delete and click the Waste bucket icon.
