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>>’