topic Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o in Data Warehouse

The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o

amymc — Wed, 07 Aug 2024 15:16:53 GMT

I am getting the following error: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource. when i try to create a table in warehourse. I am an admin of the workspace and have been since before creating the warehouse as i know that was the issue here. I am using a view which i have created in warehouse and another table which i have imported from a csv into fabric using dataflow gen2. i have no issue creating views only tables.

I know there were similar issues here

Thanks for the help.

Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o

Anonymous — Thu, 08 Aug 2024 05:49:42 GMT

Hi amymc ,

Please try the following steps:

Check that you have the permissions required for the particular warehouse you are trying to create a table for.
Try recreating a warehouse and then creating the table in it to see if the problem persists.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o

adm_vk_fabric — Fri, 10 Jan 2025 15:23:05 GMT

Hi Community,
I signed up for the trial today and created a new lakehouse. I have connected dataverse and f&o Table via synapse.Created view Works fine . But when i am trying to take snapshot of the views it throws me error. I try creating table via Notebook it works fine. also run pyspark script in notebook to take snapshot but fails to take, throws the below error. I'm connecting my warehouse in SQL Server Management Studio, but get the same error when trying to capture snapshot of the Views.{The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.}Looking for some guidance here.

Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o

TimoRiikonen — Mon, 20 Jan 2025 12:21:47 GMT

1) Verify that you are using SQL connection (read-write) instead of analytics connection (read-only)
or
2) Create Notebook:

%%sql

CREATE TABLE Measures (

ID BIGINT NOT NULL,

Col1 VARCHAR(255)

);

Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied o

Murtaza_Ghafoor — Tue, 17 Feb 2026 12:47:34 GMT

I am getting this error, i am an admin of the workspace and also owner of the Lakehouse,

5:33:20 PM

The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.

Msg 368, Level 14, State 1, Code line: 1

Statement ID: {FC22AC03-5D3B-4147-9462-BCE8FE1A6A2D}

Msg 24528, Level 0, State 1, Code line: 1

5:33:21 PMTotal execution time: 1 sec 639 ms