Skip to main content

Snowflake prerequisites

Steps​

  1. Create new user or use existing one (this user will be used for reading data to spark client)
  2. Create new role, for example as: CREATE ROLE IF NOT EXISTS FS_READ_ONLY_ROLE
  3. Grant usage to database that will be used to store feature sets for example: GRANT USAGE ON DATABASE <DB_NAME> TO ROLE <ROLE_NAME>
  4. Grant usage to schema that will be created in database GRANT USAGE ON SCHEMA <SCHEMA_NAME> TO ROLE <ROLE_NAME>
  5. Grant role to database GRANT SELECT ON FUTURE VIEWS IN DATABASE <DB_NAME> TO ROLE <ROLE_NAME>
  6. Grant role to user GRANT ROLE <ROLE_NAME> TO USER <USER_NAME>

Use created user in helm values:

  • global.storage.offline.snowFlake.readOnlyViewSparkUser
  • global.storage.offline.snowFlake.readOnlyViewSparkPassword.
Feedback