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
In stead of having to create an event to notify me when workflows are failing, I would like to easily enable that option from gallery after scheduling a workflow.
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.
When saving to our company's gallery, we must deselect dozens of assets for our numerous workflows every time they need to be resaved, which is very frequent.
I would like to suggest a select/deselect all button under manage workflow assets. This would save a considerable amount of time.
Thank you,
Daniel
It would be great to have an option to show intermediate output in gallery and allow user to modify that intermediate output before running the next step in a chained app environment.
This will come really handy in cleaning messy data which requires some manual input and user can complete their work form single gallery screen.
Currently the only way to achieve it is to build separate workflows/apps where first you have to download the messy data on your local drive and then upload it back via a separate workflow to complete the task.
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.
On far too many occasions I have been working on a workflow in designer with either the outputs disabled via the configuration or using containers (preventing file creation/updating during testing) and I would save them back up to server without remembering to re-enable these outputs, which causes lots of issues down the line when users are trying to access these processes.
A simple warning on loading to the gallery that there are disabled tools and what tool id they are would mitigate this issue.
Currently when I log into the Gallery, I can see all of the users who are using license keys assigned to me. I would love to be able to run some reports on usage and activation date as well as export the list of users to excel/csv.
-Dan
I would like to be able to open a user from the gallery - and see which collection(s) that user is in
If my collection is broken - I cant see users at all
Hey Team,
With 2020.3, the new Groups feature came into light, which is great, but seems like it was only half-thought.
It would have been nicely complemented with some API endpoints that would allow managing the groups' members - add, remove, list members, etc.
Seems like the API on Alteryx is like 100 steps behind and seems like the new developments are not considering adding APIs for the new released features. I feel this is a product roadmap issue.
As an admin, I would like far more ways to automate managing the Server/Gallery than the ones currently provided by Alteryx.
Integration with AD would be nice as well, we use SAML, and would like to have the option to import AD groups that would sync automatically in Alteryx - same way Tableau has those groups that are imported directly from AD.
Thanks,
Alex
Sometimes a schedule is enabled that we want to disable. We edit the schedule, click the button to disable the schedule, click "Save". Then refresh the page and it's enabled still. The schedule will not disable in some cases. In the cases where it does get disabled, clicking the "Save" button appears to have no action. There's no confirmation and the screen stays static. Two suggestions:
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.
The more I'm digging into the Private Gallery (on our own Server, not gallery.alteryx.com), the more I'm feeling that the UI and functionality is very non-user-friendly.
I would like to do something that I think is very basic (I am the Admin of the Gallery):
1. Create Apps and put them in various Collections.
2. Grant people access to certain Collections.
3. Have those people, when they log in, only see the Collections to which they have access to (that I granted them). And then run the apps in those collections. Nothing more, regardless of who they are.
4. Given all three of the above, but I do not want to see them listed as an Artisan, nor do I want to see them have their own studio
Currenlty, no matter what I do, they have Studios, and some are listed as Artisans (and as mentioned in a prior post, you can't delete their Studios). I've tried using Windows Authentication, but I get errors so that's not an option. It would be nice if the above were options regardless of the Authentication type.
Special characters cannot be accommodated when searching usernames or workflows in the Gallery and Admin UI pages.
Today the v3 api requires curator access. V3 has Getters that should work for users with API permission. The Getter should return the objects that user has access to. Example: GetCredentials for a normal user with API access should return credentials that the user has access to. Today they get a 401 auth error.
We don't want to make these users curators just to let them access the V3 api.
Allow LDAP COnfiguration on Alteryx Server ,Right now its only AD ,but LDAP will be for for SSO ,SAML .
The default view at gallery home page time will not support long titles for your workflows. I have several that get cut off with . . . . . and you need to hover over in order to get the full title. You can select a list view, which helps, and gives you more metadata, but you have no mechanism to save your table / list view as a default. Administrators should have the option to define a default view (tabular / list) and have it default that way for everyone who gets there, authenticated or not.
If you goto a private studio, you get the list view option. If you go to a collection, you get the list view option. If you goto a district, you don't get a list / table option set, just table set. Why?
There does not seem to be a way to set a (list of) favorite(s), even as an administrator. There should be a quick-hit button option to get you there, add it to a favorites collection, something. It seems like we went a long way to generate three different builds of ways to organize workflows, but left out the one that is most universal in similar tools. 'My favorites'.
The search criteria for adding a workflow to a collection *mandates* that you have a space, but doesn't tell you that is why you are not getting any hits; i.e., 'Water' and 'Water ' will give you 'no results found', or anything with water in the title respectively. Ugh.
Hello,
This issue relates to an inability to input data from a database where access to only certain columns is permitted. This is due to PII data being present in the data.
I am trying to pull data from one table at a time using the standard ‘Input Data’ tool.
As I do not have table level access I am explicitly specifying the column names and not using a wildcard. Please see the example below, query highlighted in yellow and the returned error in red. You will see the error message returned from Alteryx suggests a * wildcard has been used despite specifying the exact fields to pull.
Several of the Ford GDIA team and Ford HPC team have reviewed this with me and cannot assist. The HPC team believe it is a bug in Alteryx which has been reported by other users internally, that is ‘Select *’ commands being sent from Alteryx despite specific columns being outlined in the query to the data lake. As we only have access to specific fields within Ranger (due to PII data) the select * fails and returns an error.
I can confirm my ODBC connections are all set correctly as I can pull from certain tables where I have full table level access but not others. Access rights are all in place as I can use the same query on Ambari without issue.
Thank you for any assistance you can provide,
Michael Higgins
Example Query
Select STATION_ID, STATION_DESC from dsc60082_qlscm_tz_db.qlsc_station limit 10
Info: Input Data (3): ODBC Driver version: 03.80
Error: Input Data (3): Error SQLPrepare: [Hortonworks][Hardy] (97) Error occurred while trying to get table schema from server. Error: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [mhiggi37] does not have [SELECT] privilege on [dsc60082_qlscm_tz_db/qlsc_station/*]
---
Hi Michael,
I believe it would require turning off the queries we currently run to retrieve metadata and retrieving metadata only for the columns selected in the query.
Please submit to our Idea Center for consideration. Thanks!
--
Angela Ogle | Customer Support Engineer
It would be great if the admin could change some default settings on the Alteryx Gallery page. For example, where we have the list of apps, show Detail view and sort by App name ascending by default.
in the current alteryx gallery if we need to disable of enable the schedules workflows we need to manually enable or disable them.
example if we have 100 scheduled workflow. and we want to disable all of them and then enable them later. currently we spend hours to manually disable and enable each of them.
By adding a feature to select the workflows in scheduled to enable of disable the selected one at one which will save hours of time.
Alteryx has the power (no pun intended), and Power BI has the visualizations.
But, why use two interfaces when you could use one?
A concept we started kicking around was embedding a PowerBI.com visualization into the Alteryx Gallery.
In theory this should work, but we're interested to hear if anyone else has tried it or has a best practice for embedding links into Gallery reports.
It should be possible to take the dashboard link:
Then, drop that into a text input tool to have it embedded in the output.
The idea is that certain dashboards would be linked to certain report results to allow an end user to drill into the output of the Gallery report specific to each result output, thus creating an interactive drill down in one interface.
Thoughts? Ideas?
User | Likes Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |