I wanted to confirm a few limitations on the SQL API:
Based on documentation I have seen regarding Domo's SQL API, the following limitations apply:
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.
Thanks for the quick response! Did you find documentation that specifically says that? Just curious if I'm missing documentation somewhere, all I've been able to find is what is listed here.
I'm good with those limitations, joins would be nice but I understand it is not a RDMS so that makes sense, and I don't want end users updating or altering tables so that's actually a plus.
There used to be a page, but it appears to have been moved or removed.
https://developer.domo.com/docs/apis/data-apis/sql-api
If you look at the answers to a recent question I posted, you will see that new SQL functionality is right around the corner.