topic Re: How to encrypt and decrypt a column in Fabric Data Warehouse in Data Warehouse

How to encrypt and decrypt a column in Fabric Data Warehouse

bexy — Thu, 09 May 2024 21:50:34 GMT

CREATE TABLE UserData (
UserID INT PRIMARY KEY,
UserName VARCHAR,
Password VARCHAR,
Email VARCHAR
);

INSERT INTO UserData (UserID, UserName, Password, Email)
VALUES
(1, 'User1', 'password123', 'user1@example.com'),
(2, 'User2', 'abc@123', 'user2@example.com'),
(3, 'User3', 'securepass', 'user3@example.com'),
(4, 'User4', 'p@$$w0rd', 'user4@example.com');

Re: How to encrypt and decrypt a column in Fabric Data Warehouse

Anonymous — Fri, 10 May 2024 03:46:51 GMT

Hi bexy ,

Thanks for using Fabric Community.
Unfortunately Fabric Data Warehouse doesn't currently support native encryption for specific columns within a table.

At present we only provide Dynamic Data Masking:

This feature allows you to obfuscate sensitive data like passwords while still enabling users with proper permissions to access the underlying value.

Doc to refer - Security for data warehousing - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please let me know incase of further queries.

Re: How to encrypt and decrypt a column in Fabric Data Warehouse

Anonymous — Mon, 13 May 2024 07:28:05 GMT

Hi bexy ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Re: How to encrypt and decrypt a column in Fabric Data Warehouse

bexy — Mon, 13 May 2024 09:21:11 GMT

Thanks Anonymous , it was helpful.

Re: How to encrypt and decrypt a column in Fabric Data Warehouse

Anonymous — Mon, 13 May 2024 09:42:12 GMT

Hi bexy ,

Glad to know that you got some insights over your query. Let me know incase if you have further queries.
Please continue using Fabric Community.