​

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:

CREATE USER service_user_name
PASSWORD = 'YourStrongPassword'
DEFAULT_ROLE = service_role
DEFAULT_WAREHOUSE = service_warehouse
MUST_CHANGE_PASSWORD = FALSE;

Replace:

• 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.

​

Connecting Snowflake to Fabi.ai

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data