Processing semantic model with source as Snowflake on AWS
To process the semantic model with source as Snowflake on AWS,
...
| Panel |
|---|
| panelIconId | atlassian-note |
|---|
| panelIcon | :note: |
|---|
| bgColor | #DEEBFF |
|---|
|
Note This requires AWS console access and Snowflake account administrators (users with the ACCOUNTADMIN role) or a role with the global CREATE INTEGRATION. Execute the GRANT USAGE ON STAGE <stagename> TO ROLE <role_used_on_Kyvos_SF_Connection>; query on Snowflake with the role used in Snowflake connection in Kyvos. Add the kyvos.connection.snowflake.stage = @mydb.myschema.mystage property on Snowflake connection.
NOTE: Here, mydb is the database name, myschema is the schema name, and mystage is the stage name. Update the IAM role in your bucket policy that you created while configuring a Snowflake storage integration to access Amazon S3 in the above step.
|
Processing semantic model with source as Snowflake on GCP
Below are the steps to create the stage before triggering any semantic model:
...
