topic Re: CREATE EXTERNAL LOCATION read only through SQL in Administration & Architecture

CREATE EXTERNAL LOCATION read only through SQL

barendlinders — Thu, 09 Jan 2025 13:02:53 GMT

Hello,

I have set up a storage credential with READ ONLY access to my Azure storage account (landing-zone). I want to create an EXTERNAL LOCATION using SQL, set the EXTERNAL LOCATION to read only and use the read-only storage credential I made.

I cannot find any documentation on the SQL version where I can specify the Advanced Options that are available through the UI. Is this a simple case of mismatch between UI (api) and SQL?

If I simply run the

CREATE EXTERNAL LOCATION IF NOT EXISTS with said storage credential I get the following error:

```

PERMISSION_DENIED: User cannot create or write to external locations or tables using a read-only storage credential read_storage

```

Re: CREATE EXTERNAL LOCATION read only through SQL

Walter_C — Thu, 09 Jan 2025 13:06:58 GMT

It seems that this option is only available via UI or API https://docs.databricks.com/api/workspace/externallocations/create

Re: CREATE EXTERNAL LOCATION read only through SQL

barendlinders — Thu, 09 Jan 2025 14:11:04 GMT

Thanks for clarifying @Walter_C !

Re: CREATE EXTERNAL LOCATION read only through SQL

Walter_C — Fri, 10 Jan 2025 14:08:04 GMT

Sure, happy to help, let me know in case you need any other assistance.