What to know list of metadata tables details in snowflake. in oracle we have user_tables..etc like oracle what to know metadata table in snowflake.
Eg: select *From user_tables where table_name='EMP';
1 Answers
Metadata is stored in Information Schema:
The Snowflake Information Schema (aka “Data Dictionary”) consists of a set of system-defined views and table functions that provide extensive metadata information about the objects created in your account.
SELECT *
FROM INFROMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'EMP';
Related