User Profile

Kevin_H

Advocate I

Joined 3 years ago

6 Posts15 LikesLikes received

View All Badges

User Widgets

Contributions

OneLake Security on Fabric Data Warehouse
Add OneLake Security on the Data Warehouse. (In addition to the Lakehouse and Mirrored Database, which are the items on which OneLake Security can be applied today.)
25 days ago Place Fabric Ideas
Data Warehouse
Fabric platform | Security
161Views
14likes
1Comment
Re: Using Column Level Security with Shortcuts
Today, one could add OneLake Security roles on the lakehouse (assuming it's a lakehouse) in the hub. When a user is accessing content in the spoke workspaces, via the shortcut, their identity can "flow" to the lakehouse in the central workspace, where OneLake Security (and its CLS) would be applied. Right? Wouldn't this solve it?
25 days ago Place Fabric Ideas
36Views
0likes
0Comments
Re: Filter and RLS on OneLake shortcuts
Today, one could add OneLake Security roles on the lakehouse (assuming it's a lakehouse) in the central workspace. When a user is accessing content in the departments' workspaces, via the shortcut, their identity can "flow" to the lakehouse in the central workspace, where OneLake Security (and its RLS) would be applied. Right? Wouldn't this solve it? _
25 days ago Place Fabric Ideas
29Views
0likes
0Comments
Re: Dataflow Gen2 Issue
Same issue here; my source is also a database, for which I need a data gateway. My destination is a lakehouse. Is this known bug specific to a dataflow that uses a gateway? Or do all Dataflows Gen2 fail to load data into a lakehouse? This recurs even with gateway version 3000.178.9 (June 2023).
3 years ago Place Service
74KViews
1like
0Comments
Re: Fabric - Database table to lakehouse Delta table - how?
Oh, I had forgotten to set a destination on the dataflow! I set it to my lakehouse. However, for now, the dataflow refresh fails, presumably because of this known bug.
3 years ago Place Service
423Views
0likes
0Comments
Fabric - Database table to lakehouse Delta table - how?
I am using Fabric preview. I can't figure out a basic use case: how do I extract a table from a database, and create it as a table in a Fabric lakehouse? I go into my Lakehouse > Get data > New Dataflow Gen2 > get data from my database (it's an on-prem PostgreSQL database, and I'm using a gateway). The dataflow gets a table. The dataflow refreshes successfully. All good. But that doesn't create a table in the lakehouse. What is the flow to get data from a database, and turn it into a Delta table in the lakehouse?! (None of the documentation seems to cover this major use case.) Thanks!
3 years ago Place Service
Need Help
461Views
0likes
1Comment

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.