Access Snowflake query results through PowerBI

Question

Is there a way to access the results of a snowflake query in PowerBI directly or would I need to insert the results into a table.

Answer 1

I dont have snowflake to test, but in powerbi you have under database datasource "snowflake".

Answer 2

Best option would be create view on the snowflake results query and use the view in PowerBI either in ImportMode or DirectQuery.

Answer 3

You define a View using a Select statement: https://docs.snowflake.com/en/sql-reference/sql/create-view.html

CREATE [ OR REPLACE ] [ SECURE ] [ RECURSIVE ] VIEW [ IF NOT EXISTS ] [ ( <column_list> ) ] [ COPY GRANTS ] [ COMMENT = '<string_literal>' ] AS <select_statement>

Answer 4

@jagadish: materialized views also similar to database tables ( it will occupy space)

Check temporary tables and give a try.