Technology – How To Get A Database Table List In A Snowflake Database

I recently had an opportunity to work with the Snowflake database in the cloud using IBM Infosphere DataStage and need to get a list of the table in a specific database to do some dynamic ETL loads.  Fortunately, the metadata table documentation was helpful.  So, as is my usual habit, here is a SQL quick code Snippet.   This code only pulls the Table name because that is what I needed for my purposes, but the Snowflake metadata tables contain significantly more data than just table name.

Snowflake SQL Pattern

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.”TABLES”

Where TABLE_SCHEMA = ‘<<DatabaseName>>’

Related References

SNOWFLAKE > DOCUMENTATON > DOCS > SQL COMMAND REFERENCE > ALL COMMANDS (ALPHABETICAL) > SHOW TABLES

DOCS » GENERAL REFERENCE » INFORMATION SCHEMA