How to encrypt and decrypt a column in Fabric Data Warehouse

[bexy]

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');

[Anonymous]

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.

[Anonymous]

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

[bexy]

Thanks @Anonymous , it was helpful.

[Anonymous]

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.