Skip to main content

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
  • 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
  • Update Workspace Configuration

    1. Go to Build Settings → Development Workspace → Edit Workspace → User Credentials
    2. Click Test Connection to confirm authentication
    3. Click Save after successful authentication
    4. 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

  1. Save changes to credentials and refresh the page.
  2. Check for empty schemas—red errors may indicate missing objects, not permissions.
  3. 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.