Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get data from Snowflake

Hi All,   We are trying to connec to snowflake datawarehouse and get data into Power bi for the first time. But once we entered the credentials we could able to see only the information schema.   ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

But once we entered the credentials we could able to see only the information schema. 

 

It shows that you have connected to database successfully, without any error prompt, right?

We have checked the permissions and access to other databases for the user id and we have all permission set up. 

 

But does current account have full access to this database you were attempting to connect to?

 

Besides, try to connect with a different credential to see if issue persist.

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-yulgu-msft,

     

    To answer to your first two questions, Yes  i am able to connect to the server without any issues and i have also verified that i have complete access.

     

    Another point to mention here, We are trying to connect the snowflake for the first time and setting up the access to the users as well. It would be great if you could share any way to check on snowflake end that we have granted all necessary access?

     

    I am sure that we have granted access but just want to double-check on that. 

     

    Thanks,

    Ganesan k.

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      Honestly, I am not familiar with Snowflake. Maybe you can log on Snowflake database with this account to see whether he can view all data.

       

      Regards,

      Yuliana Gu