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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GAPER
Helper V
Helper V

How to check my Snowflake warehouse

I am trying to connect my powerbi to snowflake query. May I know which one is my warehouse name?

 

Thanks

GAPER_0-1700477355137.png

 

1 REPLY 1
123abc
Community Champion
Community Champion

To check your Snowflake warehouse and connect Power BI to Snowflake, you can follow these steps:

1. Check Your Snowflake Warehouse:

  1. Snowflake Web Interface:

    • Log in to the Snowflake web interface.
    • On the top navigation bar, click on the "WAREHOUSES" tab.
    • You will see a list of warehouses. Identify the warehouse you want to use.
  2. Snowflake SQL:

    • If you have access to a SQL client, you can use the following SQL query to check your current warehouse:

SHOW WAREHOUSES;

 

    • This query will display information about all the warehouses, including their names and statuses.

2. Connect Power BI to Snowflake:

  1. Get Snowflake Connection Details:

    • Before connecting Power BI to Snowflake, you need to gather the following information:
      • Snowflake account name (URL)
      • Database name
      • Warehouse name
      • Snowflake username and password
  2. Power BI:

    • Open Power BI Desktop.
    • Click on "Get Data" in the Home tab.
    • Choose "Snowflake" from the list of connectors.
  3. Enter Connection Details:

    • In the Snowflake connection window, enter your Snowflake account name, database name, warehouse name, and login credentials.
    • Click "OK" to connect.
  4. Query Data:

    • Once connected, you can write SQL queries directly in Power BI or use the Power Query Editor to shape and transform your data.

Note:

  • The warehouse in Snowflake determines the amount of computing resources allocated to your queries. Choose a warehouse based on your processing needs.
  • Ensure that your Snowflake account allows connections from Power BI. Check your network policies and Snowflake user permissions.

If you encounter any issues, refer to the Snowflake documentation or contact your Snowflake administrator for assistance.

 

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

 

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.