ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Connect Ideas

Share your Connect product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

0 Likes

Hello,

Could you make saving filter settings inside folders for each user individually?

We a have a lot of terms and other assets, and when user works with his own assets he would like to return to folder with last filter settings.

Otherwise user has to set up filters again.

 

Virtual folders are not convenient because if each of thousand users will create his own virtual folder(s) it will be hard to navigate inside thousands of virtual folders.

filter.png

 

0 Likes

Hi Alteryx Team,

 

I would like to suggest an improvement in the Alteryx Connect connect_catalina log file.

 

Currently, the log file contains only a timestamp and in order to get to a date + time combination, it is necessary to use the name of the file itself. Would it be possible to include the date information directly into the log? The use case is for example an integration with log monitoring tools. I am working closely with a monitoring team on a project and their feedback was, that it would be much easier to implement the integration with the date directly next to the timestamp.

 

Thank you very much for considering this idea.

 

Kind regards,

Jan

0 Likes

Hi Alteryx Connect team,

 

I would like to propose a change to a currently available feature - the alternate names.

 

On our client deployment, we are loading a number of databases, Alteryx Galleries and reporting servers. For the business users, some of the automatic names that are assigned to these source systems do not make much sense. Would it be possible to enable the alternate names for front-end editing after automatic loading? I know that the feature is available even for these assets, but I guess it is disabled in the config files.

 

Thank you very much for considering this idea.

 

Kind regards,

Jan Laznicka

Hi Alteryx Team,

 

We are very glad that the custom field functionality is available in Alteryx Connect. We were wondering, if it would be possible to enhance this functionality and enable additional features like the following:

 

  1. Location of the custom fields
    • The custom fields currently appear in the bottom right part of the asset pages. Very often, we are loading important informtion into these fields and it would be very helpful to be able to put them for example directly under the description field.
  2. Text editing options in the text fields
    • It would be great to have similar editting options in the text custom fields as in the description field. This would enable us to customize the look and feel of the pages and together with being able to move the custom fields around, this would be a great benefit for our users.
  3. People icons in Picker fields
    • One of the things we are using picker custom fields for are the different roles that we assign to Connect users - for example data stewards. It would be great for this "people" type of fields to have the same "icon" look as the out-of-the-box Owner and Contributor fields available in the Asset Details section.
    • Another idea would be to have the possibility to put these "people custom fields" directly under the Owner and Contributor fields.

Thank you very much for considering these ideas.

 

Kind regards,

Jan Laznicka

Hello Alteryx Team,

 

Would you consider creating a metadata loader for Databricks? I can imagine this being a part of the Analytical workflows section and be catalogued in a similar way like Alteryx workflows. On a number of clients, we are seeing Databricks jobs being used as a complement to Alteryx workflows and a possibility to have them both catalogued in Alteryx Connect would be of great benefit.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

Hello Alteryx,

 

The Alteryx loader does an excellent job capturing the Data Connection information from workflows and visualizing the data in Connect. It would be an additional benefit if the Data Connection information could get more granular and include the columns utilized from each table in the workflow.

 

An example where this will provide valuable benefits:

If you have a table with 100 columns and it's utilized extensively in more than 50 workflows, how do you analyze the impact when you're notified that column ABCXYZ is going to be altered? Connect can tell me which workflows are using the table, but it can't tell me which workflow is specifically using column ABCXYZ.

 

This would greatly aid users who may be searching workflows for specific column usage.

 

Thank you,

Jason

0 Likes

 Please provide a configuration option to make the DB_TABLES.TABLE_COMMENT for views appear in Discovered Description like it does for tables instead of in Technical Annotation.

0 Likes

It would be great if the File loader could recognize the SQL file extension to read and display the SQL script in Connect. An example would be similar to how the DDL is visible when you look at views in Data Sources. This would provide a large benefit when researching overall data usage and mapping to other data sources and workflows.

0 Likes

When I add descriptions to tables or columns in Connect then use that asset in a workflow, I would like to see the same table and column descriptions within the metadata in Designer. To illustrate, I've shared some screenshots...

 

Connect_meta_1.jpg

 

Connect_meta_2.jpg

Hi Alteryx Team,

 

Can you please add PDF or Word Download Option for Glossary Definition Term in Alteryx Connect. 

 

Thanks

Sri

