-
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…
-
default dataset sharing
Hi has anyone worked out how to only let editors have access to datasets that have been directly shared to them and not shared by the fact they have had a card shared with them? We have applied PDP but not all datasets have the ability to have PDP applied. What we want is the ability for editors to have dashboards and…
-
NetSuite General Ledger Best Practices
How is everyone structuring their queries for transactions from NetSuite to Domo? I'm using SuiteAnalytics Connect and struggling a bit with the best way to ensure data is complete for an income statement and balance sheet. Specifically, what date range should I select? I'm joining transactions, transactionLine, and…
-
Cloud Amplifier Shift Data Timezone (Similar to Workbench)
Similar to Workbench jobs (as described here) cloud amplifier should have the option to shift the date time for all columns with date/time data types. This would be great to have on all connectors, but it is especially important for cloud amplifier as it inherently the connection point for many different datasets from…
-
Support for Snowflake Timezone aware Datatypes in Domo data viewer
TIMESTAMP_NTZ gets TZ converted and presented in Domo in the correct Timezone. TIMESTAMP_TZ appears gets mishandled and the UTC date is presented. This will reduce the need to prepare the data in snowflake before connecting it to Domo for use, speading delivery and avoiding TZ confusion. case ref: 05913115
-
add SSE S3 support for Snowflake Unload connectors
we discovered that we are only able to use the snowflake unload connectors if we disable encryption. would it be possible to extend the unload keypair snowflake connectors to support encryption (SSE S3?)
-
Improvement to Magic ETL when creating an output dataset you aren't the owner
I have edit access to the ETL, but did not originally create it. I can edit the ETL, but if I go to create a new output I get this error, "Whoops! It seems that someone has deleted the output Dataset "Dataset Name". There are two problems. First the error points you in the wrong direction, as the dataset wasn't deleted, it…
-
Exception error for account id and permissions
-
User's Time Zone as Variable in Programmatic Embed?
I have a dataset with quite a few datetime fields all in UTC. It's powering programmatically embedded apps that are being viewed by users in different time zones. I want each user to see the datetime fields rendered in their local time. Is it possible to pass in a parameter of that user's time zone, and if so, then what do…
-
Dataset Scheduling Customization Options
Our team ran into a scenario where we needed to update a dataset at 3 different times of the day, but current scheduling options for datasets don't allow us that option. The times were at 12pm, 2pm, and 5pm PST every weekday. Since advanced scheduling options only allow updates on intervals, and only a limited number of…
-
Splitting Appointments
Hi Community, We have a few providers that are mapped to different galleys. This is usually easy and clean, but of course there's exceptions that confound the entire process. Here's current state: Appointment Provider Galley Evaluation Mitch John Evaluation Justin John Evaluation Kristin Tanner Evaluation Kristin Tanner…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
Global Column Rename
Idea: I’d love to see a feature in Domo that allows us to rename dataset columns once, and have those changes automatically reflected everywhere that column is referenced (cards, drill paths, ETLs, beast modes, etc.). Problem Today: When we want to rename a column (for example, changing “Parent Account” to “Parent…
-
Create Primary Key on Dataset
I'm trying to implement an upsert using Domo Jupyter workspace (Python). The data is from a popular help desk API and includes fields ticket_id and event_id. Combined, these would be the primary key. I call the "audit" API which brings back the full audit record for a ticket. If I already have the ticket information in my…
-
Data Refresh Permissions - Option for "Manually"
We have a need in our instance when using the "Data Refresh Permissions" setting to have the option for DataSets/DataFlows to be set to "Manually" for most of our users. Currently, you can only select "Daily" as the least frequent option. We have users creating content that may want it to update more frequently than is…
-
No Credit Charges for DomoGov/DomoStat Datasets
I'm an avid believer in utilizing business and technical metadata to train, govern, and administer business intelligence. The primary reason for selecting Domo for my new company was it's ability to visualize the full-stack data journey (Connect→Warehouse→Transform→Visualize→View) through metadata. This became the focal…
-
Dataset Archiving
We would like to be able to see whether a dataset is archived or not within domostats datasets, and we would like the option to 1) manually set a dataset into archived state, or 2) prevent a dataset from going into archived state.
-
Deploying Snowflake - MagicETL as a MySQL export?
Hi Community, We're deploying Snowflake at our company. A part of this will be moving MagicETLs from Domo to Snowflake SQL transformations. Is there a way to export a Magic ETL dataflow and the underlying logic as a MySQL query?
-
Multiple Sync Schedules
It would be great if we could add multiple schedules for any dataset or Magic ETL. For example, being able to run a dataset every 30 minutes on Monday from 8am-11am, and then running one per day the rest of the week. Advanced scheduling doesn't allow for different times or different active hours on different days.
-
standard drill down for dataset
I have many use cases that for a specific dataset I create visuals and end up making the same drill-down for each visual. It would be nice to be able to create a standard drill down per dataset that syncs to all the visuals to that dataset.
-
PDP policies not working for a user
I am currently testing PDP policies for a dataset and dashboard using a column filter. I have used this feature before. While creating the PDP policies, I initially assigned them to a test user by default. I then removed the test user from all policies and assigned them to just one. However, when I tested my dashboard, I…
-
Enable Joins in Views on published datasets
The Problem My company publishes datasets to all subscribers on Domo Everywhere. Customers often need to manipulate these datasets (filtering, renaming, adding columns), which works fine in Dataset Views. They also frequently need to join datasets. While Views can handle joins for materialized datasets, joins on the…
-
Easy dataset field width extension
Hello, We often use Domo datasets to store responses from our LLMs and need a way to easily extend the width of the response column beyond 1,024 characters. Currently this requires working with the Domo engineering team. Is it possible to bypass that process and manage column widths directly in Domo? Perhaps in the…
-
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…
-
When converting a dataset to a view the type of some columns is changed
Hello, I have a dataset that I am turning into a view. When I do so, some columns get converted from Strings to Integers. How can I fix this? I am using the SQL Query window on the view and CONVERT nor CAST seem to work.
-
View-only permission for datasets
I would like to request a new role permission option for datasets: a “view-only” access level that allows users to view and analyze dataset contents but does not allow editing, updating, or deleting the dataset. Currently, users with dataset access can make changes that may unintentionally affect data integrity.…
-
Dynamic Filtering - Today Less and 30 days and oldest date
Trying to create an default filter on an app that looks at all the open orders, but excludes that last 30 days. We have a delay from time of SO issued and it being billed. Looking for Older (> 30 Days) on the app
-
More Control Over Data Refresh Permissions
It would be nice to have more granular control over data refresh permissions to allow some users the ability to schedule datasets to run on more advance schedules or more frequent than one hour. I discovered when data refresh permissions are enabled, only full admins are allowed to set advanced schedules or run more than…