Are you looking for a specific column in all tables in a database?
Use the schema INFORMATION_SCHEMA! It contains metadata about all objects in your database, including columns.
SQL
--Interested in finding a certain column in a certain database? Use INFORMATION_SCHEMA!
SELECT
TABLE_NAME,
TABLE_SCHEMA,
COLUMN_NAME,
DATA_TYPE
FROM SNOWFLAKE_SAMPLE_DATA.INFORMATION_SCHEMA.COLUMNS
WHERE 1=1
AND COLUMN_NAME ILIKE '%EMPLOYEE%'
;