Processing semantic model without Spark on Snowflake Data source

To process the semantic model with source as Snowflake on AWS,

• Set AWS_SECRET_KEY as user ACCESS_KEY and AWS_KEY_ID as user SECRET_KEY, in semantic model advance properties.
  -or-

• Configure a Snowflake storage integration to access Amazon S3. To do this, refer to Snowflake documentation.
  NOTE: This requires AWS console access and Snowflake account administrators (users with the ACCOUNTADMIN role) or a role with the global CREATE INTEGRATION.

  1. 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.

  2. 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.

  3. 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.