Start a new topic

How to Specify Role in DBVZ?

I was able to connect to our Snowflake database using Python, but have trouble doing it in DBVZ. The commands I entered in Python that lets me see the full database is below, but I have trouble finding the place in DBVZ to enter that.



image


I was able to connect to our database in DBVZ, but cannot see the other DBs that Python sees. Any idea where I can specify role in DBVZ?


image

1 Comment

Hi Jerry,


You can specify the USE ROLE statements as a Connection Hook:


http://confluence.dbvis.com/display/UG95/Executing+SQL+at+Connect+and+Disconnect


The USE DATABASE statement shouldn't be needed because DbVisualizer switches between databases (catalogs) internally based on e.g. the selected database in an SQL Commander tab or the position of an object in the tree.


Best Regards,

Hans

Login or Signup to post a comment