US 12,242,641 B2
Database redaction for semi-structured and unstructured data
Yimeng Li, Bellevue, WA (US); Carl Yates Perry, Burlingame, CA (US); Raghavendran Ramakrishnan, Kirkland, WA (US); Frantisek Rolinek, Seattle, WA (US); and Yunqiao Zhang, Bellevue, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by SNOWFLAKE INC., Bozeman, MT (US)
Filed on Feb. 27, 2024, as Appl. No. 18/588,839.
Application 18/588,839 is a continuation of application No. 18/239,527, filed on Aug. 29, 2023, granted, now 11,954,224.
Application 18/239,527 is a continuation of application No. 18/304,063, filed on Apr. 20, 2023, granted, now 11,783,078, issued on Oct. 10, 2023.
Prior Publication US 2024/0354437 A1, Oct. 24, 2024
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 21/62 (2013.01); G06F 16/28 (2019.01)
CPC G06F 21/6227 (2013.01) [G06F 16/285 (2019.01); G06F 21/6254 (2013.01)] 24 Claims
OG exemplary drawing
 
1. A method comprising:
sending, by a processing device to a database, a data query accessing a column of the database, a masking policy identifying a first category of sensitive data and a second category of sensitive data; and
in response to the data query, receiving redacted data, wherein:
the first category of sensitive data is redacted from a first location of the column by a first redaction operation; and
the second category of sensitive data is redacted from a second location of the column by a second redaction operation, the first location of the column and the second location of the column occurring within a same row.