genesis dayrit

fractional head of data / ai engineer / startup consultant

← Back to all posts

Information Schema Tables are Goated

Last modified: 9/25/2024, 2:48:26 AM

I think people who work in data don’t use information schema tables enough.

There is SO MUCH solid information that you can get out of these tables.

Basic display of columns, row counts, memory size.

All of these are helpful for data engineers (and especially consulting data engineers) for inspecting databases and gaining a more well-rounded view of the data that is available in an org.

They are great for observability, documentation tooling, and even optimization of queries.

Highly recommend making use of information schema queries if you work in data.

tags:

sql data data-engineering