通过 PowerBI 访问 Snowflake 查询结果 [英] Access Snowflake query results through PowerBI

问题描述

有没有办法直接在 PowerBI 中访问雪花查询的结果，或者我需要将结果插入到表中.

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.

推荐答案

您使用 Select 语句定义视图:https://docs.snowflake.com/en/sql-reference/sql/create-view.html

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

创建[或替换][安全][递归]查看[如果不存在][ ( <column_list> ) ][复制授权][评论='<string_literal>']AS <select_statement>

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

这篇关于通过 PowerBI 访问 Snowflake 查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！