Note This requires GCP console access and Snowflake account administrators (users with the ACCOUNTADMIN role) or a role with the global CREATE INTEGRATION. Grant the USAGE privilege on the stage to the role used on Kyvos_Snowflake_Connection; query on Snowflake with the role used in Snowflake connection in Kyvos. Add the kyvos.connection.snowflake.stage = @mydb.myschema.mystage property on the Snowflake connection.
NOTE: Here, mydb is the database name, myschema is the schema name, and mystage is the stage name. If Customer Managed Key (CMK) or Bring Your Own Key (BYOK) is used in Terraform based deployment, use below command for creating stage. CREATE STAGE my_gcs_stage
STORAGE_INTEGRATION = gcs_int
URL = 'gcs://mybucket1/path1'
ENCRYPTION = (TYPE = 'GCS_SSE_KMS'); For more details, refer to Snowflake documentation.
|
