Using SQL Editor

You can use the SQL Editor to connect to DataArts Fabric SQL and perform SQL operations.

1. Log in to the Huawei Cloud DataArts Fabric console and click Access Workspace.
2. In the navigation pane on the left, choose Development and Production > SQL Editor. Select a LakeFormation instance, a LakeFormation catalog, and a SQL endpoint to run the SQL statements. You can also enable Session Mode to retain the execution session. In scenarios where SQL statements need to be executed frequently and intermittently, this function can save the time for creating a session.
3. The query results support the Overwrite and Append modes. Overwrite clears previous query results, and Append retains them. Query results can be displayed in tables.
4. Query data using SQL statements by referring to Developer Guide and SQL Syntax.