US 12,248,448 B1
Configuring check constraint and row violation logging using error tables
Raja Suresh Krishna Balakrishnan, Fremont, CA (US); Ganeshan Ramachandran Iyer, Redmond, WA (US); David Schultz, Piedmont, CA (US); and Jian Xu, San Jose, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Aug. 17, 2023, as Appl. No. 18/451,522.
Int. Cl. G06F 16/215 (2019.01); G06F 11/07 (2006.01); G06F 16/23 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 11/0793 (2013.01); G06F 16/2365 (2019.01); G06F 16/24545 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:
decoding a query received at a network-based database system, the query including a command to perform an operation on a base table;
retrieving an integrity constraint associated with the base table, the integrity constraint specifying a desired configuration for the base table;
performing a verification of the integrity constraint to detect erroneous data of the base table, the erroneous data violating the desired configuration;
inputting the erroneous data into an error table, the error table being configured as a dynamic table maintained as a nested object of the base table; and
generating a notification that the erroneous data is available in the error table.