Forum Discussion
New to PowerBI Service: Snowflake integration question
Hi, we are building out out data warehouse on Snowflake, but hosted by AWS not Azure. I have not been able to get a clear answer as to 1) how can Power BI cloud integrate with Snowflake on AWS (usa regions) and does this incur an egress data charge from AWS and 2) can we use SSO via a SAML 2.0 compliant service like Google or Jumpcloud to authenticate. We do not use any Azure service.
Or should we not consider PBI as our BI tool?
Thanks in advance
Well, you can use the Snowflake connector to provide integration. Also, I believe Fabric has a the concept of linked servers and I think Snowflake is in preview. According to this: Understanding data transfer cost | Snowflake Documentation I would imagine that if you use an import mode model that you would incur data egress charges. DirectQuery is another question. I would guess that you would *not* incur data egress charges using DirectQuery because of the following statement:
Note
Snowflake does not apply data egress charges when a Snowflake client or driver retrieves query results across regions within the same cloud platform or across different cloud platforms.
But, ultimately, I would contact Snowflake to be certain.
1 Reply
Well, you can use the Snowflake connector to provide integration. Also, I believe Fabric has a the concept of linked servers and I think Snowflake is in preview. According to this: Understanding data transfer cost | Snowflake Documentation I would imagine that if you use an import mode model that you would incur data egress charges. DirectQuery is another question. I would guess that you would *not* incur data egress charges using DirectQuery because of the following statement:
Note
Snowflake does not apply data egress charges when a Snowflake client or driver retrieves query results across regions within the same cloud platform or across different cloud platforms.
But, ultimately, I would contact Snowflake to be certain.