-
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. . 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 number(n,0) for any n) column to be imported, it should import it as an integer.
-
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…
-
Snowflake key pair
I have two connections, one with the normal Snowflake connector and one with the Snowflake Key Pair. The normal Snowflake connector works fine but the Key pair connector is not returning any number values. The string fields are returning values, it's just the number fields that are null. They are different users, but the…
-
Snowflake Connector Column Limit?
We're currently testing our Snowflake-Domo (key pair) connector and running into issues when querying wide tables from our Snowflake instance. The table in question is ~12M rows and 400+ columns. Currently we import this into Domo with the Amazon S3 connector. This works, though can be slow (2-6 hours) to complete. We've…
-
How to use upload-snowflake domo-cli command
When i tried the upload-snowflake as upload-snowflake -j 'snowflake-jdbc-3.13.14.jar' --jdbcUrl 'jdbc:snowflake://pidfsdf76.ap-south-1.aws.snowflakecomputing.com/?warehouse=POC_WH&db=POC&schema=LANDING' -db 'POC' -schema 'LANDING' -t 'TABLE_NAME' -w 'POC_WH' --jdbcUser pocuser…
-
Domo for Snowflake Solution Guide & Explainer Video
Find out how Domo can help you unlock the value of your Snowflake Data in the solution guide below👇️ Also, see the full Domo for Snowflake Explainer video here.
-
Best practices for performance with the Snowflake federated connector
Hi, I wanted to ask about any existing best practices for performance when building cards on top of a Snowflake federated connector. Also, I have two concrete questions: Are primary key constraints on the Snowflake side meaningful in Domo? Snowflake itself doesn't enforce those constraints, but they might be meaningful to…
-
Lock editing account details unless password is also entered
When changing account details for a Snowflake Federated account, an error can occur if the password isn't entered into the form every time and saved with the new details. When you open the form for the first time, the password is presented as ****** for security reasons. If you make a change to, for example, the warehouse,…