Bluesky connects to Snowflake via the Snowflake Database which contains metadata like historical queries, usage metrics, organizations and accounts. Bluesky uses such metadata to analyze underlying workloads, provide granular reporting, and provide efficiency optimization suggestions to improve performance and ROI of Snowflake.
Bluesky requires read-only access to the Snowflake Database and thus, will not be able to mutate any data in it. Bluesky requires no access to the actual business data (e.g. tables, materialized view, schema) in your Snowflake instance.
💡 Please make sure you are running commands in the role ACCOUNTADMIN (refer to How to Switch To ACCOUNTADMIN Role).
💡 To run the commands, you could simply copy & paste the following commands and directly run in the Snowflake console using ACCOUNTADMIN role (refer to How to Run Commands in Snowflake UI Console).
In the following script, we will use the Snowflake admin role to create a user and a role for Bluesky with minimal privileges. The reason why we’re using the accountadmin role is because it’s the only role that can provide the Snowflake metadata which Bluesky reads to provide its analysis. The only thing that the Bluesky user will be able to do is read usage data. You will be able to track all the activity of the Bluesky user in the Snowflake UI and in the query history.
Copy and paste the following into the Snowflake Console: