-
What are the est practices to maximize speed and minimize data storage when updating a large dataset
What are the est practices to maximize speed and minimize data storage when updating a large dataset? I have an example but any tips on performance I'm willing to hear. We have a dataset that consists of an initial load (~ 1 million records) and a daily* update of ~ 20k records (and growing). Within the first year we…
-
Best way to get parquet data from AWS S3 bucket?
We have some parquet files being replicated to an AWS S3 bucket. I've started to look to see if I can use Amazon Glue to crawl the bucket, Athena to query the Glue table, and then Domo to pull data from Athena. I'm running into a few issues (like the initial load file Glue picks up as a table, says it has rows, but Athena…
-
Interact with scheduled reports via API (or better interface)
(This doesn't have to be an API thing but it feels like it should be an API. Also if this is already possible, please let me know!) We use scheduled reports a lot. We love them. However, every so often there will be some processing glitch that causes reports to go out blank. So it would be great if scheduled reports could…
-
SSO Gotchas?
Happy Domo Dojo Day! We currently do not use any kind of SSO as we have both corporate (Azure AD) users and non corporate users in our DOMO instance. Has anyone had any issues doing a mixed deploy where certain users can use their SSO credentials and others are forced to use their DOMO credentials? What other SSO pro tips…
-
JSONObject error with JSON Connectors
I am wanting to pull data from the Cisco Meraki API (http://postman.meraki.com/ and http://meraki.io/ for more details) and the long and short of it is that most of their JSON comes back wrapped in square brackets []. (Anything that is a List of something). With all the JSON connectors in DOMO I get an error -- A…
-
Is your Workbench GUI broken?
I opened up Workbench this morning and was welcomed with an update message. Unfortunately, after closing the update message I was taken to a Workbench window that lists all of my jobs, but I don't have the tree view on the left nor do I have the output/preview panels on the bottom. When I select one of my jobs, again,…
-
Comparing against a series
Happy Domo Dojo day! Does anyone have any suggestions on how to dynamically do comparisons on a series? For example, let's say you have a grouped bar graph that shows Net Sales on the Y axis, months on the X, and the series is 2017 and 2016. I can see the 2016 and 2017 sales easily enough. I can do some basic math to get…
-
I need help visualizing timestamps
I have ~ 60 million records of timestamps (HH:MM) and I want to see how those records are distributed through out the day. I did a line graph with the timestamps on the X axis and the count of each timestamp on the Y and that worked a bit. I had to disable a bunch of stuff because of the volume of records. But I feel like…
-
Selective Page Publishing
Currently if we need to publish a dashboard to another instance, we have to publish the root page and all children pages. Often we only want to publish the root page, and not the children pages, or not ALL children pages. And often we just want to publish a single child page. It would be quite helpful if we could be more…
