-
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.
-
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…
-
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.
-
No error, but no change when using “Change Dataset Properties” API
I’m running into an issue running the “Change Dataset Properties” API, however. Running the code below should update the dataset name from “DataBricks Product Dataset” to “Databricks Testing”. I get a 200 status back and the response object returns the properties object as expected, but no change takes place either in the…
-
Error After Workbench Upload : Tundra Exception Duplicate primary key found - Doesn't fix itself
I am struggling to get this resolved through support. We have had these Datasets uploading perfectly well for the last 16 months via Workbench. Initially we upload all of the data using a basic Select query in Workbench and the data indexes fine. Then we set the wokbench on a schedule, amending the wokbench query to upload…
-
Selective card Transfer from one dataset to another
Dear all, We should have ability to selected few cards from the existing datasets to be transfered to another dataset. Currently it allows all or none. Best regards, Tejal
-
Need Export to Google Sheet & Google Slides
Currently we are unable to export data to google sheet/google slides from Dataset & cards. Can we have this feature avaiblable asap as we have many users requesting for the same. Thank You. Best Regards, Tejal
-
Problem with Personalized Data Permissions (PDP)
Hello! I use many dataset views for working, but lately, there's been a few of those that give me the warning "This DataSet now utilizes Personalized Data Permissions (PDP)". I didn't activate anything related to PDP. I'm the admin and owner of the dataset and the related views. What can I do about it?. Thank you.
-
Is there a limit on the data provided by the datasets API?
I am using the datasets api (https://api.domo.com/v1/datasets/<dataset-id>/data) to access multiple different datasets in my Domo instance using Postman. Everything works fine and Postman shows the response for all my datasets except for two which are both over 1 million rows. When I try to use the datasets API for these…
-
DataSet Default Access Set to 'Can Share'
When sharing a DataSet in Domo, there are currently three options: Co-Owner: Allows for editing and deleting DataSet (same as owner) Can Edit: Allows for editing and sharing DataSet, but can't delete Can Share: Allows for sharing, but can't edit DataSet at all Currently, our instance defaults to the 'Can Edit' permissions…
-
Database Management View Instead of Datasets/ETLs view
Currently users view their assets in a list in the Data tab. They have to use naming conventions, or tags to group these assets and the same goes for ETLs. The list can be filtered and includes shared assets by default but regardless it quickly becomes a mess that only encourages redundant asset creation due to low…
-
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?
-
Please Delete-- Duplicate
Please Delete-- Duplicate
-
Provider Prior to Upgrade
I am trying to determine who provided the evaluation prior to an upgraded premium procedure. I have all the data I could ever need, but I'm not sure of the logic to make it happen. The task is made more difficult because there could be multiple evaluations prior to a procedure, and evaluations on different dates than the…