Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesHello all,
This may be a little controversial. As of today, when you buy an Alteryx Server, the basic package covers up to 4 cores :
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-Alteryx-defines-cores-for-licensing-our-products/ta-p/158030
I have always known that. But these last years, the technology, the world has evolved. Especially the number of cores in a server. As an example, AMD Epyc CPU for server begin at 8 cores :
https://www.amd.com/en/processors/epyc-7002-series
So the idea is to update the number of cores in initial package for 8 or even 16 cores. It would :
-make Alteryx more competitive
-cost only very few money
-end some user frustration
Moreover, Alteryx Server Additional Capacity license should be 4 cores.
Best regards,
Simon
Idea:
Using a few designers and registering to the Alteryx Gallery are good fits for micro and small enterprises, from investment vs capability stantd point.
Alteryx Server is suitable for medium to large enterprises with at least 45K USD budget yearly and many alteryx users possibly more than 20...
Don't you think there is a need for something in between? I propose Alteryx mini-server (well we can find a better name hopefully :)
Rationale:
Many Alteryx clients seem to utilize Alteryx designer for ETL,
then some of them further enrich data and model forecasting or predictive modelling.
Before even considering a server they output to a BI server like
If there is a need for automation Alteryx designer + Scheduler does all the trick needed.
Once you update everything in a repetitive fachion 100s to 1000s of Qlik or Tableau users can reach to the most uptodate content and discover dashboards...
I believe we can do a similar thing with a mini server...
What to do:
Currently, many of our most useful apps in the gallery utilises blocked tools (download tool, R tool etc). Every deployment or even minor updates to these apps require emailing the Alteryx Curator account for exception requests. This process is quite cumbersome, although the need for it is understandable. However, given that not a single app from us was ever rejected (and we submitted dozens of requests) , it would be great to have a process in place to apply for a permanent whitelisted status. This would give trusted app authors the ability to deploy apps with blocked tools without emailing the Curator.
One of our biggest areas of confusion for new users of our Gallery is the Download button. They often click it thinking that will give them their information right away. It would be great if the person didn't see that or the scheduler option if they were not an Artisan, since they can't use the workflow anyway. It would be even better if selecting the workflow took them straight into the question portion.
As we continue to build Alteryx Workflows for the business, there is a continued need for an organizational structure for saving and storing Alteryx Workflows within the Alteryx Gallery. Organizing the workflow repository through a "folder hierarchy" will allow users to quickly navigate and find the appropriate workflow. Currently, the workflows are listed in alphabetical order and requires the user to remember the Alteryx Workflow name and click to the proper page.
Any enhancements to the Alteryx Gallery organization structure would be greatly appreciated!
Thank you,
KK
Hello all,
Right now, we can choose either MongoDb or Microsoft SQL Server as a backend. I would suggest to add Postgresql. Why ?
-it's open-source
-it's reliable
-it's free
-it works well on many environments
-it's popular
-it's already used as backend for Tableau or Qlik and many others
-it respects SQL norm and doesn't have a lot of specificity
Best regards,
Simon
We have the need to bulk-add users, and to bring in their information (full name; location; etc) from Active directory.
Right now, adding users is a 1:1 process which is highly painful.
Desire is to be able to take a list of Kerberos IDs, and bulk add them as users - and then select a group of them and permission either for the gallery; or for designer licenses.
The workflow result window shows the Name/workflow, AMP, Priority, Assigned worker, Run as, Completed at, Runlenght, and Runtyp of the workflow. The following feature would also be useful on the page.
1. Showing the creation date of the workflow without taking queue time into consideration
2. The option to change the time zone would make it easier to analyze the logs
3. Detailed insight about the particular workflow results, such as average execution time, failure count, and success count with date filtering.
Hello!
I found a weird bug in my travels today.
The TL:DR is that when a date input tool within the interface tool is used within a collapsing radio button, it defaults to "dd/mm/yyyy", breaking any app when this is not filled out:
Both values are default - i have not edited these values. The weirdest part is, this is Server/Private Gallery specific. When this workflow is downloaded and run within Designer:
And the workflow runs fine.
I have not tested this with any of the other interface tools, however I suspect this to not be the only tool this issue resides within.
I have attached the workflow I used (not that it would take long to recreate) for testing.
I would like to see some functionality in the Alteryx Gallery in which you can select multiple schedule workflows to disable/enable. Currently as an admin if I have many schedules I need to enable/disable I need to go into each schedule manually to disable or enable. This is okay for one or two, but I have about 20-30, it is very time consuming. I would like to see maybe some checkbox functionality next to the workflow to select and then an option to either disable all selected or enable all selected.
While in a workspace or collection, it would be great to be able to select multiple workflows and perform a bulk action on them (e.g. delete). This would help cleaning up unused workflows quicker.
Thank you
Hello Alteryx Devs -
So, I'm poking around the Atlerxy Gallery API stuff with an eye toward building a set of classes that can interact with workflows without exposing Gallery proper to the community at large. That being said, I was a little dismayed to find that all interactions require inclusion of *user specific* API Keys and Secrets. It can be dealt with, but ultimately it means that configuring a middleware tier between the real world and Alteryx server requires an additional hierarchical level; i.e., understanding which of the developers came up with workflow X and having *their* API Key / Secret attached at configuration time.
Anyways, it might be easier to just have a global trusted key / (super) secret. If you get that, you can execute a workflow.
Maybe we have a special studio that people could clone to, and in this way, you'd only have to track a single key/secret outside.
I mean, the existing system works OK for one offs, but if you wanted to have a (semi) modular system in place, dependence on understanding publishing entity specifics seems to muck things up for no discernible benefit. Of course, maybe in some places there is benefit to this scheme (?), but it is causing me to craft some weird work arounds early in development, which gives me a sinking feeling.
Or am I doing it wrong?
Thanks for listening.
brian
We have at the moment our server configured to work with SAML credentials. Whenever a user sets the credentials option to be "User must specify own credentials" the validation is performed using the servers own local user, giving out an error whenever some workflows with SSO data access are uploaded.
It would be great if a window would pop up or credentials could be configured for the validation to aviod seeing the error to show up.
When a user publishes and schedules a workflow on the gallery, they have the option to specify their time zone to ensure that the execution of the workflow occurs at the appropriate time. However, if the workflow invokes the DateTimeNow() function, the captured time is in UTC. If it is important for the end-user to have that time that is captured be in their local time zone, they will need to manually (either within the workflow or as a user input for an Analytic App) specify the offset from UTC.
Instead, there should be an Engine variable that captures the offset (or the time zone) that the workflow was executed from (or scheduled in), which can dynamically adjust the DateTimeNow() output appropriately.
Idea:
To create an IoT district for the Alteryx Gallery...
Rationale:
Many vendors are now focusing on the IoT wave,
having some examples on IoT use cases would be a nice resource for many...
Best
The current Gallery API executes a job until it reaches a completion state with either success or failure. Once reaching that state, the callout to /v1/jobs/{jobId}/ will return an array of messages that can then be parsed to gather information about the execution of the job, similar to the output you see in designer or via the CLI when running a job directly.
It would be nice if the callout to the jobs endpoint would constantly update and return the messages array with each callout. With jobs that take longer to execute, our Gallery API wrapper could then report back to us and let us know what messages have come out as the jobs runs. For example, if a process takes 2 hours to execute, we might want to know how far along the job is or if it has met a special condition that will cause it to run longer, etc. To do that, we could add in message tools that report info messages to us. Unfortunately, these messages are ineffective if we are running via the API because we won't see them until the job has fully completed.
It would be GREAT if we could have an optional notes field in the gallery. When many tools are uploaded to a collection, the titles alone are not descriptive enough for end users. I have to publish a separate "menu" for reports that are available in the gallery. In some cases I have to number them. I wish users could just browse for themselves to find the application that is suitable for their use case.
As per design Alteryx Server retains all FAILED jobs in the Queue and Results collections even when we set the server to keep run history and results for x days
Purging records from Designer involves manual activity
Proposing the idea of purging these error records through automation script:
Step 1: Stop Alteryx Server
Step 2: Backup Mongo DB
Step 3: Replace big size files: AS_ResultsFiles.Files.bson, AS_Results.bson, AS_ResultsFiles.bson, AS_Queue.bson with Empty .bson files of same name in the backup/AlteryxService
Step 4: restore MongoDB from the backup (with the replaced files
Step 5: restart Alteryx service.
I think it would be good to arranged the Workflow results into tabbed pages by completion status, e.g. a tab for failures, warnings, success, all. We run about 200 jobs in the morning and have to page through all the workflow results to find failures.
Also would be useful to search workflow results by completion status, e.g. find all workflows that have failed.
I know that the documentation shows that you can setup a worker to a specific QoS so that it will only pick up work for a particular workflow or app, but there could be a greater use for it.
For example if the Admin could control what QoS means for each definition.
I.E. Application, vs a workflow that runs over an hour, vs in-database tools. Then it will allow the admins to self guide where the work is going.
Right now there is only three levels
This was great for Alteryx public, but for private Galleries we need to distribute the work better than FIFO.
Currently , once a user have SetPriority access ,he can select from Low, Medium, High or Critical priority levels to ensure certain jobs always take priority over others.
This feature can be misused as users can upgrade their priority levels to jump up the queue and later downgrade the levels. It's difficult to justify and ask each others when you have 1000+ jobs running in a day and it makes administration tough and gives unbiased Gallery to all end users.
It would be nice to have on Admin console, global option to set max priority level so that no user can jump up level beyond this.
User | Likes Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |