Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mmossel
Employee
Employee

Connect to Snowflake from Azure vs AWS

What are the differences to consider when connecting to Snowflake running on AWS versus Azure? Because of the new enhanced connector, if I'm correct: now you DON'T need a gateway to connect from the Power BI Service to AWS, and that the gateway would need to be installed on a VM in AWS that would need to be able to connect outwards to the Power BI Service.

 

What could then be a disadvantage when choosing for AWS instead of Azure, in terms of performance and costs?

 

Thank you!

1 ACCEPTED SOLUTION
v-yuaj-msft
Community Support
Community Support

Hi @mmossel ,

 

Based on your description, please refer to the following links to learn the differences between AWS and Azure.

GCP vs AWS vs Azure | Comparison on Top Cloud Services (educba.com)

v-yuaj-msft_0-1619769332136.png

Snowflake AWS, Azure and, GCP comparison - YouTube

 

For datasets that include separate queries one that connects to an on-premises data source and the other to a cloud data source, the gateway doesn't execute the query for the cloud data source. If datasets have cloud and on-premises data sources merged or appended in a single query, the web data sources also need to be added into the gateway.

 

Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-yuaj-msft
Community Support
Community Support

Hi @mmossel ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

 

Best Regards,

Yuna

v-yuaj-msft
Community Support
Community Support

Hi @mmossel ,

 

Based on your description, please refer to the following links to learn the differences between AWS and Azure.

GCP vs AWS vs Azure | Comparison on Top Cloud Services (educba.com)

v-yuaj-msft_0-1619769332136.png

Snowflake AWS, Azure and, GCP comparison - YouTube

 

For datasets that include separate queries one that connects to an on-premises data source and the other to a cloud data source, the gateway doesn't execute the query for the cloud data source. If datasets have cloud and on-premises data sources merged or appended in a single query, the web data sources also need to be added into the gateway.

 

Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors