-
Details about, and alternatives to, the DataSet query API
I gave the datasets/query/execute v1 API a try today, and have a few questions: * What idiom of SQL is this using? It took me some time to get the name escaping done in a way that Domo tolerated. * Is there any dedicated documentation on the system, other than the sparse details I've found at…
-
Remotely trigger a DataSet refresh?
I'm checking out some of our options for speeding up data ingestion in Domo. A few of our Postgres pulls are taking longer than we would like, and I'm exploring creating a materialized view to cut the PG processing time down to 0, from Domo's perspective. That still leaves the data transfer time, and the Domo processing…
-
MySQL Data Flows clarification: MySQL version & window functions (row_number)
I've neglected MySQL Data Flows because I'd passingly assumed that they were for MySQL-derived DataSets. It seems not, it looks like a MySQL DataFlow is a DataFlow that uses an embedded version of MySQL. Is this correct? I've seen mention of Window Functions in passing, and assumed the MySQL must be 8.0+, as that's when…
-
Is there any way to do an UPSERT with data coming from Postgres?
Our main SQL database is Postgres, and we're populating DataSets with calls similar to select * from view_for_domo We're using full replacement, rather than incremental pulls. We're interested in using incremental updates rather than full refreshes of the DataSet to speed things up. After checking the options I can find in…
-
Command line tools and the "DQL"
I was pointed to Domo's CLI tools today, and the documentation mentions the DQL in few spots. domo.com/api/domoweb/auth/helpcenter?redirectURL=/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool I assume that's the "Data Query Language", a find a few references to it in the command summaries:…
-
Time zone (bug)havior summary and questions
I just stumbled across some issues in how Domo manages datetime values and have some questions. I've looked through the docs and the Dojo and see that my questions aren't rare. After reviewing a lot of materials, I'm still not clear about how to show charts in local time when you have users or facilities in different time…
-
Is there a way in Domo to plot date and time against a *fixed and gapless* x-axis?
Is there a way in Domo to plot date and time against a *fixed and gapless* x-axis? When we plot by hour, we want all 24 hours, not just any that are present in our DataSet. For the gaps, we would like a 0. I set up a simple dummy DataSet, and can't find a way to make this work. I found this thread from four years ago:…
-
Card API? List cards that use a DataSet?
I just had a look at the API docs, and it looks like there are a lot of features we could use. I've gone through the obvious pages a couple of times, and am not finding a Card API. Is that right? I've got several uses for such a thing. On my mind today is auditing PDP rules. Given how we're set up, I'd like to be able to…
-
Automating getting figures out of a card
We're loading some of our data into Domo from Postgres, and then giving some clients Domo log-ons to explore their data. They're quite happy with this, but sometimes need to extract specific values or results from a Sumo or API card to forward on to their boss or colleagues. In plenty of cases, the target user does not…
-
Migrating Cards to a New DataSet: Tips and advice
I'm researching what's involved in migrating many cards to a series of new DataSets and have been doing a bit of reading and experimenting. I already posted some information to an old thread on this, but it seems like a big enough subject for its own topic. For background, my current task is to shift three DataSets to a…
-
Strategies for monitoring or alerting about failed updates
For production data, we've got two paths for our data to get into Domo: 1) Scrips build Excel workbooks that are imported via Workbench. 2) Centralized data is stored in Postgres, exposed through a view, and then pulled in via the Postgres SSH connector. The question is, how do people go about detecting late jobs? This…
-
Plotting against the x-axis as a continuous scale
In Domo, some chart types treat the x-axis as a continuous scales, others plot only data points present in the data set. The behavior seems to be baked into the chart type itself, and is not an option, at least not for numeric values. Time series seem to default to a continuous scale. The issue here is that if there are…
-
Adjusting chart properties dynamically with data?
We've got large DataSets that we slice in various ways, such as by company, division, or subdivision. There are quick filters and page filters in place to make this easy. My question is how to recalibrate charts dynamically based on the current data being charted? A Filled Gauge has static properties for "Minimum Value"…
-
Connecting to the Data Governance connector
I just heard about the Domo Governance connector on another thread, and it sounds pretty interesting. The log-in procedure for this connector is different than most. You need your Domo subdomain name and an authentication token (API key.) I've generated the key, put in the required values...and get authentication errors.…
-
DataSet API: Only DataSets created with the API may be used by the API
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
The new spark line and bar chart types. What's the point?
<rant> I try and check the release notes every time there's a new Domo version to see what's new and improved. I was very excited this morning to see that spark lines and spark bars have been added. Yes! Unfortunately, they're a total disappointment. I'll try and stay polite, but I just can see any reason for these new…
-
Pulling numbers as DECIMAL over SQL
I'm migrating cards to some new DataSets and am checking for conflicts in advance. We've been pushing Excel spreadsheets and will now be pulling from Postgres. Domo has three numeric types: LONG, DOUBLE, and DECIMAL. I cannot figure out how to pull data into DECIMAL. I care only because they come in as DOUBLE and Domo sees…
-
Best strategy for appending data from multiple sites to one DataSet?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: APPEND failure behavior?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API versus Stream API
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: Can multiple sites append to the same DataSet?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: UPSERT support?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…