topic Re: SQL Serverless Endpoint failing to start with Instance Profile in Data Engineering

SQL Serverless Endpoint failing to start with Instance Profile

mortenhaga — Wed, 29 Jun 2022 08:35:01 GMT

Hi all

Super stoked about the PP of SQL Serverless, but it does seem that the instance profile Im using doesnt have the required trust relationship for it to work with the Sererless Endpoint. Altough on "classic" mode it works fine.

Does Serverless require some special setup on the instance profile or what kind of required trusted relationship does it need to work? Im on AWS.

Re: SQL Serverless Endpoint failing to start with Instance Profile

ron_defreitas — Wed, 29 Jun 2022 19:06:22 GMT

It does indeed require a special trust relationship between the AWS account owned by Databricks and your own.

See https://docs.databricks.com/sql/admin/serverless.html#step-3-confirm-or-set-up-an-aws-instance-profile-to-use-with-your-serverless-sql-warehouses

Re: SQL Serverless Endpoint failing to start with Instance Profile

mortenhaga — Thu, 30 Jun 2022 07:21:16 GMT

How could I miss that!? lol. thanks!

Re: SQL Serverless Endpoint failing to start with Instance Profile

Chow522 — Fri, 01 Jul 2022 06:12:51 GMT

https://docs.databricks.com/sql/admin/sql-endpoints.html MyFordBenefits Login

Re: SQL Serverless Endpoint failing to start with Instance Profile

Anonymous — Tue, 05 Jul 2022 11:23:16 GMT

Thank you for sharing your valuable solution, it's work properly.

mymilestonecard