Snowflake Connection Configuration: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 5: | Line 5: | ||
# Create a new account to Snowflake in the Snowflake site: https://www.snowflake.com/ (or use existing account). The account is created to a certain cloud and site, so consider a location that is close to the QPR ProcessAnalyzer hosting site. | # Create a new account to Snowflake in the Snowflake site: https://www.snowflake.com/ (or use existing account). The account is created to a certain cloud and site, so consider a location that is close to the QPR ProcessAnalyzer hosting site. | ||
# In '''Account''' > '''Users''', click '''User''' to create a new user. Define '''User Name''' QPRPA and define a strong password. | # In '''Account''' > '''Users''', click '''User''' button to create a new user. Define '''User Name''' QPRPA and define a strong password. | ||
# In '''Account''' > '''Roles''', click '''Role''' button to create a new role. Define '''Name''' QPRPA. | |||
# In '''Compute''' > '''Warehouses''', click '''Warehouse''' button to create a new warehouse. Define '''Name''' QPRPA, and select suitable '''Size''' for the warehouse. In the '''Advanced Warehouse Options''', check that '''Auto Resume''' and '''Auto Suspend''' are enabled. Set the '''Suspend After''' time based on your performance requirements (for example 5 minutes is a good initial value). | |||
# Select the created warehouse and in the '''Privileges''' section, select '''Privilege''' button. To '''Role''' select the QPRPA role and select '''Privileges''' select '''MONITOR''', '''OPERATE''' and '''USAGE'''. | |||
Revision as of 21:46, 27 January 2022
This page describes how to configure Snowflake and QPR ProcessAnalyzer for the Snowflake connection.
Snowflake configuration
These instructions provide an example how to configure Snowflake. The configuration can also be done differently based on needs and other usage of the same Snowflake account.
- Create a new account to Snowflake in the Snowflake site: https://www.snowflake.com/ (or use existing account). The account is created to a certain cloud and site, so consider a location that is close to the QPR ProcessAnalyzer hosting site.
- In Account > Users, click User button to create a new user. Define User Name QPRPA and define a strong password.
- In Account > Roles, click Role button to create a new role. Define Name QPRPA.
- In Compute > Warehouses, click Warehouse button to create a new warehouse. Define Name QPRPA, and select suitable Size for the warehouse. In the Advanced Warehouse Options, check that Auto Resume and Auto Suspend are enabled. Set the Suspend After time based on your performance requirements (for example 5 minutes is a good initial value).
- Select the created warehouse and in the Privileges section, select Privilege button. To Role select the QPRPA role and select Privileges select MONITOR, OPERATE and USAGE.