-
CLI with Task Scheduler
Anyone put the script directly into Task Scheduler to export a dataset? at the command prompt I can type the following separate commands (enter after each) java -jar C:/Domo/java/domoUtil.jar connect -s xxxcompany.domo.com -t 3xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx export-data -i 0DATASETIDHEREINTHISSPACE80c -f…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
Federated Datasets - See Table Source after Importing
It would be highly beneficial if we could view and modify the source table used in Federated Datasets, particularly with Athena-Federated queries, after the initial execution. Currently, after the first execution, there's no option to see or change the source table. This means that if you need to make adjustments or switch…
-
Load Domo Bricks Form with values from Existing Dataset
Hello, I'd like to load a domo bricks form with data from an existing domo data set. I see I can use the domo.get method: domo .get('data/v1/sales') I expected the string value to be a domo data set id, but from reading it seems I need to set up a manifest.json file to map each dataset to a convenient name. Where do I set…
-
Cache configuration
Hello Folks, I understand for a Federated Connection, the DOMO cards will fire queries directly to Snowflake. However, I have few questions around this: Will there be any cache stored at card level? Will there be any cache stored at user account / user session level? Will there be any cache stored in DOMO for my connected…
-
How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
Hi Domo Community, I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before…
-
Data storage
Hello, I understand any data coming from files and output datasets from DOMO ETLs shall store data in DOMO Cloud. Any of the following shall also store in DOMO Cloud? DataFlows SQL View (DOMO) Adrenaline Transform What if I use federated connection as my connector? or an API to retrieve data from source and leverage any of…
-
Dataset Scheduler - Timezone list limit and/or alphabetic sort
As a new customer setting up datasets, the time zone selector is just a poor UX. First off, the time zones aren't sorted any logical way. It would be nice if they were at least alphabetic. Type to search would be helpful. But my primary "idea" is to add functionality at the Admin level to limit the time zone selectors to a…
-
How can I efficiently identify specific columns in a large dataset using Domo’s AI/ML tools?
I’m working with a dataset that has 1308 columns, and I need to identify 5 specific columns that contain data like street addresses, credit card numbers, and property IDs. Or, at the very least, Domo provide 2-3 potential columns for each of the 5. The challenge here is that I'm unsure how these columns might be labeled…
-
Automatically add new fields from input datasource to dataset view
Makes no sense that fields added to an input datasource to a dataset view don't automatically get added to the dataset view. Huge headache to have to go into the dataset view and add a field every time the input dataset has a field added.
-
Direct Query against on-prem source
Can Domo perform a direct query against an on-prem SQL Server instance? For example, if I have a database named "SalesDB" on my local SQL Server, can Domo connect to it and run a query like "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'" directly? I thought workbench would've have that option.
-
Dataset with column labels
Is there a dataset (like DomoStats or Domo Governance dataset) that has info on column labels? I.e. what the columns on a table are labeled as (not the actual field names from the dataset). I'm trying to make some sort of tool for users to filter by labels used on report elements (not the actual column names, which aren't…
-
Is there a way to track which DOMO assets (cards, datasets, dataflow, etc) uses a specific field?
We found the Card Fields & Beast Modes Governance dataset which shows what fields are being used in cards and beast modes but we would like to track a field name from it's original dataset > name change (if it applies) > DOMO asset.
-
Add a place to put a link to data source
I would love to have an area in the data connector where I could put a link to the data source. This could have the same visibility as the description/tags/owner/etc. For example, if you are viewing your Sharepoint datasets in the data warehouse, you could see the name, description, etc as well as a direct link to the file…
-
Notification when dataset or dataflow runs
Hello, Have some clients asking about an alert when a dataset or dataflow has completed. Currently we just have failed notification but clients would like to get a confirmation on vital dataflows/datasets completed, during immediate need moments. Helps when we are using the DOMO cloud to pull data from DOMO into other…
-
Budget to Actual - Multiple Dimensions & Different Datasets
I have a budget dataset with the following columns: _Account _Subsidiaries _Department _Doctor _Location (Not in Use) _Headcount Resources _Placeholder 4 _Year _Period _Scenario _Currency _Measure _value I have an actuals dataset with the following columns: Appointment Date Status Appointment Type Patient Account Number…
-
Domo User Groups & Dashboard/Dataset Sharing
If we share a dashboard with, say, the Default group, all current and future people added to that group see the dashboard (as expected) However, the underlying dataset that powers the chart(s) on the dashboard only gets shared (individually) with the users who were part of the group when the dashboard was initially shared.…
-
Compressed (zip) Foler upload with 2000+ csv's, best way to upload and append all?
I am trying to upload around 2500 csv's of historical data into Domo to then compile into ~8 total files (they are deliniated in the file name of each output) and I can't seem to find an efficient solution to do this without uploading them individually. Any ideas? Thanks!
-
Hashing Data in Domo
I need to generate a file with PII data but we want to hash the data before downloading. Could anyone point me to the right direction on what can be done in Domo? the data is in Domo.
-
Explicit export permissions on Domo datasets
The primary goal of this feature is to provide organizations with the ability to control export permissions at the dataset level, ensuring that only specific datasets deemed necessary for export can be exported by users. This granular level of control will help maintain the integrity and confidentiality of sensitive data…
-
Change Data Capture (CDC) on Domo Datasets
It would be useful to have CDC capability on Domo datasets, creating a journal file of all changes to a dataset such as deletions, insertions, updates so that they can be tracks and potentially acted upon.
-
Multi-Value Card - Revenue and YOY % Change
Hello Community, I need help creating a multi-value card in Domo to show total revenue and year-over-year percentage change based on filter selection. The requirements are: Yearly Comparison: If for example FY25 is selected, show FY25 revenue and compare it with FY24. Similarly, for other fiscal years. Monthly Comparison:…
-
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
-
Olo Data Connector
Has anyone connected / created datasets from Olo? I have created the account connection but the help file on the Olo connector doesn't match the panes described…
-
Domo Packaged Apps Activity Visibility
I would like to see the Object ID's and their respective activity exposed in DomoStats data sets. As a specific use-case, we are looking to identify all associated Datasets, Cards & Pages embedded in Domo Campaigns, and their respective recent activity, to influence our archiving processes. At the moment, this is a…
-
bar graphs incorrect visuals
Hi, I am experiencing an issue with Grouped bar graphs. The x-axis is duplicated with the items, despite the data is seen correctly on Data Table (inside analyzer) and also when put on a HTML Table. Using beast mode calc for values. The category column is straight from the dataset.
-
NULL value Handling
I'm a bit frustrated by this one. I have done everything along the path to ensure NULL values are being handled appropriately in my data. Starting from flat files and ending in a dataset (with several non-Domo steps in the middle). All of my data appears as expected in the dataset, but as soon as I add the column to a card…
-
Dataset/Dataflow update trigger expirations
It would be very helpful, especially as customers move to consumption, to have advanced dataset update controls to have triggers expire. As an example, I have survey data that I want to update frequently during the survey window, but then stop once the survey has ended and no new data will be added. Right now my option is…