Hello,
I'm trying to create an email report using Dataset Watchdog. I'd like it to output the results of a custom query to an email, sent out on a periodic basis.
There are no examples to be found on Domo Support or on the Community Forums for how to structure such a query, or what the limitations of this SQL prompt are.
The Support page references the ability to make custom queries, but provides no examples thereof: (https://domo-support.domo.com/minasan/s/article/000005105?language=en_US)
There is also this post from last year on the Community Forum (https://community-forums.domo.com/main/discussion/67089/data-watchdog-adding-example-queries), which recognizes the problem, but that's it.
The empty prompt itself offers a simple SQL query to work by with generic nomenclature ('select * from table where column = condition', but it doesn't mention how to reference a table to pull from. Do we use the Dataset ID from the Domo Governance Tables? The name from those tables?
Not to mention other relevant questions, for example: How are column names containing spaces handled? Which functions can this SQL prompt handle?
Some examples added to the documentation page would be a fairly light lift, and would make this functionality extremely useful to all.
Thank you.