Data not being loaded into Snowflake Target

If table data is not being loaded into Snowflake but the table metadata still gets loaded, it may be a result of insufficient permissions on the Snowflake endpoint. If the role in the Snowflake target is not the SYSADMIN role, then the role needs to be specified in the Additional ODBC Connection Properties setting under the Advanced tab for the Snowflake endpoint. The role is set by the string: role=<Name of Role>

Reference from the following section of the user guide: https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Snowflake%20Target/snowflake_permissions.htm?