Snowflake Tag Sync
Follow these steps to enable sync of Select Star tags to Snowflake.
First, you will need to create a custom role and give it access to create and apply tags.
-- Create tag_admin role
USE ROLE USERADMIN;
CREATE ROLE tag_admin;
GRANT ROLE tag_admin TO USER <select_star_user>;
-- Enable tag creation and assignment
USE ROLE ACCOUNTADMIN;
-- <db_name>.<schema_name> will be where Select Star
GRANT CREATE TAG ON SCHEMA <db_name>.<schema_name> TO ROLE tag_admin;
GRANT APPLY TAG ON ACCOUNT TO ROLE tag_admin;
-- Grant usage
GRANT USAGE ON DATABASE <db_name> TO ROLE tag_admin;
GRANT USAGE ON SCHEMA <db_name>.<schema_name> TO ROLE tag_admin;
To enable Snowflake Tag Sync in Select Star
- 1.Go to Settings.
- 2.Choose the Snowflake data source in the sidebar.
- 3.Click the Snowflake Tag Sync tab.
- 4.Click the Enable Tag Sync button.
Snowflake Tag Sync tab in Select Star Settings.
- 6.Enter the Database Name and Schema Name where Select Star should create Snowflake Tags.
- 7.Click Connect.
You will first see a message indicating that the Sync is in progress. Once the sync is done, we'll indicate that the tags were synced successfully.
Please note: It can take a few hours for tags to update in Snowflake's
You can disable tags at any time by clicking the Disable Tags Sync button.
Disabling tags will delete all tags created by Select Star from your Snowflake instance.
When Snowflake Tag Sync is enabled, any Tags created in Select Star will be visible in Snowflake.
Select Star tags will have
SELECT_STAR_CATEGORY(for Category) or
SELECT_STAR_STATUS(for Status) prepended in the
TAG_NAMEfield. The value of the tag is left empty.
Example: If you had a Sales Tag in Select Star created as a Category tag. The Snowflake tag created would be called
Note: Currently, you can only sync tags from Select Star to Snowflake, and not the other way around. This is to prevent the tools from overwriting each other.