-
Query Tagging for Snowflake
Description: Currently, when a dashboard or card in Domo queries data from Snowflake, there is no way to track or attribute the associated Snowflake compute cost back to the specific dashboard, card, or user that initiated it. Organizations using Snowflake as a federated data source in Domo often want to perform cost…
-
Targeted Data freshness check during Dataflow execution
When a Dataflow executes with a Snowflake dataset it will use the previously staged dataset, and only copy in a update if the results of the previous data freshness check indicate that it should. Consequently, the dataflow will miss any updates that have happened since the last Data Freshness check. Considering the…
-
Snowflake Connector - Some Tables not connecting
Hello. I have recently set up the Snowflake connector in Domo, and when I try to connect the tables, some of them time out without an error message and do not connect. When I try the manual option of typing in the Database, Schema, and Table names, it says those tables do not exist, when they do. I can see them under…
-
❄️❄️ Tip of the Week #22: Snowflake Series part III: Run Your Magic ETL Flows Directly in Snowflake
No more exporting data from Snowflake to transform it in Domo. With Magic ETL on Snowflake ❄️❄️, your data transformations run directly in your Snowflake warehouse, without moving data, all from Domo’s visual interface. This feature is ideal for low-code users and teams that want to keep governance and performance within…
-
❄️❄️ Tip of the Week #20: Snowflake Series part II: Build ETLs and Write Back to Snowflake ❄️❄️
In Domo, you can build ETL pipelines that read from Snowflake ❄️, transform your data, and write the results back to your Snowflake warehouse, all without leaving Domo's interface. This approach keeps your data governance in Snowflake while leveraging Domo's visual ETL capabilities for seamless transformations. Follow…
-
❄️❄️Tip of the Week #19: Snowflake Series Part I: Build Content in Domo Using Live Snowflake Data ❄
If your Snowflake–Cloud Integration connection is already set up, you’re ready to start creating value, without moving a single row of data 🎯 What can you do now? With the connection in place, you can: Create cards and apps in App Studio directly from Snowflake tables Build alerts and automated updates using live data…
-
TimeZone Change For Data Ingested from Snowflake to Domo
I set up a Snowflake Connector to pull a dataset from Snowflake. There are a few variables with timestamp. The time displayed in Snowflake is ETC. However, when it displayed in Domo, it looks it automatically adjusted to a different time zone. Is this expected? How does Domo adjust variables with timestamp? Can I update…
-
Cloud Amplifier - Snowflake - Choose schema and custom DB and Schema names
For Cloud Amplifier on Snowflake, it would be helpful if we were able to: Choose both the destination DB and Schema that the data lands in (rather than having to go only to the Domo managed DB and Domo manage schema "RAW_DOMO". Be able to rename the DB and Schema that is generated when the connection is set up The reason…
-
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
-
Snowflake Connector | Partition Functionality
Which Snowflake connector is best suited for efficiently utilizing partition functionality when working with datasets that need to be partitioned across multiple columns? For example, if a dataset contains sales data and needs to be partitioned by columns such as region and sales_date to optimize query performance and data…
-
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…
-
Account transfer from Regular to Key Pair
Is it possible to mass transfer Datasets from a regular Snowflake Connection account to a Key Pair connector account?
-
Using merge in snowflake connector
Hi, I am trying to optimize efficiency with the snowflake connector by changing the update method to merge. My data set has a column that shows when each row was last updated. I want to use this to pull only data that has been updated since the last time the dataset ran in domo. However, I can't seem to find any way to…
-
import Snowflake integers as integers
Snowflake stores integers as type number -- see e.g. https://docs.snowflake.com/en/sql-reference/data-types-numeric#int-integer-bigint-smallint-tinyint-byteint. So when Domo imports them, it considers them to be of Domo's number type rather than Domo's integer type. Domo should be smarter: if it sees a number(38,0) (or…
-
How to Update federated data automatically?
I tried interacting with a card, but it still didn't work.
-
Combine tables using ETL inner join
Hi everyone, I'm trying to combine two federated tables using the inner join in Magic ETL. Both tables have over 9.5M rows but when I join them, the result is only 87K. I tested the join in Snowflake and it resulted in 9.5M by the logic: SELECT * FROM 'A' INNER JOIN 'B' ON A.X = B.X What could i be doing wrong? *I'll need…
-
What is the difference between Multi cloud and federated?
What is the difference between Multi cloud and federated? We use snowflake for data warehousing, trying to figure out what's the best way forward. and is there documentation that spells out these differences.
-
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
-
Snowflake Federated dataset refresh rate
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…
-
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…
-
Add Data that has been modified in the last 7 days
I have a snowflake dataset that has a modified date column. I want to merge the data that has been modified in the last 7 days to the dataset. Sometimes an order is modified after its placed and we want to capture the new values of the order. I have used this query but its not working SELECT * FROM "TABLE" WHERE…