Alteryx Server Ideas

Today, if I want to save a job onto the Alteryx Gallery, I need full permissions to do so and it is a manual process.  For some organizations, this level of access is deemed excessive, which can make properly leveraging the Alteryx Gallery difficult.  Having the ability to write a "deployment" script that could publish a workflow to the Gallery, and potentially add a new workflow to a Collection would be incredibly helpful in these cases. ... View more

Use case: I need to schedule a workflow to run every 2 hours each day, with the first run at 7am and the last run at 7pm Current solution: I need to create seven daily schedules for each hour that i need the workflow to run Idea: Add an intraday "Start Time" and "Stop Time", or "Between" to the "Minutes / Hours" schedule type, so i can create one schedule that meets the use case requirements Example schedule with new parameters that meets use case requirements: Start Time = 7:00 AM Stop Time = 7:00 PM Repeat Every = 2 hours   Start Time could default to 12:00 AM Stop Time could default to 11:59 PM   ... View more

It would be helpful to have a central Logging tool for large & complex environments.   This would be useful to allow teams to have a central way of logging data transformation errors by error-type; severity; alteryx Canvas; etc. Right now, there's a message tool, but this doesn't provide a way to create well structured central logging across a team; especially once deployed to a server environment.   CC: @rijuthav @jithinmony @HengHe @RajK @ydmuley @revathi @Deeksha @MPistone @Ari_Fuller @Arianna_Fuller @JoshKushner @samnelson @avinashbonu @Sunder_Sriram @Rahul_Thakur @Rahul_Singh ... View more

Hello, I would like improved user management features and/or training   Display 100 does not seem to work consistently Click /navigate from user to user – once I select a user would like to go to next user Changes I make with filters refresh every time I go back – which means I have to constantly reset my view in between each user Modify user settings in collections – would like to modify user settings instead of delete and re add user     ... View more

Allow to create custom user security groups server . Sales User1 User2 Studio1 Supply chain User3 User 4 Studio3 Studio1 ...... ... View more

As the single user who upload workflow MYWorkspace ends up being very crowded.  I move them to collections to be able to share but on My workspace, I can not see which collection they are associated to. It would be nice if there was a column displayed that showed associated collections.   As well as being able to have some different types of category classification.  I would want something like a development stage: (In-progress, UAT level, deployed, retired) If they are retired a way to remove them off my general workspace area.     ... View more

As Alteryx leans more into the Data Science space - it becomes more important to be able to keep rich documentation of the project along with the Alteryx Asset.    This does also require the concept of a "project" on the alteryx server, which would allow for meta-tags; and various different documents to be added with the project.   This would include things like Requirement documents; test evidence; test data sets etc.   This would extend Alteryx from a data prep engine to more of a data-science workbench as different user groups can participate in a specific project. ... View more

I have tables that I need to run ETL jobs on every 5 mins. But, a batch job runs every day for an hour at the same hour. During that time I can't query the source. With the current scheduler setup; it appears that my only option would be set up multiple schedules. Each running once a day, and a separate schedule for every 5 minute increment of the day with the exception of the one hour my source can't be touched. Rather than that degree of hassle, doesn't it make more sense to set up a scheduled with and/or/not criteria? Example: Run every X minutes on Y days Except: during %t am - %t am on Z days I've seen some applications that have a visual scheduler for setting the exception times. That would be pretty cool too. Bonus points if you can make an admin console for the server which allows the admin to set blackout date/time by table or DSN for all users (override their schedules). ... View more

Issue: When Workflow names have similar beginnings on server a user cannot distinguish between them because the columns on this GUI are not expandable as would be expected. A user has to make their browser larger and all columns open proportionately.   Solution: Change column settings so users can drag column widths to make changes. A bonus would be to allow a user to set a default along with an option to always auto expand all.       ... View more

The publishing endpoint, a POST to api/admin/v1/workflows/, is useless whenever workflows, apps, or macros contain Gallery Data Connections.  The workflow will get published but valid Gallery Data Connections are ignored and the apps will not run.   Please add the same dependency checks against Gallery Data Connections as is performed when a workflow or app is manually published from Designer.   This might be considered a subset of the Idea Server API to extract / submit workflows.     Thank you for your consideration. Sincerely, David   ... View more

  It would be good to have these table headers sizable, so that it can be expanded to display complete Name (and other fields).   ... View more

I would like to collaborate with my team, but also maintain my own personal private studio.   Is that on the road map?   -Dan     ... View more

The Schedules tab of the Gallery currently lists all schedules, 20 to a page, with no option to filter.  I am currently managing 183 active schedules.  In order to find a single schedule, I have to sort by Workflow name, then page through 10 pages of schedules to find the schedule I'm looking for.   Please add an option to filter this list.    Ideally, I would like to be able to filter on multiple fields at once (example:  Priority = High, Status = Active, Owner = Bob Smith, Times Run > 20).  Barring that, a simple search option on workflow name, similar to the search option on the Collections tab, would be enough.   ... View more

