-
How to migrate Workbench jobs to new server safely?
I will be decommissioning my server Domo Workbench runs on and need to migrate all jobs to a new machine. The current Workbench has jobs that run as frequently as every 60 minutes. I figured I could just export/import the jobs/settings, and leave them in a disabled state on the new server, test my connections to Domo, then…
-
Safe to run Workbench on multiple machines?
I use Domo Workbench on-prem to upload data from 2 SQL Servers nightly via ODBC connections. I need to move one of the SQL Servers from on-prem to an AWS EC2 instance. Rather than pulling this data from AWS to my on-prem environment just to then upload to Domo, can I install Workbench on the AWS EC2 instance and move the…
-
Why do private embed links resolve to a "public.domo.com" address?
Our private embeds resolve to an address at public.domo.com. Is this normal? For example, if I go to a link like: https://mycompany.domo.com/embed/pages/n1234 I get redirected to public.domo.com address like this: https://public.domo.com/embed/pages/n1234 The embeds do not seem to actually be public. When trying to access…
-
Dataset Views - JOIN on date range?
In most database systems, you can create a join/view on date ranges like so: SELECT * FROM A1 JOIN A2 ON A1.ProductID = A2.ProductID AND (A2.SalesDate >= A1.StartDate) AND (A2.SalesDate <= A1.EndDate OR A1.EndDate IS NULL) However, a DataSet View in Domo only seems to allow joins on exact values and does not allow ranges…
-
Can I search for column names across all datasets?
How can I search ALL datasets for a word in the COLUMN name? For example, I want to see all datasets with a COLUMN name containing *address*. Search on the Datasets screen only searches within the dataset names.
-
How to properly partition in Workbench while allowing older data to come in?
I have a SQL Server dataset of 50M rows. Workbench runs the APPEND Update Method HOURLY. I use the table ID as the UPSERT key and the processing query checks the past 7 days ("Insertion Date") for new records. This updates older data unnecessarily with the same data, but protects against issues with the job not running for…
-
How to periodically REPLACE in addition to APPEND jobs?
I have a VERY large dataset that I've uploaded to Domo. I initially did a REPLACE to load the whole dataset. I then changed the workbench job to APPEND and use an 'update date' in the table to run HOURLY while checking back the past couple days for any new/missed data. Due to some bugs on our side, sometimes very old data…
-
How to append based on new IDs only - not upsert
Is there a way to append only NEW IDs in an upload job? I understand that I can do a "Replace" job for an initial load of a table, and then a regularly scheduled "Append" job using an UPSERT key and a smaller subset of data, such as data with a change date in the past 7 days per the Domo example here:…
-
How to join to a table multiple times?
I'm struggling to replicate a simple type of join my company does all the time in SQL Server within a Domo DataSet view. Perhaps this isn't possible to do yet. I'm hoping someone can help out. Attached photo which has most of the complexity removed, but shows what I'm trying to do. We see "Transactions" in one table, and…
-
Why would I use a DataFusion instead of a Dataset View? Will DataFusions be deprecated?
If a DataFusion has limitations on what can be edited after it's created, why would I use one instead of a Dataset View? When making certain changes to a DataFusion, you get the prompt that it is "no longer editable as a DataFusion", and must be saved as a Dataset View. Since Dataset Views are a lot more powerful (but…
-
Understanding TOTAL rows used in Domo instance
I can't seem to find an authoritative definition of which rows in my Domo instance count against my contract. What counts? Every dataset? How about datasets that are made from Dataset views? Datasets made from Data Fusions? ETLs? Shouldn't my total number in use be obvious somewhere? Where would I find this information?…
-
Domo Everywhere - how to remove Embed type of "Off" from report?
On the Domo Everywhere dashboard, I see rows for dashboards that USED to be embedded, but are no longer embedded. These show up as "Embed Type" of "Off". Is there a way to get rid of these rows? I realize I can filter the column, but it would save our users some confusion if these records didn't even exist anymore.
-
Domo Role "Admin" Can't see dashboards by default - why?
If I put a user in the "Admin" role, I expected them to be able to see ALL dashboards by all users. It doesn't appear this is true, and they must be in a group that has access to shared dashboards/cards. Is this normal behavior? What's the best way to truly have a user that can see everything in our instance?
-
Why do users see different settings in "Embed Dashboard"?
We are preparing dashboards to be privately "embeddable". When looking at Share -> Embed Dashboard, different users see different things set. For example, I can have a dashboard embedded as Public, and someone else has the same one embedded as Private. This is concerning as one user could have it set to Private thinking…
-
Does Domo have the equivalent of a SQL Server "View"?
Maybe I've spent too many years deep in SQL Server. SQL Server has the concept of a "View", which is really just a query, usually containing a join. Instead of having to write a query to join tables, I can just query the view without needing to know the underlying relationships. I don't see any equivalent in Domo that…
-
Should I really be using UPSERT KEY just to APPEND data?
I have a huge dataset I've uploaded through Workbench. I now want to run a daily APPEND of new data only. I don't see a way to define an "APPEND" key, just an "UPSERT" key. My data won't really change, so I really only need inserts of any records where the defined ID is not already in Domo. My append query looks for a…
-
In Workbench what does "DataSet Type" change?
I have Workbench jobs uploading Microsoft SQL Server tables to Domo. For "DataSet Type", I accepted the default of "Workbench ODBC". After setting up my jobs, I noticed there is a "Microsoft SQL Server" dataset type. What's the difference? In Domo, the icon changes if I upload as a "Microsoft SQL Server" dataset type. If I…
-
Any type of "HTML Decoding" built in anywhere?
If I have HTML in a text column, is there any built-in functionality to parse that? For example, if my data field contains "Employee<br>of the Month", can I have it show as Employee of the Month Is that a job for BEAST MODE?
