Are you looking for a certain column in a table? Using INFORMATION_SCHEMA is one way to do this. Below is another method you can use.
SQL
SHOW COLUMNS
LIKE 'NAME'
IN SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY
;