Permission Issues When Adding Sources
ERROR: Permission Issues When Adding Sources
You may encounter permission errors when trying to add sources in your Workspace. These issues are usually related to Snowflake role permissions, Workspace configuration, or authentication.
Description
This error occurs when your Snowflake role or Workspace settings prevent you from accessing source tables or storage mappings. It can also be caused by incorrectly configured warehouses or authentication tokens.
Possible Causes
-
Snowflake Permissions
- Missing
USAGE
permissions on the database or schema - Missing
SELECT
permissions on source tables - No access to the warehouse specified in your credentials
- Missing
-
Workspace Configuration
- User credentials not saved after testing
- Storage Mappings not configured or invalid
- Warehouse not specified in User Credentials
-
Authentication Problems
- OAuth authentication not refreshed
- Incorrectly configured integration
- Expired authentication tokens
-
Storage Location Issues
- Mappings point to databases or schemas that don’t exist
- Role lacks access to mapped storage locations
- Red/invalid storage location errors
Possible Solutions
-
Check Your Snowflake Permissions
- Ensure your role has
USAGE
on the database and schema - Confirm
SELECT
access on all source tables - Verify warehouse access for your role
- Ensure your role has
-
Update Workspace Configuration
- Go to Build Settings → Development Workspace → Edit Workspace → User Credentials
- Click Test Connection to confirm authentication
- Click Save after successful authentication
- Verify that Storage Mappings are correct and saved
-
Verify Warehouse Settings
- Make sure a warehouse is specified in your User Credentials
- Confirm the warehouse exists and is accessible by your role
-
Re-authenticate if Needed
- Disconnect and reconnect OAuth authentication
- Refresh authentication tokens
- Confirm OAuth integration is configured properly
-
Check Storage Mappings
- Ensure all mapped locations exist
- Confirm your role has access to mapped databases and schemas
- Resolve red/invalid mapping errors
Common Troubleshooting Steps
- Save changes to credentials and refresh the page.
- Check for empty schemas—red errors may indicate missing objects, not permissions.
- Confirm that all source tables and views exist in the specified location.
Next Steps
If these steps don’t resolve the issue, the problem may be specific to your Snowflake setup or security policies. Work with your Snowflake administrator to grant the required permissions.