-
PyDomo issue to upload data em update dataset
I'm having trouble to upload my data to Domo using the PyDomo API. I read some .xlsx files and aggregate this files in one dataframe with the code below: Then I try to update my dataset using this code: domo = Domo(cliente_id, secret, api_host='api.domo.com') dataset_up = domo.ds_update(dataset_id,df_final) However I keep…
-
Federated dataset: can I prevent a non-filtered preemptive query?
I am using a federated dataset (SQL Server) with hundreds of millions of records, for thousands of users. It appears that Domo retrieves or queries the entire data set before any card is displayed, resulting in tremendous resource usage. When a user views the card, I am providing a filter that restricts the query to one…
-
Splitting up multiple-value fields into multiple rows
Hello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use Magic ETL to break these out so each row has one "Num": ID Num 1 10 2 20 2 30 3 40 3 50 3 60 Thank you
-
Allow manual refresh of Cloud Amplifier / Federated dataset schema
I would love a quick 'Run Now' button on this dropdown for Cloud Amplifier and Federated datasets. When building new models where I'm making frequent changes and adding cloumns, I have to wait and wait for the schema to auto refresh from the database for my data to show up again. I think the main workaround now is to lower…
-
Issues Regarding Data Type Specifications in Domo Workbench
We are experiencing the following issues with data type specifications when connecting data using Domo Workbench. The attached image shows the results of our tests when connecting data to Domo via Workbench. The "number_DOUBLE" column is of DOUBLE type, and the "number_DECIMAL" column is of DECIMAL type. Please note that…
-
DataSet Folders
As our dataset count in Domo grows, managing and finding the right ones is becoming more challenging. Right now, everything sits in a single list in the Data Center, and while filters and tags help, they’re not enough for long-term organization. It would be a huge improvement if we could group datasets into folders,…
-
Magic ETL Won't Save DataFlow?
Team, I have built an extensive ETL and I want to "Save and Run" to explore and analyze the output. Unfortunately, the "Save" button isn't responsive. I will click on it and it won't actually save. I'll click "Save and Run" and it won't actually save… Weird issue that I've never ran into before so hoping there's a simple…
-
Change Certification from Datasets to Dataflows
Certification is currently requested and managed via a dataset, however we've found that in some cases changes to the dataflow don't cause the certification to expire. This introduces potential risk in cases where changes could be made that affect the accuracy of the data, but the dataset could still be flagged as…
-
Two Data Sets, Differently Named Fields - Unable to create paired filter for dashboard cards
Domo community - need a hand on this one. I have two datasets: a) Client records (note: uses client UNID of "SGId") b) Events related to the Clients (note: uses client UNID of "ShowGroupID") Both sets have a common UNID that identifies the clients. One is named SGId and the other ShowGroupID as noted above. For the B data…
-
Dynamic Currency Symbol Formatting
Currently in Analyzer, number columns can be formatted as currency, allowing you to append one of 4 currency symbols to the beginning of the number in the chart. It would be incredibly useful to add a dynamic currency column option. Rather than having to select 1 currency symbol for the whole column, you could select…
-
Error when committing and promoting to another instance
When I commit my repository I am getting a generic error message with no actual id's to reference: Invalid content entity could not be added as a dependency of {contentType} with id {contentId}. Clicking the blue contendid takes me to two cards which have no errors. What could be causing this?
-
No Credit Charges for DomoGov/DomoStat Datasets
I'm an avid believer in utilizing business and technical metadata to train, govern, and administer business intelligence. The primary reason for selecting Domo for my new company was it's ability to visualize the full-stack data journey (Connect→Warehouse→Transform→Visualize→View) through metadata. This became the focal…
-
How to edit Data Assembler jobs
hello, How can I edit a data assembler job in domo? For example if I want to change the setting or create a new one?
-
SQL Connector dataset set to 'Replace' but the data remains the same
I am using the preferred SQL Server connector and pulling in data. However I want to "restart" this dataset and wipe it out to 0 rows. I set the update method to Replace and modified my query to return 0 rows. I can see my preview returns no rows: However when I run this, the updated rows shows - and the total row count…
-
Ability to Edit Virtual Dataset Jobs
The ability to edit virtual dataset jobs would help a lot when working between production and sandbox environments. We would like to group our virtual dataset jobs by data domain, to help make sure we don't end up with duplicate datasets in our production environment. However if we create a new dataset we currently cannot…
-
How to Set an Alert to Trigger a Workflow with Form & Task
I have a dataset with columns of date, line, crew id, type and duration. I want to set an alert case when the duration >120. Then I want to trigger a workflow to start a form with the below information: date line crew id type duration reason (I want the workflow to create a task for the receiver to input the reason) I have…
-
CodeEngine: JSONDecodeError
Hi All, I'm looking to query datasets from within code engine (a similar function exists but avoiding calling codeengine within codeengine to use that function) def new_users(dataSetId="insert"): url = f"https://api.domo.com/v1/datasets/query/execute/{dataSetId}" body = {"sql": "SELECT * FROM 'table_name'"} response =…
-
-delete
Please help delete this. My original post was backlogged, so it got duplicated.
-
Google Sheets Connector Issue?
Hi Team, I'm trying to get Google Sheets connected but receiving this error: I've verified that I can connect to Google Sheets by "Re-connect"ing on the Connectors menu. I cleared Cache/cookies/history, and this has worked in the past so I've never had this issue. Any ideas?
-
DomoStats Datasets report - Add Cloud Provider
Hi team, Our DomoStats Datasets report doesn't currently include a field which shows the cloud platform a dataset is stored on (e.g. Domo, Snowflake, Redshift). Same with the Domo Governance Datasets connector. Raising this here because a customer is looking for this functionality, and I do think it would be a useful…
-
Save Filter View for Dashboards & App Studio Pages with Selected DataSet
For dashboards and app studio pages that consist of cards across multiple datasets, the page filters are automatically set to the first dataset in an alphabetically sorted list. However, there are often situations where 1 dataset may not contain all the values as another dataset for a column intended to be filtered on. The…
-
Equivalent to Excel Solver in Domo MagicETL?
Hi everyone, I'm working on a hotel lodging analysis and need to find something in Domo MagicETL with comparable capabilities to Excel’s Solver function. In Excel, we’ve used Solver to optimize the number of daily hotel room blocks (reservations made in advance) to minimize last-minute (adhoc) room bookings, reducing extra…
-
Export data from DOMO to Google Sheets on Schedule
Hello! I imported data from Snowflake using federated dataset to DOMO. Now I wish I can export this dataset to Google Sheets. I've tried Add-on, it partially works but it can't automatically run on schedule. I've also tried to use Magic ETL to writeback data but I can't get access to the API so it doesn't work. Can anybody…
-
Search the Dataset amongst all the available datasets
Hello, I would like to search the datasets (amongst many datasets) that uses Aggregate functions (Such as count or sum). Please help me with the steps.
-
How to create a custom roleto edit cards/dashboards, but only view (not edit) dataflows and datasets
I want to grant some users access to maintain and update their dashboards, and the ability to view the datasets and dataflows. I don't want these users to edit the dataflows or datasets because they feed several other dataflows and dashboards, but in the edit role data grants, I only see "Manage" or "Edit", no "View" level…
-
Datasets API - Get Metadata - RequestedParts
The documentation for the dataset-get-metadata endpoint here indicates that the "requestedParts" parameter can be used to specify which parts of the metadata are needed in the response. However, the documentation does not indicate list of accepted values. The sample request below also indicates a different param named…
-
Issue with form brick data flowing to app db
I have a form brick and the data flowing from form to app db. I have deployed the brick and have been using it across different locations. Now I don't see my app db running. I dont see my form input data flowing to app db. This is critical as we are not seeing the data that is recently collected. Can someone please assist?
-
Access Dataset Before Approval/Denial in Approval Center
I would like to pull submissions into a card to review before I approve/deny them in the Approval Center. Currently, the only way you can access the dataset is after the approval/ denial takes place, which defeats the purpose of the Approval Center for me.