CONFIGURING CHECK CONSTRAINT AND ROW VIOLATION LOGGING USING ERROR TABLES

    公开(公告)号:US20250061099A1

    公开(公告)日:2025-02-20

    申请号:US18451522

    申请日:2023-08-17

    Applicant: Snowflake Inc.

    Abstract: Provided herein are systems and methods for configuring integrity constraints (including a check constraint) and row violation logging using error tables. An example method includes decoding a query received at a network-based database system. The query includes a command to perform an operation on a base table. An integrity constraint associated with the base table is retrieved. The integrity constraint specifies a desired configuration for the base table. A verification of the integrity constraint is performed to detect erroneous data of the base table that violates the desired configuration. The erroneous data is input into an error table that is configured as a nested object of the base table. A notification that the erroneous data is available in the error table is generated and output.

    EFFICIENT DEDUPLICATION OF RANDOMIZED FILE PATHS

    公开(公告)号:US20240086381A1

    公开(公告)日:2024-03-14

    申请号:US18513163

    申请日:2023-11-17

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/215 G06F16/24552 G06F16/24573 G06F16/248

    Abstract: Disclosed are techniques for deduplicating files to be ingested by a database. A bloom filter may be built for each of a first set of files to be ingested into a data exchange to generate a set of bloom filters, wherein each of the set of bloom filters is built with a number of hash functions that is based on a desired false positive rate. The set of bloom filters may be stored in the metadata storage of the data exchange. In response to receiving a set of candidate files to be ingested, identifying using the set of bloom filters, candidate files from the set of candidate files that are duplicative of a file in the first set of files and pruning from the set of candidate files, each candidate file identified as being duplicative of a file in the first set of files using the set of bloom filters.

Patent Agency Ranking