alteryx connect Ideas

A lot of information is not captured when colleagues run numerous SQL codes on server. Oracle, SQL Server, Azure and others...

Would there be a clever way of capturing and archiving all this queries run?

It may be wise to collect these for several reasons;

1. SQL code profiling is an important matter especially for DB admins. You can see the most required tables and fields etc.
2. Also have a grasp on most frequent and time consuming joins to enhance DB performance
3. Figure the queries that can be replicated in Alteryx and deployed to a server so that no business user needs to run SQL code instead  they will be reverted to the gallery.

So found out a similar feature is now available in SQL Server 2016 -->  https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-usin...  

Hello,

I'd like to suggest a "view as" on each page (like facebook) or a clear identifier that only certain people can view page. 

As an admin, I have to set permission setting for different group. It would be helpful to clearly see the permission setting as sometimes I forgot. 

Thank you.

If you remove the configuration of the SMTP server while you are in development, (the current solution to spamming users with notifications during the setup period of the data catalog) then put the SMTP server configuration back in when you are finished setup, all the changes that have happened in the interim will not be sent as a bulk send. This a risk when an email server is unavailable for a period of time that notifications for changes/comments/tasks will be missed.

Once the ability to switch notifications on and off is implemented, I think it would be worth reviewing how feasible this is.

The email notifications that are received are not easily marked or flagged/prefixed as coming from Alteryx. I expect that this may be on purpose so that data owners can't "hide" from changes/comments on their areas of expertise, but from a time management point of view, it would be good to be able to flag them in some way so that a rule can be run on them in the users inbox, and they can batch up their reviews/answers.

Hello...We've found that when we assign an alternative name to an asset, the alternative name becomes the first name listed, and the main name becomes listed within parenthesis. Could this be reversed? As it's always best to have the main name of the asset listed first, then any alternative names/alias to be listed within the parenthesis. It creates visual order having it displayed this way. We've ended up not utilizing the alternative name functionality to avoid any confusion for our users. 

Currently - CustyID, CID(CUSTOMER_ID)

Request - CUSTOMER_ID(CustyID, CID)

Thanks!

for the past 8 months I have been using alteryx and mostly working with the connect in db components , there are many issues which I am facing and i this this can be improved 

1. there is no such  flexibility of creating a table with the keys defined which is the most important pillar in database, also the options provided are limited , i.e. to create a new table , delete and append, drop table and recreate, 

now, there are many times where in we  need to update the tables based on the keys, which i find missing. Also how the option is defined is create a new table, next time if the job is run it states that the table is already created, for which we need to manually change the option in the next run.

2.which switching between in db and alteryx , if the records are more the alteryx lags completely and the job keeps running for hours , how can we achieve the flexibility  of alteryx designer if there is such bottleneck.

3.the flexibility that is provided with alteryx designer should also be given to in db components.

4.the parameters defined in the workflow can not be accessed in the in db  formula tools but can be used in the designer formula tools. this reduces the flexibility.

please look into the same

Our client is considering introducing Alteryx Connect.

They are considering sharing metadata to thousands of users.
So it is not realistic for administrators to create accounts one by one.
Therefore, we want the function to import user lists.

Initially we considered connection with AD,
However, we could not be used because users and server of Alteryx Connect belong to different domains.

Therefore, we want the ability to import user lists.
Or, we want an extension to import account information in AD into Alteryx Connect.

This might be a dumb ask, but I run into this alot. I have a workflow that has over 1000 tools and is super long. I would like to be able to to either right click and lock the connection sting so i can let go of the left click , scroll down to the tool, and then click on it to make the connection. Also, it would be nice to have the ability to right click on a tool and click a button "Connect to last used connection" as i sometimes join to the same table multiple times. Lastly, I just thought it would be cool if we can defined tools that are connected to the most so when i right click on another tool, i can open a drop down and select one of the most joined to tools, without even having to click on the original.

When Alteryx connect is first installed to a company with a small alteryx designer base, you do not benefit from lineage.

There are not much workflows at hand. So in order to realize Alteryx connect's immediate benefits I'd like to suggest;

a company-wide Data Quality Score.

1. Let's score each data element in distributed data stores
2. And automatically give a simple scale between one and five
   • 1 equals to, “we don’t know”
   • 2 data is entered or updated prior to 1 year, has conflicting data
   • 3 would be the norm and means customer provided this data, as accurate and as up-to-date as they have entered it and ‘agreed’ to share with you.
   • 4 means we cross checked the data with 3rd party sources or the addresses work in Google Maps”.
   • 5 equals to “we had the customer or the representative validated the address in last 3 months”.
3. The scale will be based on;
   • Missingness
   • Information value (variance is high or not, if there is no variance no info useful thru the column)
   • How many times that column is addressed in other tables
   • Format (structured like a telephone number ###-##-## or semi structured like an address)
   • Is it an ID column
   • Is it a Datetime column, any discrepancies in date time columns etc.
   • Time since last update of data
4. Once we have some lineage information than we'll weight th data based on how frequently it's needed, how many formulas are requiring the field etc.

And as soon as we install connect we'll have a grand vision of our data and even we'll be able to track the status of our whole distributed data assets with a trend line if we are going better or worse... Here is an example;