Questions tagged [data-masking]
Data masking is a method of protecting or hiding data with place-holder or random characters, such as the mask used on a password entry field.
data-masking
205
questions
0
votes
0
answers
25
views
Masking Policies & dynamic tables in snowflake
I'm working with Dynamic Tables in Snowflake and trying to apply masking policies to hide sensitive data. However, when I create the dynamic table, I get the following error:
The masking policies are ...
0
votes
0
answers
79
views
Different ways to dynamically make a new column in dplyr based on a variable
In practicing with the left hand side (LHS) declaration of column names in a non-standard evaluation context (a 'quasiquotation' context in tidy evaluation) I discovered a few things that are possible ...
4
votes
0
answers
104
views
Masking Data of type Date doesn't work with Debezium SQL Server Source Connector
I'm trying to mask the "c_birthday" column in table "staff" with data type 'DATE' and "quantity" column of type 'BIGINT' in table "orders" of SQL Server. When ...
0
votes
2
answers
48
views
Generating filter conditions for dbplyr from dataframe
I have a table that I query in a remote database that I want to create a subset of. This subset is defined by a local dataframe that contains all valid ranges for a column in that data and all valid ...
0
votes
0
answers
25
views
What is Oracle equivalent data masking logic for SQL Server's "FUNCTION = 'default()'"
In Microsoft SQL Server, we write below ALTER statement to mask a particular column:
ALTER TABLE [Table_Name]
ALTER COLUMN YEAR_CODE ADD MASKED WITH (FUNCTION = 'default()');
Currently I am working ...
0
votes
0
answers
22
views
How to blind data in data warehouse when sending from preanonymized layer to anonymized layer while keeping referential integrity of all key columns
Have to blind PII data before loading the data to anonymized layer such that it can't be traced back but also need to maintain the referential integrity between all the tables across all key columns. ...
0
votes
0
answers
79
views
MaxScale - Mask every column in all tables of a DataBase and specify which not
What I am looking for is to mask all the columns (and new columns that could be added in the future to the tables in my DB).
So for that I want to know if there is a way to mask everything and specify ...
0
votes
0
answers
23
views
Masking in power BI
In my power Bi dashboard I need to mask the data based on user who logs in,
Can this be done in dashboard level by calling oracle user defined function?
If I use a flag in oracle DB view itself can ...
0
votes
1
answer
78
views
Data masking and when I need to use the Pick function
I am currently working through R for data science and I am confused as to when you use the pick function to deal with data masking.
For example why does this work?
grouped_mean <- function(df, ...
0
votes
2
answers
421
views
Data Masking: Proper way to update masked data?
There are some data need be mask first before transfer to frontend for display, for example phone number 14012345678 will displayed as 1401*****78 on the page.
The point here is never transfer ...
2
votes
1
answer
166
views
Seemingly random non ascii characters in response body when using APISIX plugin to rewrite response
I am trying to create a data-mask/redact plugin for APISIX in Lua. I have tried writing a custom plugin based on the following article and I have also tried using the out-of-the-box plugin response-...
0
votes
1
answer
196
views
Masking access token by regex pattern match and replace in java
I'm trying to mask an access token with stars. The response payload is converted to a string. I need to match the token pattern with the string and replace the token value with stars.
{"...
0
votes
0
answers
172
views
Issues with masking in snowflake
We have set a normal masking policy on few columns based on role. If my role can view the data, those columns data will be visible otherwise data is masked for all other roles. It was working fine ...
1
vote
3
answers
462
views
How to create a custom masking rule to de-identify or obscure data with DLP and BigQuery?
As per (Link), it's possible to mask sensitive data by partially o fully replacing characteres with a symbol (De-identifying sensitive data) using the DLP API in GCP. I didn't find any glue to ...
0
votes
1
answer
89
views
Use of PatternLayout class's format(LoggingEvent event) method from a newly created Thread to execute custom log masking logic independently
Unable to call PatternLayout class's format(LoggingEvent event) method from a newly created Thread to execute custom log masking logic independently without putting any impact on the actual ...