Best Of
Re: Grant "Manage Datasets", but lock down a few datasets
I hope someone has found a better way, but here is what we have done:
1. Do not give them the grant to manage datasets
2. Create a dataset tag "RESTRICTED"
3. Add the RESTRICTED tag to restricted datasets we don't want them to see.
4. Bulk share all datasets without the tag "RESTRICTED" to them as "Co-owner"
-You can share 50 datasets at a time
5. At the same time of sharing, a tag is also added in bulk to all 50 datasets called "Shared with BI Team" so I know which ones haven't yet been shared.
This could 100% be automated using a workflow but we haven't got that far yet.
A couple of Ideas Exchange ideas just went live in your instances...
Hi friends,
In addition to some bigger releases (that will go out next week with the regular customer release cycle), we were able to slip in a couple of small enhancements from the Ideas Exchange. You should see these little enhancements live in your instances now. :)
- Append Rows Should Default to "Include all columns" (as seen from Ideas Exchange here: https://community-forums.domo.com/main/discussion/65854/appends-should-default-to-include-all-rows and here: https://community-forums.domo.com/main/discussion/comment/100316#Comment_100316
2. Allow Group By without a grouping column (as seen in Ideas Exchange here: https://community-forums.domo.com/main/discussion/53581/magic-etl-allow-group-by-without-a-grouping-column)
I know these are little things, but I hope they continue to reinforce that the Magic ETL engineers and I are hyper-focused on you and your experience using our product.
Let me know if you have any questions!
Take care,
Your Friendly Neighborhood Magic ETL PM
Re: Request Access Button
I am also looking for simillar option. Did you get any updates?
Re: SQL Dataflow - Left join reduces number of rows in left table
resolved. This was just an issue of the sorting. All rows from the left table were kept, but automatically pushed to the very bottom of the output table. Thereby i didn't see those rows. Order by revealed this to me.
Re: Custom Color by Value in Symbol + Grouped Bar Chart
Thanks for the video response. Although not what I was looking for still think I will be able to utilize for something else I am working on. Will definitely check out some of your other videos
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 organization, which connector would provide the most effective implementation for this use case?









