Versions Compared

Key

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

...

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

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

  2. GRANT USAGE ON INTEGRATION <storage_integration_name> TO ROLE ACCOUNTADMIN;

  3. CREATE STAGE <stage_name>
    URL = 'gcs://<bucket_name>/user/engine_work/temp/'
    STORAGE_INTEGRATION = <storage_integration_name>
    FILE_FORMAT = (TYPE=<file_format_type>);                                                  

  4. 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;

  5. Add below property in Snowflake connection
    kyvos.connection.snowflake.stage = @<DB_name>.<Schema_name>.<stage_name>
    example: kyvos.connection.snowflake.stage = @automationtables.public.teststage4July

...