Forum Discussion

harrybao0901's avatar
harrybao0901
Frequent Visitor
4 months ago
Solved

Least Privilege for Pipeline item to ingest data from SQL Server to Snowflake

I am using Pipeline item in Fabric to ingest data from SQL Server to Snowflake. I already granted the role some minimal permisisons like USAGE ON WAREHOUSE, USAGE ON DATABASE, USAGE ON SCHEMA; GRANT ...
data engineering
  • harrybao0901's avatar
    harrybao0901
    3 months ago

    I found the root cause, I checked and found that one of my college set grant future ownership to role CICD, that's why new stage always goes to role CICD. Thanks for your help!!!

harrybao0901's avatar
harrybao0901
Frequent Visitor
3 months ago

I found the root cause, I checked and found that one of my college set grant future ownership to role CICD, that's why new stage always goes to role CICD. Thanks for your help!!!

v-menakakota's avatar
v-menakakota
Community Support
3 months ago

Hi harrybao0901 ,

Good to hear you were able to identify the root cause that explains the behavior you were seeing.

Appreciate you sharing the finding here, it’ll be useful for others who might run into a similar situation.

Best Regards, 
Community Support Team