Error: Task type SnowflakeConnectorTask_NOT_AUTHORIZED Is Not Registered

Issue

While setting up a connector, the following error appears:

Setup Issue: Error while schema fetching Type: INTEGRATION_FAILURE Details: Unable to get standard config: Task type SnowflakeConnectorTask_NOT_AUTHORIZED is not registered in TaskTypeRegistry

Environment

Connectors: Snowflake

Resolution

To resolve this issue, do the following:

Grant the Fivetran user CREATE TABLE permissions on the schema, allowing our Fivetran Teleport Sync data update method to create temporary tables during syncs. Run the following command:
```
GRANT CREATE TABLE ON SCHEMA <schema_name> TO ROLE <role_name>;
```
If you receive an error in Snowflake about a missing object or an invalid operation, grant the Fivetran user USAGE permissions on the schema, allowing us to access it. Run the following command:
```
GRANT USAGE ON SCHEMA <schema_name> TO ROLE <role_name>;
```
Verify that the Fivetran user has the necessary permissions to access the required schemas and tables. Run the following command:
```
SHOW GRANTS TO USER FIVETRAN_USER;`
```
In Fivetran, test your connection again.

Cause

The error may occur due to invalid permissions or an incorrect configuration in Snowflake.