Follow these steps to enable sync of Select Star tags to Snowflake.
You have the option of syncing Tags created in Select Star back to Snowflake.
Enable Snowflake Tag Sync in Select Star
1. Create a custom Tag role in Snowflake
First, you will need to create a custom role and give it access to create tags.
use role useradmin;
create role tag_admin;
use role accountadmin;
grantcreate tag onschema<schema_name>to role tag_admin;
grantapply tag on account to role tag_admin;
You can find more detailed instructions in Snowflake's documentation here.
2. Authorize Tag Sync in Select Star
To enable Snowflake Tag Sync in Select Star, go to Settings. Click Snowflake in the sidebar, then click the Snowflake Tag Sync tab.
Click the Enable Tag Sync button.
Snowflake Tag Sync tab in Select Star Settings.
Enter the name of the role you created in step 1 and click Connect. If the role was created correctly, Select Star will be able to use this role with the credentials you added when you connected Snowflake.
You'll either see that the Tag Sync is enabled or that the Sync is in progress.
Please note: It can take a few hours for tags to update in Snowflake's tag_references view.
Snowflake Tag Sync page with a successful connection.
Select Star tags in Snowflake
When Snowflake Tag Sync is enabled, any Tags created in Select Star will be visible in Snowflake.
Select Star tags will have SELECTSTAR_C (for Category) or SELECTSTAR_S (for Status) prepended in the TAG_NAME field. The name of the tag shows in TAG_VALUE.
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.