Limitations of SQL API

collinT

I wanted to confirm a few limitations on the SQL API:

1. Documentation states that joins aren't allowed, seems this extends to subqueries and CTE's as well?
2. UPDATE and ALTER statements are not supported through the SQL API

ArborRose

Based on documentation I have seen regarding Domo's SQL API, the following limitations apply:

1. Joins, Subqueries, and CTEs:
   • Joins are not allowed in the SQL API. This limitation extends to subqueries and Common Table Expressions (CTEs) as they are essentially advanced forms of joins and require similar underlying database operations.
     
2. UPDATE and ALTER Statements:
   • UPDATE and ALTER statements are not supported through the SQL API. The SQL API is primarily designed for querying data and does not support data modification or schema-altering operations.

These limitations are in place to ensure performance and security within the Domo environment. If you need to perform more complex operations involving joins or schema changes, you might need to use other tools within Domo or operations outside Domo before ingesting the data.