-
Federated dataset: can I prevent a non-filtered preemptive query?
I am using a federated dataset (SQL Server) with hundreds of millions of records, for thousands of users. It appears that Domo retrieves or queries the entire data set before any card is displayed, resulting in tremendous resource usage. When a user views the card, I am providing a filter that restricts the query to one…
-
Allow manual refresh of Cloud Amplifier / Federated dataset schema
I would love a quick 'Run Now' button on this dropdown for Cloud Amplifier and Federated datasets. When building new models where I'm making frequent changes and adding cloumns, I have to wait and wait for the schema to auto refresh from the database for my data to show up again. I think the main workaround now is to lower…
-
Need Role, warehouse & backend table details of account in DOMOStats
Hi, We need a role, warehouse, backend table details to show for perticular account created in DOMO. So in case of snowflake accounts we are unable to trace the same. Thank You. Best Regards, Tejal
-
Join Domostats with federated Outh dataset
Can we have an option to join domostats with federated Outh dataset in domo. Currently it used to throw an error while joining them in domo ETL.
-
What is the credit cost associated with a Federated Dataset
So if I am using federated data from Snowflake what would be the credit consumption for the same considering I am in consumption model.
-
Federated Datasets - See Table Source after Importing
It would be highly beneficial if we could view and modify the source table used in Federated Datasets, particularly with Athena-Federated queries, after the initial execution. Currently, after the first execution, there's no option to see or change the source table. This means that if you need to make adjustments or switch…
-
Cache configuration
Hello Folks, I understand for a Federated Connection, the DOMO cards will fire queries directly to Snowflake. However, I have few questions around this: Will there be any cache stored at card level? Will there be any cache stored at user account / user session level? Will there be any cache stored in DOMO for my connected…
-
Federated Dataset returned a 502 error
Hello, I am trying to create a federated connection but got an error saying "…returned a 502". I am able to preview the table, but I am not able to see any data on the created dataset because of this error. Any help on this will be very much appreciated. Thank you.
-
Configuring Card for Last Time Federated Dataset Refreshed Based on Browser Time Zone
Hello, I am trying to visualize in a card when the last time a federated dataset has been refreshed based on the timezone that a person's browser is set to. For example, if I see that this dataset last updated at 2 PM and I am in the Eastern Timezone, I would want that a person in LA time see that the dataset last updated…
-
Can use FIXED with SQL data
-
Show Federated Redshift Data Source in Data Source Settings
Would be great to see the table or view the federated source is pointing to within the settings of the data source. You can already see and select columns. Currently you have to rely on keeping the location within the data source name.
-
Table Total Row and Beast mode Aggregation
Hi experts, I'm tying to build a table of consumption by subtracting a total on different days. I'm using the lead to get the next value and subtracting the current one: When I able the total row option an error occurs: My first question is why is it happening? My second question is why doesn't the bar chart aggregate the…
-
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…
-
When does the Domo platform send a request for a query execution?
The redshift database is getting thousands of queries and is having a hard time keeping up with it. These are due to the federated data sources that have been established. Could someone explain when the DOMO platform send in a request for a query execution? I assume whenever any change is made in analyzer? Then the cards…
-
How to Update federated data automatically?
I tried interacting with a card, but it still didn't work.
-
Disable Auto-Preview for Cards (Federated Connections / System Wide)
We currently have a mix of Domo datasets plus federated datasets in our instance. When new cards are created, Domo often picks columns that are pretty irrelevant most of the time. While this isn't much of a big deal for Domo datasets since there is a speed advantage there, it creates a negative user experience for…