Can model sql include wildcard asterisks?

[odros]

Hi! I'm trying out your tool with a Snowflake dbt project and ran into the following error:

Error processing model model.redacted_project.redacted_name, column *: Cannot find column '*' in query.

Does this mean that no models with a select * from table will work?

[wenwu35]

Hey @odros, I believe using * should work; it should extract the table schema from the catalog.json file. Could you check if the model is correctly materialized in Snowflake, and ensure that the catalog.json file successfully retrieves the correct table schema, allowing it to use the actual column name over *?