Limitations in the 'code' mode in Bold BI

Published:

In Bold BI, the code view mode is designed to provide a streamlined and secure environment for executing specific types of SQL statements. This article outlines the types of statements that are permitted and those that are restricted within this mode.

Allowed Statements

SELECT Statement

The primary type of statement that can be executed in code view mode is the SELECT statement. This statement is used to query the database and retrieve data based on specified criteria. The SELECT statement is fundamental for creating data visualizations and reports in Bold BI.

WITH Clause

The WITH clause, also known as Common Table Expressions (CTEs), is also allowed in code view mode. This clause is used to define temporary result sets that can be referenced within a SELECT statement In Bold BI.

Restricted Statements

DDL and DML Queries

Data Definition Language (DDL) and Data Manipulation Language (DML) queries are not permitted in code view mode. This restriction includes statements such as:

CREATE
ALTER
DROP
INSERT
UPDATE
DELETE

These types of queries are used to modify the structure of the database or manipulate the data within it, and their execution is restricted to maintain the integrity and security of the data.

Multiple Queries

Running multiple queries in a single execution is not supported in code view mode. Each query must be executed independently to ensure clarity and maintain control over the data retrieval process.

Additional References

Was this article useful?

Dislike

Written by Siranjeevi Murugan

Updated

Comments (0)