-
Re: Is it possible to use while/do loops in MySQL in Domo Dataflows?
@user013818 , DO/WHILE loops are EXTREMELY inefficient in SQL (and therefore at best we'll call it an Anti-Pattern). Window functions will approximate DO/WHILE behavior. Can you be more specific abou…1 -
Re: Is it possible to use while/do loops in MySQL in Domo Dataflows?
@user013818 i'm still not sure i understand your use case... but it sounds like, you need to generate a dataset that for each id, you identify all the possible values for each of the four variables a…1 -
Re: Alert History as Dataset
@lwang , all these options are ... ok, but if it were me and i HAD to have an alert, i would use a recursive query to construct a dataset that captures my alert conditions. so whatever your 'system h…1 -
Re: Tracking Domo User Profile Picture Updates
@swagner if that information is not included in DomoStats_ActivityLog, I think that would be a feature request / product feedback. EDIT:: OOOOOH except i think either DomoStats_Person or DomoGov has …1 -
Re: Is it possible to switch a data set to a different dataflow?
+1 to @MarkSnodgrass It is tempting for SQL developers to want to use MySQL and Redshift (and fair enough Magic may not seem intuitive), but it keeps the SQL developers as the bottleneck both in perf…1