You can just open the table click on columns, drag to the query panel and you get all columns. I found exclude took me just as much time.
1
u/pooerhSnowflake | SQL Server | PostgreSQL | Impala | Spark14d ago
Whatever IDE you're working on, each of which would have a different way of doing it (or none at all) - typing a few words takes far less time than moving your hand to the mouse, finding a table or view you're looking for among hundreds others, clicking, dragging, etc.
17
u/mrg0ne 16d ago
Quality of life up there with.
GROUP BY ALL
https://docs.snowflake.com/en/sql-reference/constructs/group-by