Tuesday, August 16, 2016

Gather Metadata For Each Column of SQL Table

Often when working with a new data set I'll run these queries to learn more about each column of data.

https://gist.github.com/aaronhoffman/eb30805ee2f5cafc64152dd1def800bd

For example, you can run a single query to union together aggregate data on each numeric column. Result looks something like this:



Hope this helps,
Aaron

Post a Comment