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

Popular posts from this blog

How to Turn Off Microsoft Arc Touch Mouse Scroll Sound Vibration

Hacker News Dataset October 2016

VirtualBox Right-Click Windows Taskbar On Mac