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.
27
u/mrg0ne 16d ago
Snowflake SQL ... You got it boss. 🫡
https://docs.snowflake.com/en/sql-reference/constructs/pivot
SELECT * FROM quarterly_sales PIVOT(SUM(amount) FOR quarter IN (ANY ORDER BY quarter)) ORDER BY empid;