-
Can I run a Stored Procedure to an external MS SQL and import resulting dataset?
I have large amounts of data stored in an external MS SQL database. Complicated queries are run via a stored procedure, and the resulting dataset is written to a table that I currently have connected to DOMO to produce client dashboards. I'd like to call the stored procedure from the DOMO data connection, have it run,…
-
Option to schedule datasets in UTC or local time
When we schedule datasets today, Domo schedules them in UTC, so there are no adjustments for Daylight Savings changes. This means that we need to reschedule datasets that must refresh at a specific time of day locally (i.e., 6 AM Central Time, regardless of whether we are in Standard or Daylight Savings time) twice a year…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…
-
Using Dremio Iceberg tables and time travel feature in Domo?
Hello everybody, Is it possible to create a dashboard that utilice iceberg tables from Dremio to perform time travel? Looking for something similar to this: Thank you in advance!
-
Creating views on Domo virtualized datasets from the client/subscriber side
We have a customer who wants to be able to create and view virtualized datasets in Domo from the subscriber/client side. Unfortunately, this feature is not currently available in the product. However, the customer has found a workaround for this issue by using Dataflows within the subscriber -instance.
-
Can the trade desk connector be used with MFA?
I am trying to set up the trade desk connector. Right now we are using an email connector to get the data into Domo but we have found accuracy issues in this method. I am running into issues with MFA in the connector. Has anyone successfully gotten this connector working with MFA enabled on the trade desk?
-
Expanded Options for Dataset Alerts
Datasets often require monitoring that is complex. My idea is to make the dataset Alerts more dynamic, so that an Alert could be sent in case the dataset row count did not change, or if another undesirable outcome occurs. We occasionally experience an issue where the dataset updates successfully, but the row count does not…
-
Outlook Calendar
I know that Microsoft 365 has DOMO capabilities for all platforms but looking for additional data coming from Outlook. I am aware you are able to add cards from DOMO into Outlook but looking for adding a shared calendar from Outlook into DOMO. I don't believe there is a way currently where we can feed data from Outlook…
-
FileMaker data needed to send to DOMO daily
I am working on sending over records from FileMaker each day on a update frequency. I have an API connection between the two sources but am having trouble finding the best possible method to send data to DOMO every 15 minutes. Right now I am using the import method but it will only replace data and not append. As this is…
-
Data Flows - Testing Use Case Filters
Use Case: When building data flows with data sets in millions of rows, it's hard to test if the logic works across those rows unless I add filter tiles that filter out data at specific points during the Data Flow build process. This can add complexity when adding many test cases at specific points. The Idea: It would be…
-
Magic ETL: Avoid loading all the input columns and rows from data vault.
In Magic ETL, to avoid loading all the input columns and rows from the data vault. On the Input tile, under “Data Handling Section” if there could be a provision (refer to attached pdf with screenshot) check box to select required columns (simple request) and text box to add a where clause on each column Or one text box to…
-
DataFlow Notes - Output Datasets
I would like the DataFlow Notes on Output Datasets to be available in the DataFlow's /datasets view (possibly using the same yellow note embellishment icon as used within the DataFlow.)
-
Stock Price Data Connector
Is there a connector to NYSE/Nasdaq/etc. share prices that doesn't involve hosting a Google sheet or any other additional artifact outside of Domo?
-
Amazon Connector Error
I'm having trouble updating my dataset using amazon selling partner API. The error is: The report being downloaded was not processed as it returned a status of FATAL so cannot proceed. Here is the configurations of my connector. Any help is appreciated!!!
-
I want to host a webinar on how to automate all manual uploads into DOMO
If you find yourself spending an hour or more every week manually tweaking and uploading data to DOMO, I want to help show the DOMO community how automation can help streamline your efforts where a connector or integrations don't exist or resources are not available. If this sounds like something you would be interested in…
-
Properly Writing Back to Output?
Hey, first time Domo Jupyter user, and a new Python user. I'm having a difficult time exporting my data to a new dataset. From this: I keep encountering this error: /home/domo/.conda/lib/python3.9/site-packages/domojupyter/io.py:125: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future…
-
Comparing Datasets to Determine Variance
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
-
Google Analytics Dashboard APP to connect GA4
Can Domo team update the Google Analytics Dashboard APP? Since Google has sunsetted the UA, there's no more data in there, and Domo GA APP doesn't support the GA4 yet so we can't really build dashboard directly connected to GA4.
-
extracting data from Epic EMR system
I'm looking to connect with a customer or gain some insight from any users that leverage Epic (Electronic Medical Record system) as a data source. I am trying to understand the best way to extract our data from Epic to SQL Server with an ETL process or push subsets of the data directly to Domo. Any info will help - thank…
-
Remedying Data Recording Issues on the Front End in Domo
I have a dataset with item names. These item names have a preassigned "price" to them that is not in the source data (although I know what they should be). What has happened is that some people (not all people) record their transactions all at once, combining what should be multiple revenue values into a single one.…
-
A way to identify/report on hidden datasets
Found out that when users add certain full service apps from the appstore to your instance, it can result in "hidden datasets" existing in your platform. These datasets aren't visible in the datacenter, nor do they appear on any Domostats reports. Per support, Domo has an api endpoint that can be searched by dataset owner…
-
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…
-
Azure Dev Ops Connection
Hi, I am trying to get data from azure dev ops. For work item type data. I have the azure dev ops connector but it does not provide me all the data I need. I have tried odata but that is not working due to auth errors. I have a case open to investigate. Has anyone used a different pattern beyond azure dev ops connector or…
-
Is there a way to disable auto refresh of a dataset?
I want to stop an API data set from ingesting further information going forward as it is getting replaced with a different dataset. Is there a way to stop the data set from making API calls and ingest new information?
-
Not getting GA4 data to reflect accurately in Domo
Hello, I'm having a hard time trying to pull in data that correctly reflect what's in GA4. I've read through multiple threads to reduce the number of dimensions to just a few, and have broken one big report into several smaller pulls (list below) but I'm still getting numbers are that significantly different. I'm also…
-
Trigger a dataset update via python using a post call
I am currently successfully triggering a dataset update from Snowflake to Domo via python using the following code: import requests #list of dataset ids and stream ids for the Snowflake>Domo connections guids = { 'datasetID': 'StreamID', 'DatasetID2': 'StreamID2', } #Does the work of kicking off updates for all Domo…
-
Dashboard "Save-As" Dataset Change Option
When you click “Save-As” on a dashboard, it should give you the option to change the dataset(s)! This would extremely useful for creating new versions of dashboard if the underlying dataset(s) are changing.
-
Workbench - SharePoint Plugin
Hi there - Where do I find the sharepoint plugin for workbench? As referenced in the below documentations: