SQL warehouse launch fails to start with "PERMISSION_DENIED"

Ensure the necessary permissions are provided to the SQL warehouse owner

Written by rohit.menon

Last published at: January 30th, 2024

Problem

The SQL warehouse launch fails to start with a PERMISSION_DENIED: You are not authorized to create clusters error.

Cause

This error can be attributed to the SQL warehouse owner not having the Allow unrestricted cluster creation permission. 

Solution

To resolve this issue, grant the Allow unrestricted cluster creation permission to the SQL warehouse owner. For more details on how to grant the permission, refer to:

  • Configure cluster creation entitlement (AWS | Azure | GCP)