Data Sources

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: https://www.dremio.com/blog/time-travel-with-dremio-and-apache-iceberg/ Thank you in advance!

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.

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…

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…

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…

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…

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.)

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?

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!!!

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…

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…

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…

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.

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.…

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…

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…

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?

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…

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…

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.

Hi there - Where do I find the sharepoint plugin for workbench? As referenced in the below documentations:

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…

From a DB admin I can see when Domo is connecting to the database, I can even see the query text that is being executed, but it is a pain trying to go back into Domo to find which domo dataset is making that query execution. If Domo would inject a block comment at the top of every query before it executes, that would make…

I have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…

Hi, this is a bit of an odd question but will do my best to ask it. I have a CSV file i am pulling for a SFTP, the file is in a CSV format and pulls the headers and first cell but it stops. After each comma the data is wrapped in double quotation marks, for example: 12328354,"User Name","1","Company Brand, Town" from that…

Hi Domo Community, Can you stream data from Salesforce into Domo in real-time? We recently switched to Domo for dashboarding and reporting. Our call center relies on Domo dashboards to set in-person appointments. The issue is that by default data can only be sent to Domo every 15 minutes. (Note: Our previous tool allowed…

I'm trying to pinpoint duplicate information, datasets no longer used, and consolidate data. Is There a way that I could pull a list(s) of all the datasets and/or dashboards that are in my Orgs Domo? Thank you

I'm attempting to do a Period over Period in a table, but want to keep the date range to previous week/month/quarter to keep it auto-updating and grouping the data in a particular way. My idea was to create a new column in ETL that is the same as the column I'm trying to do a Period over Period calculation, but from the…

What SQL should I be using during an import to collapse data from a column into ',' delimited strings? when I use: listagg(item.NAME,',') "ITEM(S)", I get the error: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# l27jpdhw1857xj1xsmvi0[400] with just item.NAME…