Alteryx Designer Desktop Ideas

Is it possible to add some color coding to the InDB tool.  I am building out models InDB and I end up with a sea of navy blue icons.  Maybe they could generally correspond to the other tools.   For example the summary would be orange.  Etc  Formula Lime Green.

it would be beneficial to add the same action available in the message result window to be added in the brows tool for the distinct value.

like the copy options. 

Alteryx really needs to show a results window for the InDB processes.  It is like we are creating blindly without it.  Work arounds are too much of a hassle.

Would be great if you could support Snowflake window functions within the In-DB Summarize tool

For heavy workflows (e.g. reading massive amount of data, processing it and storing large datasets through in db tools in Cloudera), a random error is sometime generated:  'General error: Unexpected exception has been caught'

This seems due to Kerberos ticket expiration and the related setting may not be modifiable by the Alteryx developer 'especially when GPO). Suggestion is to enhance the indb tools in such a way that they are able to automatically renew the Kerberos ticket like other applications do.

Br, Lookman

Hello, I noticed today when changing the database that my connection string is linked to that Alteryx Designer did not require my password to be reentered.  See below:  This is the initial state of the connection string:

Notice that the database ends in "...-dev" and there is an encrypted password embedded in the string.  So far, all that is fine because that's how I set it up.  However, I typed a different database to end in ...-dev-data-migrations" in the string (while keeping the same server) and expected to be prompted for the password again, but the connection was made with the existing password and I was not prompted to reenter it (see below):

While this is convenient, in my mind this represents a security problem because someone could set up an associate with a connection and only want them to be able to access that server, db connection, but might inadvertently be allowing them a connection to any other database in the same server that happens to share the same password. 

This is all the more risky considering it's standard practice to wipe out the password to a saved connection whenever there's a change to that connection.  These are standards in Microsoft SQL Server Management Studios, Oracle SQL Developer, and most likely many more.  I would even go so far as to say it's an industry standard to wipe the password whenever a change is made.  It's even standard with other elements of Alteryx Designer.  In the data sources quick connect window, you're unable to change the database after a connection was made to one database using SQL Authentication as is shown below:

Notice the existing user name and password combination only allows the one single database connection. 

I think it makes sense to change this so that the password is wiped out whenever any change is made to the connection.

Could you please support Redshift as well?

https://help.alteryx.com/2018.2/PredictiveAnalytics.htm

Right now as far as I know you need to add each DB connection manually. This works... but is quite time consuming when trying to run tasks against a cluster of prod databases. It would be awesome to pass a JSON config file,example below, to the Alteryx Engine and have Alteryx create those connections upon parsing the file. This would save tons of time, and allow teams to share a central config file with consistent aliases across their clusters to ensure their app connections point to the same DBs across workflows. It would also make on boarding a breeze for new developers on team.

Sometimes, when I am working with new data sources, it would be nice to have a dockable pane that would allow me to view the schema of all of my connected data sources. That way I could rename fields and change data types as needed without having to jump from one select tool to the other to see how the schemas compare.

There should be a macro which could be used as read input macro for in-db tools.

Similarly, there should be a write macro for in-db tools.

I have encountered problem with Oracle Direct Connection tool. I have the correct host, port, service name, user name and password (the same configuration works with Toad), but Alteryx still complaints the service name is not found on tnsnames.ora (ORA-12154). Well, the reason to use Direct Connection is that I do not have admin rights on my computer to edit the file, so it seems this kind of problem can only be resolved by reaching out to our IT service to edit tnsnames.ora for me.

We are big fans of the In-Database Tools and use them A LOT to speed up workflows that are dealing with large record counts, joins etc.

This is all fine, within the constraints of the database language, but an annoyance is that the workflow is harder to read, and looks messy and complicated.

A potential solution would be to have the bottom half of the icon all blue as is, but the top half to show the originaling palette for that tool.

ie  Connect In-DB - Green/Dark Blue

Filter In-DB - Light Blue/Dark Blue

Join In-DB - Purple/Dark Blue

etc.

in-DB workflows would then look as cool as they are !

Thanks

dan

Wonder if it would be possible to have a set of SQL tools in Alteryx which to the user would look like you are dragging in a tool to manipulate the data (such as filtering data) but in the background it is updating the SQL (such as adding a WHERE clause) meaning the module runs faster. This would be easier than having to manually update the SQL code and would run quicker than bringing all data through and filtering afterwards.

I know there is currently the Visual Query Builder, but this is quite fiddly to use so would be good to have something more user-friendly.

I would love to have the ability to easily populate an entire schema of tables into my work space without having to perform repetitive connections to individual tables. 

Ideally, this would include the ability to drag a schema onto the workflow and have all of the connection tools auto-populate.

I often have  a need to investigate data in many tables to verify its presence / validate the table contents. This would be a very helpful feature for completing this easily and completely.

Thank you!