Alteryx Designer is an amazing data tool but it’s partner, "the Scheduler" needs some much needed upgrades. The Scheduler interface that pops up from Alteryx Designer does need a complete make over. I’m not going to address this but rather focus on the functionality that if delivered makes the Scheduler much more useful.    Today I’m reading our Mongo db scheduler data using an Alteryx workflow and Tableau to show what’s happening on the Scheduler. This dashboard is what we refer to frequently to see the health of our companies data pipeline.  I’ll share both files soon.    Here are the top 5 features for the Scheduler.   Workflow priority ranking. When two or more workflows are scheduled to run at the same time, ‘priority’ sets the order of execution. Priority is set at the time of scheduling the workflow. Values range from 1 to 100. If a priority is not set the default is 50. The ‘priority’ field can be read from Mongo db.    Why: At midnight we set off several workflows. We want to centrally manage which runs first based on a common ‘priority’ field.    Restrict which controller and workers a specific workflow can run on. Default is to run on all servers. At the time of scheduling a workflow can designated to restrict which server to execute on. This creates a field called ‘restrict’ which server it cannot execute on.    Why: Some workflows only run on the main controller due to file system references. Also a worker can be tuned for CPU or Disk I/O and workflows that can benefit from this tuning.  Selecting a disk I/O intensive workflow to run on a server tuned for Disk I/O would speed up our workflows.    Set sequence of successfully completed workflows.  FYI: We used the Runner tool for a short time to resolve this issue but learned quickly that the Runner tool is like a bull in a china shop and brought our server down. The runner tool as it is today is not an option for production work.   Why: This would allow you to run several workflows one after another. For example the first would read from a data source, the second would do calculations on the data and the third workflow would publish the data. All workflows are given a ‘workflow-number’ which can be seen in the scheduler list and read from Mongo db.    If a workflow fails you can set the number of attempts to run successfully. Report attempts greater than 1 in a new field called ‘attempts’ that can be read from the Mongo db.    Why: Some workflows fail and if attempted to run again may work. This includes issues with locked files and workflows dependent on processes outside of Alteryx.    If a workflow runs more than X minutes the scheduler kills the workflow and reports a workflow error with a unique code called ‘execution-limit’.  This code can be read in the mongo db. The defaut is 90 minutes and can be set to any number of minutes. Each workflow can have it’s own limit.    Why: Some workflows start to hog resources and need to be killed. If a new workflow is added this is a good way to protect the overall scheduled workflows.  ... View more

It would be nice to have an inbuilt function(s) that return an identifier (NTLogin for instance when the gallery is setup with windows auth) of the user running the app on the gallery. Functions like - USERNAME(), DOMAINNAME() etc., helps.   I know that it can be achieved via the "__cloud:UserId" call , which is not officially supported by alteryx. It adds value if it is inbuilt within the product itself.   Regards, Sandeep. ... View more

An example would be where a user has a scheduled workflow that runs at regular intervals and they might want to look at the logs from the results from a specific date. Having the ability to filter the date column would help with this, as the only other alternative at the moment is manually working through the pages. ... View more

Hi all,   Currently, it is very challenging, nearly impossible, to distribute your workload between worker nodes as the image below. Curators should be able to manage this in multiple ways since the end-user doesn`t have a full understanding of the server architecture or strategy behind the idea. It would be helpful to have the worker tags working similarly to the credentials pyramid where we can have levels of permissions. That way, we can have collections, user groups or even single users with worker tags configured.   This is an addition to the idea suggested by @ivane_meimban  https://community.alteryx.com/t5/Alteryx-Server-Ideas/Enable-Curators-to-assign-default-worker-tag-at-user-level/idi-p/939289     Thank you, Fernando Vizcaino     ... View more

Hi all,   For a user to know if a schedule was successful or not, they need to go schedule by schedule to check each of them.   I suggest adding one additional column to show the status of the last run.  Something like this:     Thank you, Fernando Vizcaino   ... View more

In the Alteryx Gallery Collections the Workflow Upload Date doesn't sort properly. Instead of sorting chronologically (ex: Jan first Dec last) it sorts by number (Dec goes before April because Dec starts with a 1 while April starts with a 4), see attached for an example.     it flips back and forth between 2022 and 2021     In the example November and December are first because the month starts with a 1. Then April follows because it starts with a 4.  Then it starts to get messy because it does this: 12/16/2021 4/04/2022 4/26/2021 5/02/2021 That 2022 is in the middle purely because 4 < 5, that's not right.   I tried exploring the settings to see if I could change this but I didn't find an option to do so.   Two potential solutions: Change the format of the date to YYYYMMDD, then if it sorts numerically it will still work Don't sort numerically and instead sort chronologically, ex: April goes before December As collections get big sorting for the most recent workflow becomes a nightmare with the current improper sorting mechanism.   If I'm mistaken and this option already exists please let me know. Thanks! Chris   ... View more