Configuration Guide

Back Next

SQL Validation

When you save a custom query, the

MDM Hub

performs client-side validation of the SQL statement and then sends the SQL statement to the database for further validation.

Client-side SQL Validation: The
MDM Hub
validates that the SQL statement meets the SQL syntax required by the
MDM Hub
. For example, the client-side validation process checks that the statement begins with the keyword SELECT and the column names do not contain spaces or special characters. If the validation process finds an error, the process displays an error message.
Database-side SQL Validation: When the database receives the SQL statement, the database verifies that the syntax and grammar of the SQL statement meet the requirements of the database. If the SQL statement generates an error, the database returns the error to the
MDM Hub
, and the
Hub Console
displays the database error.