We are moving our measure specifications that are in a PDF format to the Connect glossary.  We would like to keep the formatting that exists in the PDF when copying the spec.  However, the format doesn't always copy over.  It would be nice to have the 'Format Painter' option similar to what is in MS Word where you can copy the format from one line to another line.

 

We found out that we are able to setup Nexus modes in global config settings.

We can distinguish modes by relationship types and object types. It is nice.

We would like to distinguish Nexus setting by object’s location as well (to show/hide objects in diagram by their location).

For example to show terms from one folder and to hide terms from another.

We ask you to make possibility to setup Nexus to filter out objects by their location.

0 Likes

The addition of the On-Premise PowerBI loader is very beneficial. The current loader grabs PBI workspaces, workbooks, dashboards, and database connections all important to the PBIX files. It would also be an huge benefit if Connect could capture Paginated Reports (RDL file extension) information. 

 

Thank you.

 

Jason Melik

 

 

0 Likes

Hello Alteryx team,

 

Can you please includeSAP Crystal Reports loader in the Connect for Future Release.

 

Thanks

Sri

Our Data Catalogue in Connect has about 2 millions items (tables, views, columns).

I see next issues:

  1. We collect metadata from about 10+ DBMS. So after each Metadata loader run, Alteryx Connect will start load_alteryx_db script and process whole staging area (DB_*) tables, not only current extracted metadata set from single DBMS. It will lead huge redundancy.
  2. Follows from first issue: One-by-one comparison of loaded metadata will take a lot of time in real environment with 1-2 millions items (ordinary situation in large Bank). And this comparison will be executed several times. It will increase the redundancy in the number of DBMS servers.
  3. All queries in this script containing column or table name as a parameter (e.g. src.TABLE_NAME='${query_table_name}' AND                                 src.COLUMN_NAME='${query_column_name}') will be executed as many times as number of columns in Data Catalogue (millions times). It will work very slow because it executes a lot of queries.

Can you optimize somehow this process?

We use Connect widely among hundreds of users. During a lot of concurrent sessions Connect begin to work slow and unstable.

It is nice to have high workload detection - to warn users about potential problems/instability/slow response (either by email or via some banner at the Home page).   

Please add possibility to sort and filter by any field in any asset, which has internal table. For example - column list in table, table list in schema. Or in "Used in " widget. as for now - sort operation is only applicable for name field. it is not convenient for long lists. 

Hello Alteryx Team,

 

We would like to be scheduling the loaders from the administration console, Connections tab. However, when scheduling from there, the loaders are being sent to the Alteryx Gallery under low priority and therefore can easily end up in a queue. As we are scheduling a number of loaders that run for a significant amount of time, it is essential to have the schedules set on precise times and have a certainty that they will not end up in a queue. However, the low priority in the Gallery prevents us from doing that.

 

It would be great if there was a priority switch directly in the Connect's Connections section, where it would be possible to select how prioritized should the loaders be in the Alteryx Gallery. Also a possibility to select a specific worker would be greatly appreciated.

 

Thank you very much for considering this idea.

 

Regards,

Jan Laznicka

0 Likes

It would be very useful to have a standard metadata loader for chained workflows or apps.

 

Currently the Crew Macro Conditional runner or the Alteryx Event/CMD based workflow/app chaining or the chaining from interface designer do not have a corresponding metadata loader. 

 

At the moment the only option of creating a nexus for chained apps or workflows is to manually create the links between various assets and workflows. This can be highly tedious depending on the number of workflows/apps being chained, inputs and outputs involved in each workflow and also error prone.

 

This creates a sort of blindspots in terms of end-to-end metadata management and showing true lineage when using chained Alteryx apps/workflows.

 

As the chaining of workflows and apps is a major timesaver and helpful tool to break down larger jobs into smaller manageable jobs it would be massively useful to have a corresponding metadata loader.

 

Many thanks,

Gourab

Version upgrade of metaloaders gets difficult when customers change or add tools to already complex metaloader workflows.

 

Please better support customer customization by placing macros in the metaloaders at critical points

  • just after data input
  • just before data output

These macros would do nothing except pass data in and out

with the intent that customers build these out as they need to improve the resulting data catalog.

Most customer modifications could fit within limits of what these macros could do.

 

It would be easier to upgrade version when most often it only required replacing entire macros that had been modified.

The improvement would be worth the nominal impact on performance.

Where performance is a problem, un-customized macros could be removed.

.