community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Knowledge Base

Definitive answers from Connect experts.

Connect Change Log Dashboard

Alteryx
Alteryx
Created on

Connect Banner.png

 

Alteryx Connect is great at finding data assets that exists within enterprises which helps data workers to shorten their journey to data-driven insight. One of the steps to refresh the metadata is to schedule the Metadata loaders. In this process, the data assets can be created, changed or removed. To take a look at this change log, we can take a look the backend of Connect - the H2 database.

 

2018-11-12_10-10-26.pngConnect Architecture Overview

By using this workflow, I was able to create a dashboard that helps you visualize these changes made after each scheduled process.

 

Below is what it does:

  • Connects to Alteryx Connect database using ODBC (Postgres driver)
  • Reports on all created/ changed/ inactivated (deleted) entries
  • Reports on details of changed entries at the key/value (attributes) level
  • Let you decide what date range you are interested in seeing changes for
  • Output the data to files (ideally YXDB as they can get quite large)

Note: You need to have the ODBC driver for Connect set up completed.

 

After it grabs the results, the workflow creates 3 different files in the specified folder:

  1. Dataset (.yxdb)
  2. Tableau Extract (.tde)
  3. Tableau Workbook(.twb)

The first 2 are just the dataset results in different formats while the Tableau Workbook is the dashboard which can be saved to the Tableau Server as well. You might also want to schedule this process to run after all Meta-loading processes have finished. This will make sure that this dashboard is up to date.

 

2018-11-12_10-22-39.png

 

Some of the other use cases that this change log can help answer are:

  • See all changes to the database structures - helps remove duplicates
  • Track user activity
  • Look at all newly created objects and content mismatch 

Thanks @DavidM for providing the change log workflow.

Attachments
Comments
Alteryx
Alteryx

Nice one, @DiganP