When a schedule fails with an “SQL Compilation Error,” the following causes may be considered:
- Syntax Errors: Mistakes in the SQL query’s syntax or incorrect usage of keywords can prevent the query from being properly interpreted, causing a compilation error.
- Data Type Mismatch: If a value with a different data type than expected is used in operations or function applications, an error will occur.
- Use of Undefined Variables or Functions: Calling variables that have not been declared or functions that do not exist within the query will result in a compilation error.
- Misuse of Reserved Words: Using reserved words that have special meanings in the database system as table or column names can cause errors.
How to fix:
- On your desktop, if using a dashboard or note, execute “Run with Data Import” If using steps, charts, or analytics, execute “Re-import Data from Data Source” to check if the process works correctly.
- If the same error occurs, review and correct the SQL in the data source.
If the problem persists, please contact Exploratory Support.