Questions tagged [snowflake-data-masking]
7 questions
1
vote
2 answers
How to grant non-admin users to see full login history in Snowflake
I am new to snowflake, As a DBA I got ACCOUNTADMIN access to start with. I have granted read access on information_schema.login_history and information_schema.query_history to our security application user, via a role.
The user is able to login and…
user14635059
- 11
- 1
1
vote
2 answers
How to use Dynamic Data Masking for Json objects with multiple layers and/or arrays
I was able to create a data masking policy for a json column for the top level keys with the following, but couldn't figure out to go to deeper layers in json. Anybody has done that?
CREATE OR REPLACE MASKING POLICY json_mask_test AS
(val variant)…
demircioglu
- 3,069
- 1
- 15
- 22
0
votes
1 answer
Snowflake SQL - How to represent decimal values to exponential value
I have the decimal values in my snowflake table and need to show exponential values
0.9525816643 --> 9.523E-1
0.9714426928 --> 9.714E-1
759023.356783 --> 7.59023E5
Which function I can use in snowflake to convert decimal to exponential value?
user2517214
- 25
- 2
- 7
0
votes
2 answers
Query for columns that have Data masking applied to them
I created a masking policy for PII data. I then applied it to a table like so:
CREATE TABLE EXAMPLE.EXAMPLE_TABLE
(ID INT,
LAST_NAME STRING,
PHONE_NUMBER INT);
ALTER TABLE EXAMPLE.EXAMPLE_TABLE MODIFY COLUMN LAST_NAME SET MASKING POLICY…
David Garrison
- 2,546
- 15
- 25
0
votes
1 answer
Retrieve all available masking policies for an account in snowflake
How to get all the masking policies created in a particular account in snowflake? Is there any view to see it?
show masking policies only retrieves data related to the policies and not where it is applied?
How can I get all policies and in which…
Sayantan Mandal
- 53
- 7
0
votes
2 answers
Snowflake dynamic masking masks underlying table: the derivative tables are not masked and views become empty?
I have a raw table which has a variant column of json data.
There are some normal views (not materialised view) and tables are created using the json events from the raw table.
After applied a masking policy using UDF on the variant column of the…
chenchenmomo
- 233
- 1
- 3
- 16
0
votes
1 answer
Snowflake object_construct unloading Key Order should be preserved as same. how to maintain the order not by alphabetical?
I use copy command of snowflake which is below returns a file with content json
copy into @elasticsearch/product/sf_index from (select object_construct('id',id, alpha,'alpha')from table limit 1) file_format = (type = json, COMPRESSION=NONE),…
Sundar
- 95
- 1
- 13