topic Re: Data Project publish into Azure Warehouse (_rsc schema problem) in Data Warehouse

Data Project publish into Azure Warehouse (_rsc schema problem)

miner182 — Sun, 01 Sep 2024 19:35:05 GMT

Hi, I am trying to publish (from Azure Data Studio) a simple project (containing only 1 table) into Warehouse in Azure Fabric. But I am getting this error:

"Deploy dacpac: Could not deploy package.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 15151, Level 16, State 1, Line 1 Cannot drop the schema '_rsc', because it does not exist or you do not have permission.
Error SQL72045: Script execution error. The executed script:
DROP SCHEMA [_rsc];"

I don't understand why Publish trying to touch this schema, since this should be some system managed schema.

The only way I was able to Publish project without this error was with un-checked publish option "Drop objects not in source". But this is not kind of practical for object deployments for my project. Tryied also other Publish Options, but nothing else helped.

Do you have any ida what is wrong or what I am doing wrong?

Thanks

Peter

Re: Data Project publish into Azure Warehouse (_rsc schema problem)

Anonymous — Mon, 02 Sep 2024 06:13:52 GMT

HI miner182,

I think these operations does not have the permissions to directly modify or delete the existing contents during publish steps. So these operations can work when you turn off the option "drop objects not in source".

In my opinion, I think these data shaping and cleaning operation can be processed on the fabric warehouse instead of directly executed in the publish steps.

Regards,

Xiaoxin Sheng

Re: Data Project publish into Azure Warehouse (_rsc schema problem)

AndyDDC — Mon, 02 Sep 2024 15:19:43 GMT

HI miner182 this issue is currently with MS as it has been raised previously. In the meantime and something that I do, is add the _rsc and queryinsights schema to your project. Easy to do with the schema compare. This then means you don't have to disable the "drop objects not in source".

Re: Data Project publish into Azure Warehouse (_rsc schema problem)

miner182 — Mon, 02 Sep 2024 21:33:01 GMT

It worked for me, thanks AndyDDC 🙂

Re: Data Project publish into Azure Warehouse (_rsc schema problem)

AndyDDC — Tue, 03 Sep 2024 10:45:38 GMT

Good to hear, I know it's not ideal but at some point this issue will be resolved by MS.