To access your Snowflake data warehouse, you’ll need to navigate to the specific URL for your Snowflake account. You can find this access link by logging into Bizible and following the steps below to navigate to the Data Warehouse information page.
In Bizible, at the top of the page, Click My Account > Settings.
On the left side menu, under Security, Click Data Warehouse.
On this page, you’ll find the link to your Snowflake data warehouse and your username.
This is a read-only account that’s available for your organization, not just an individual user. Any user within your organization that has access to Bizible can use this account to log into the Snowflake Data Warehouse reader account.
Click the link provided in the Snowflake URL, this will take you to the Snowflake login page where you’ll enter your username and password. If you don’t have your password, see the steps below to reset it.
Once logged in, Click Worksheets at the top of the page.
The BIZIBLE_ROI_V3 database objects are on the left side of the screen. Enter the Warehouse, Database, and Schema from the dropdown options at the top of the query window. There should only be one option for each. Now you are ready to execute queries inside the Snowflake query editor.
Bizible does not have access to your Snowflake login password. If you need to reset your password, Click the Reset Password button on the Data Warehouse information page, and follow the instructions. A temporary password will be immediately displayed in the UI. You will be prompted to create your own password on your next data warehouse log in.
You’ll need to enter a few pieces of information to connect your Snowflake data warehouse to a third-party tool.
Each tool has different connection requirements; it’s recommended you consult the documentation for the specific tool you’re trying to connect.
URI (always required)
Username (always required)
Password (always required)
Database Name (not always required)
Warehouse Name (not always required)