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

[amymc]

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.

[TimoRiikonen]

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)

);

[adm_vk_fabric]

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.

[Anonymous · Accepted solution]

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!