'Missing column specification' is a type of SQL compilation error, meaning that this error arises due to some incorrect syntax in the SQL query you're trying to process.  Specifically, the missing column specification error arises when you use Snowflake's data definition language (DDL) to create a table or create a view (materialized or not).