Updated on 2025-08-25 GMT+08:00

Before You Start

Intended Audience

This document is intended for database designers, application developers, or database administrators, providing essential information for designing, building, querying, and maintaining data warehouses.

As a database administrator or application developer, you need to understand the following knowledge:

  • Operating system knowledge. This is the foundation of everything.
  • SQL syntax. This is a mandatory competency for using databases.

Prerequisites

Before using this guide, ensure the following tasks are completed:

  • Enable the DataArts Fabric SQL service.
  • Open the DataArts Fabric SQL service using a SQL editor.

For detailed instructions on these tasks, refer to DataArts Fabric SQL User Guide.

SQL Syntax Text Conventions

To facilitate the understanding of syntax usage, the SQL syntax text in this document is presented in the following format:

Format

Description

UPPERCASE

Keywords (parts of the statement that remain unchanged) are in uppercase.

lowercase

Parameters (parts of the statement to be replaced with actual values) are in lowercase.

[ ]

Content within square brackets ([ ]) is optional.

...

Preceding elements may repeat.

[ x | y | ... ]

Select one or none from two or more options.

{ x | y | ... }

Select one from two or more options.

[x | y | ... ] [ ... ]

Select multiple parameters or none. If multiple, separate them with spaces.

[ x | y | ... ] [ ,... ]

Select multiple parameters or none. If multiple, separate them with commas (,).

{ x | y | ... } [ ... ]

Select multiple parameters, at least one. If multiple, separate them with spaces.

{ x | y | ... } [ ,... ]

Select multiple parameters, at least one. If multiple, separate them with commas (,).