Creating a service account user
Creating a service user account in Snowflake involves setting up a user with programmatic access for tasks like automation, integration, or API-based operations.1. Log in to Snowflake
- Access your Snowflake account through the Snowflake Web Interface.
- Use your administrator credentials.
2. Navigate to the Admin Section
Go to the Admin tab or click on Account Settings from the top-right profile menu.3. Create the Service User
Use the following SQL command to create a new service user account:- service_user_name with a descriptive username (e.g., api_service_user).
- service_role with the default role you want to assign (e.g., read_only_role).
- service_warehouse with the default warehouse for the user.