User Name
Email
Password
Confirm password
Comment (optional)
Force user to change password on first time login
Advanced User Options

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.

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.

Enter comments that explains in plain english what this system user is intended for.

Enter the support email responsible for this user.

Click the "Force user to change password on first time login" to DISABLE this option. You already set a secure password.

Click the "Login Name" field. Copy and paste the username into this field.

Click the "Display Name" field and perform the same step. If your IT policies and standards are different, you can always change this later.

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.

Click "Create User". That's it! You now have your Snowflake user that is ready to load data into your data warehouse.

Want to learn how to apply this user and setup your Azure Data Factory Connection? View the next Scribe in this series at 

Snowflake

Learn how to create a new SystemUser in Snowflake that can be used for saving and loading data in Azure Data Factory

Create a Snowflake System User to Load data into Data Factory