Saving a SQL template

This API is used to store specified SQL statements for future reuse.

Parameter description

**Table 1** URI parameter
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID, which is used for resource isolation. For details about how to obtain its value, see Obtaining a Project ID.

**Table 2** Parameters
Parameter	Mandatory	Type	Description
sql	Yes	String	New SQL template.
sql_name	Yes	String	Name of the SQL template you want to save. The name must be unique in the current project.
description	No	String	Description of the SQL template. The value can be an empty string.
group	No	String	Name of the template group

**Table 3** Parameters
Parameter	Type	Description
is_success	Boolean	Whether the request is successful
message	String	System prompt. If execution succeeds, the message may be left blank. If the execution fails, the value is the cause of the failure.
sql_id	String	ID of the SQL template
group	String	Name of the template group

Create a SQL template.

{
    "sql": "select * from t1",
    "sql_name": "sql1",
    "description": "use to select t1",
    "group": ""
}

{
  "is_success": true,
  "message": "",
  "sql_id": "1994b029-3f76-4281-9e35-e370cb4ee26d1501998934432"
}

Status Code	Description
200	OK

For details, see Error Codes.

Parent topic: SQL Template-related APIs

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.