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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to explore undocumented SQL source data

Meteor

Hi guys,

 

assume I have a unstructured source database with over 1.000 tables and up to hundreds of columns per table. Some tables are completely empty, some columns within tables are also completely empty. Some columns contain the same value for every row, thus have likely no particular meaning. 

 

I am trying to use Alteryx to better understand the source data. Some ideas:

 

1. Filter empty tables

2. Filter empty columns within a table

3. Filter columns with only 1 unique value

4. Correlate columns to show redundancy

5. ???

 

Do you have any ideas, workflows, resources on this topic in general or one of the tasks above in particular? 

 

E.g. is there a practical way to even handle a large amount of tables within Alteryx? 

 

Thanks

Felix 

Alteryx
Alteryx

Hey there UnknownUser!

 

First and foremost, there probably isnt a single way to perform this exercise, but my recommendation would be the following;

 

1. Get a list of the tables in a DB, probably directly from the management studio interface

2. Feed this list into Alteryx through the Dynamic Input tool, which would connect to each table (though you'll have to break this into some kind of Batch macro because each table's structure is different)

3. Then use the Data Investigation tools, specifically the Basic Data Profile would work, to enumerate which columns have 0 distinct non-null values, which would allow you to filter these out of the data set.

4. From there other data investigation tools would be able to be used to give you high level descriptives on each table's set of columns

 

Exploring unstructured/undocumented data is always interesting, but Alteryx should definitely have tools to help with the process!

 

Cheers!

Zak

Alteryx Partner

Do you need the data to stay in those tables? This makes a huge difference in how this is approached. If you can disambiguate the data from the original tables and just extract the data we can do some interesting things.

Labels