cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Warehouse: INVALID_PARAMETER_VALUE when starting

DominikBraun
New Contributor II

Hey everybody.

When creating a SQL Warehouse and trying to start it, I get the following error message:

Clusters are failing to launch. Cluster launch will be retried.
Request to create a cluster failed with an exception: INVALID_PARAMETER_VALUE: Cannot fetch secrets referred in the Spark configuration. Please check that the secrets exists and the cluster's owner has read permissions.
 
I have no idea what to do with that. What Spark configuration? Isn't that completely handled by the warehouse internally so I do not have an influence on that? What secret in meant here? I'm trying to create and run the cluster as the admin of the whole account, workspace, catalog etc.
 
Anyone any idea what to check and how to solve that?
1 ACCEPTED SOLUTION

Accepted Solutions

Ismael-K
New Contributor III
New Contributor III

One suggestion would be if you could please have the workspace admin check the Data Access Configuration properties in the Workspace Settings for any secrets that may be held which the warehouse is trying to access on start up? These data access properties can hold spark configurations that the warehouse can use. If there is a secret scope configured here, the user may need to be granted read access to it or you may also try to verify/change the warehouse owner. 

View solution in original post

2 REPLIES 2

Ismael-K
New Contributor III
New Contributor III

One suggestion would be if you could please have the workspace admin check the Data Access Configuration properties in the Workspace Settings for any secrets that may be held which the warehouse is trying to access on start up? These data access properties can hold spark configurations that the warehouse can use. If there is a secret scope configured here, the user may need to be granted read access to it or you may also try to verify/change the warehouse owner. 

That worked. There has been a strange configuration. Thank you.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!