Create a Snowflake System User to Load data into Data Factory | Scribe

Create a Snowflake System User to Load data into Data Factory

  • Ryan Goodman |
  • 20 steps |
  • 2 minutes
  • SnowflakeSnowflake
1
Navigate to your Snowflake instance
2
Click "Users & Roles"
3
Click + User.
4
Expand Advanced User Options
5
Click "Advanced User Options"
6
Click the "User Name" field.
7
Type "SYSTEM_ADF_LOADING" Typically we prefix "system" to signal that this is a system user which indicates for governance that we will need to restrict and manage this different than an end user. The second part is "ADF" which is what system is accessing the data. The third part is what role are we assigning, in this case "LOADING". So we know the purpose and permissions of this user is to load data which requires fewer resources than an ETL or end user analyst.
8
Click the "Password" field. Enter and confirm a strong password. In this case you will see we are using 1Password app to generate and manage our passwords.
9
Click the "Comment (optional)" field.
10
Enter comments that explains in plain english what this system user is intended for.
11
Click the "Email" field.
12
Enter the support email responsible for this user.
13
Click the "Force user to change password on first time login" to DISABLE this option. You already set a secure password.
14
Click the "Login Name" field. Copy and paste the username into this field.
15
Click the "Display Name" field and perform the same step. If your IT policies and standards are different, you can always change this later.
16
Click "Select a role"
17
Click "Select a role" and then select "LOADING". If you have another equivalent role that is intended to just load data, you can select that role. In our case when we have a database table that will receive data from ADF, we will grant "LOADING" to that table.
18
Click "Select a warehouse"
19
Click "LOADING"
20
Click "Create User". That's it! You now have your Snowflake user that is ready to load data into your data warehouse.