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 (,). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot