-
Pandas Boolean DType Compatibility Issue
Use Case: Domo user uses Jupyter to access an API and get data. One of the fields retrieved is a boolean returning either True or False. This get added in a column in a Pandas dataframe (we'll call it TF) and is written to a Domo dataset using domojupyter.write_dataframe. The dataset is saved and accessible, and the TF…
-
Sandbox and Virtual Datasets: Virtualize on the Source or The Target? Seeking Opinions.
Virtual Datasets are very helpful when implementing Sandbox. But where should they reside, on the Sandbox source instance or the target instance? Since the release of Sandbox, the recommendation has always been to put materialized data where users will consume it to ensure best performance. If the source instance is a…
-
Adding a Checkout Feature to Committed Versions
As we have versioning to our Sandbox commits, would like to consider the possibility of allowing a checkout of a version that may enable changes to be made without disturbing the actual objects in the instance.
-
Migrate User Overview Pages via Sandbox or Alternative Methods
We have an interest in using Sandbox to migrate Users' Overview pages. We haven't been able to do it at present. We could move cards into repos and then into pages named for each user. Then return ownership to each user and remove the pages. The number of users and the number of cards involved makes this a less desirable…
-
Dataset Copy Connectors Do Not Support Federated Datasets
I'm posting this as I ran into some older threads that recommended using a Domo Dataset Copy connector to access data from a federated dataset. There are different use cases where this may be desired. Recent testing for customer and consultation with colleagues suggests that you cannot use a Domo Dataset Copy connector…
-
Getting a Sum of Values for X Days When There are Gaps in the Dates
We have our dataset of transactions for a large number of SKUs. Dataset is over 1 Million rows. We want to examine the date of each transaction and go back 30 days to get a 30 day average of sales for each SKU based on the date of that record. Normally I would be thinking Row and Window tile in Magic ETL. But here's the…
