Creating a Snowflake User
This tutorial you will create a Snowflake system user to load data into Data Factory. When configuring Azure Data Factory to connect to Snowflake, it is recommended to create a dedicated Snowflake system user that has the necessary privileges to perform the required data integration tasks. This provides better security and control over data access, as it allows you to limit the user’s permissions to only what is required for the specific data integration tasks. Additionally, it is important to whitelist the user’s IP address and limit access to Azure Data Factory, especially when moving to production use cases, to ensure that the data is only accessed and manipulated by authorized personnel and processes.
When you create a system user and want to use basic authentication (username/password), you need to define the user as a “SYSTEM” user to disable multi-factor authentication. To do so, you can update the user type.
alter user <your username> set type = service;Next Step for Using Snowflake with ADF
Once you have your user created, you are not ready to create your Snowflake Connection in Azure Data Factory
More reading on user management and security: Snowflake User Management
