-
Views of Federated Snowflake Datasets
Last week, I created a federated connection to a table in Snowflake. I created a view off of that data set so that I could use it in Magic ETL etc. When I look back now, the view says last updated 7 days ago. There is no update button or update frequency for me to change. I want the view to be updated consistently as the…
-
Magic ETL can use Federated Dataset
Hi, We have number of cases where we want to use Magic ETL using federated Dataset. Can discuss them? Thank You. Best Regards, Tejal
-
How do I delete federated agents on the Domo side?
I launched the federated agent a few times locally to experiment with it, and I no longer need these. My user has the admin role, and there doesn't seem to be any button or the like to delete them from this view.
-
Fiscal Calendar use with Federated Datasets
We are building the same Dashboard for both our clients and our own internal sales teams that use the same datasets (labor, sales etc.) The clients and our internal teams each have separate sub instances, and we would like to publish the same pages to both instances but apply a different fiscal calendar to each. As we are…
-
Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?
My company is migrating from Mode Analytics to Domo, and I'm trying to understand whether and how I can run ad-hoc SQL queries against arbitrary tables. As a software engineer, I regularly use Mode's [query editor](https://mode.com/help/articles/querying-data/) to gain insights into our PostgreSQL database data in…
-
MySQL support for federated datasets
I would love to see federated datasets supported as inputs for MySQL dataflows. Many of my customers want to copy/paste existing SQL into dataflows, and since Magic does not currently allow that, MySQL is their next best option. My organization uses Domo Everywhere to publish federated datasets and stock content to…
-
Snowflake federated dataset refresh
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…
-
Snowflake Federated Connector 'No federated agent was found for the provided values...'
Have been using snowflake federated connector for about 3 months no issues then today all of a sudden receiving this error. The error displays when trying to 'create' the dataset meaning I am able to navigate through the scheme browser, select and view the dataset I want to connect but once I get to the final menu and…
-
Allow Virtual DataSets as Inputs to Redshift / MySQL Dataflows
We use the Virtual DataSets toolkit item to populate our secondary Domo instance with data from our primary Domo instance. Domo calls the resulting virtual dataset a federated dataset (the data provider is "domo-federateddata"). Unfortunately we cannot use the federated datasets as inputs to Redshift / MySQL ETL dataflows.…
-
Federated Queries - Dynamic SQL Generation Improvements
I've observed that the dynamic SQL that gets executed for federated datasets isn't always the most optimal. For instance to fetch the possible value list for a series or quick filter, it is still executing the same query as for the main card. It would perform much faster if it did a distinct over just the column needed for…