Versions Compared

Old Version 6

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 7

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Processing semantic model with source as Snowflake on GCP

Below are the steps to create the stage before triggering any semantic model:

...

CREATE STORAGE INTEGRATION <storage_integration_name>
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = 'GCS'
ENABLED = TRUE
STORAGE_ALLOWED_LOCATIONS = ('gcs://<bucket_name>')

...

GRANT USAGE ON INTEGRATION <storage_integration_name> TO ROLE ACCOUNTADMIN;

...

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

  1. Configure a Snowflake storage integration to access Google Cloud Storage.

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

To configure a Snowflake storage integration to access Google Cloud Storage, refer to the Snowflake documentation.

Ensure that before creating an external stage, as per Snowflake documentation, the URL should be:
gcs://<your bucket name>/<kyvos work directory>/temp/
For example, 's3://kyvos-qa/user/engine_work/temp/'

...

GRANT USAGE ON DATABASE <DB_name> TO ROLE ACCOUNTADMIN;
GRANT USAGE ON SCHEMA <DB_name>.<Schema_name> TO ROLE ACCOUNTADMIN;
GRANT CREATE STAGE ON SCHEMA <DB_name>.<Schema_name> TO ROLE ACCOUNTADMIN;

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

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.