-
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…
-
Direct Query against on-prem source
Can Domo perform a direct query against an on-prem SQL Server instance? For example, if I have a database named "SalesDB" on my local SQL Server, can Domo connect to it and run a query like "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'" directly? I thought workbench would've have that option.
-
Expiration dates for dataset refresh
The challenge lies in the temporary nature of this requirement: the dataset needs daily updates only until the end of the month (EOM) when the marketing promotion concludes. After this point, daily updates are unnecessary. To ensure data accuracy and relevancy, I've configured the dataset to update automatically every day.…
-
Azure SQL DW Connector do not have Upsert function
Everytime when i run the dataset to update few records it takes hours together to finish. How can i do upsert function using this connector. There is another connector 'Azure Synapse' and it appears that one is also missing this functionality. Thanks!
-
How to create BI Analyst Playbook?
I am looking for a best practice or template to create a playbook to showcase the tips and tricks to the user community to implement editor role. Thanks!
