---
title: Snowflake Users & Roles
description: Snowflake user generation
---

[Skip to content](https://help.mozartdata.com/docs/snowflake-users#main-content)

English

Show submenu for translations

![Mozart Data Logo - Purple (2).png\]](https://help.mozartdata.com/hs-fs/hubfs/Mozart%20Data%20Logo%20-%20Purple%20(2).png?height=30&name=Mozart%20Data%20Logo%20-%20Purple%20(2).png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to mozartdata.com](https://mozartdata.com/)

[Go to mozartdata.com](https://mozartdata.com/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.mozartdata.com/docs?hsLang=en)
2. [Core Features](https://help.mozartdata.com/docs/core-features?hsLang=en)
3. [Settings](https://help.mozartdata.com/docs/core-features?hsLang=en#settings)

# Snowflake Users & Roles

### Overview

As you begin to onboard more BI tools and data analysts to your team, it becomes apparent that each tool and user should have their own dedicated Snowflake account. This ensures that accounts are not shared across tools and users. In Mozart Data, you have the ability to create new Snowflake users for individual users and BI/external tool integrations.

![snowflake\_roles](https://help.mozartdata.com/hs-fs/hubfs/snowflake_roles.gif?width=450&height=330&name=snowflake_roles.gif)

There are three different roles that users can be assigned in Snowflake: mozart\_admin, mozart\_editor, or mozart\_viewer ([See each role and permissions here](https://help.mozartdata.com/docs/snowflake-users#snowflake-roles)). These roles determine what actions users can take within the Snowflake database, such as creating tables or editing transforms. Anyone with a Mozart Data account can generate new Snowflake accounts.

### Let's Get Started!

**To create a new Snowflake user account in Mozart Data, follow these steps:**

1\. Navigate to the Integrations page in Mozart Data.

2\. Choose Snowflake or any other BI/external tool you want to create a Snowflake user account for.

3\. Click on the 'Generate Snowflake User' option.

4\. Enter the username using the following format: company\_name + tool + role (e.g. mozartdata\_mode\_viewer).

5\. Assign a role to the user and click Save.

Remember to save the new Snowflake username and password securely, such as in a password manager like 1Password. If you forget the password and need it later, you will not be able to access it again and will have to reset the password in Snowflake.

---

### Snowflake User Roles

|   | **mozart\_admin** | **mozart\_editor** | **mozart\_viewer** |
| --- | --- | --- | --- |
| View Tables | ✅ | ✅ | ✅ |
| Run Queries | ✅ | ✅ | ✅ |
| Create Transforms | ✅ | ✅ | ❌ |
| Edit Transforms | ✅ | ✅ | ❌ |
| Delete Transforms | ✅ | ✅ | ❌ |
| Create New Snowflake Roles (in Snowflake) | ✅ | ❌ | ❌ |
| Grant Access to Schemas / Tables / Roles to Other roles or Users (in Snowflake) | ✅ | ❌ | ❌ |

- [Getting Started](https://help.mozartdata.com/docs/getting-started?hsLang=en)
- [Core Features](https://help.mozartdata.com/docs/core-features?hsLang=en#main-content)

    - [Connectors & Data Sources](https://help.mozartdata.com/docs/core-features?hsLang=en#connectors-data-sources)
    - [Transforms](https://help.mozartdata.com/docs/core-features?hsLang=en#transforms)
    - [Tables](https://help.mozartdata.com/docs/core-features?hsLang=en#tables)
    - [Integrations](https://help.mozartdata.com/docs/core-features?hsLang=en#integrations)
    - [Settings](https://help.mozartdata.com/docs/core-features?hsLang=en#settings)
- [Advanced Usage](https://help.mozartdata.com/docs/advanced-usage?hsLang=en)
- [Changelog](https://help.mozartdata.com/docs/changelog?hsLang=en)
- [Reference](https://help.mozartdata.com/docs/reference?hsLang=en)

# Mozart Data

Mozart Data Help Center

Copyright © 2026, Mozart Data