Schema inference for files
    2.
    发明授权

    公开(公告)号:US11599512B1

    公开(公告)日:2023-03-07

    申请号:US17938401

    申请日:2022-10-06

    Applicant: Snowflake Inc.

    Inventor: Yucan Liu

    Abstract: Systems and methods for inferring a schema for a text file are provided. The systems and methods perform operations including: accessing a file comprising a plurality of textual records, each textual record of the plurality of textual records being associated with one or more columns of data; sampling a set of textual records from the plurality of textural records; obtaining a hierarchy comprising a plurality of levels of schema types; determining whether an individual column of the one or more columns of data corresponding to the set of textual records is successfully associated with a first level of the plurality of levels of the schema types and, in response, associating a schema type represented by the first level with the individual column of the one or more columns of data corresponding to the plurality of textual records.

    Schema inference for files
    4.
    发明授权

    公开(公告)号:US11989163B2

    公开(公告)日:2024-05-21

    申请号:US18162494

    申请日:2023-01-31

    Applicant: Snowflake Inc.

    Inventor: Yucan Liu

    CPC classification number: G06F16/212 G06F16/221 G06F16/258

    Abstract: Systems and methods for inferring a schema for a text file are provided. The systems and methods perform operations including: accessing a file comprising a plurality of textual records, each textual record of the plurality of textual records being associated with one or more columns of data; sampling a set of textual records from the plurality of textural records; obtaining a hierarchy comprising a plurality of levels of schema types; determining whether an individual column of the one or more columns of data corresponding to the set of textual records is successfully associated with a first level of the plurality of levels of the schema types and, in response, associating a schema type represented by the first level with the individual column of the one or more columns of data corresponding to the plurality of textual records.

    SCHEMA INFERENCE FOR FILES
    6.
    发明公开

    公开(公告)号:US20240119032A1

    公开(公告)日:2024-04-11

    申请号:US18162494

    申请日:2023-01-31

    Applicant: Snowflake Inc.

    Inventor: Yucan Liu

    CPC classification number: G06F16/212 G06F16/221 G06F16/258

    Abstract: Systems and methods for inferring a schema for a text file are provided. The systems and methods perform operations including: accessing a file comprising a plurality of textual records, each textual record of the plurality of textual records being associated with one or more columns of data; sampling a set of textual records from the plurality of textural records; obtaining a hierarchy comprising a plurality of levels of schema types; determining whether an individual column of the one or more columns of data corresponding to the set of textual records is successfully associated with a first level of the plurality of levels of the schema types and, in response, associating a schema type represented by the first level with the individual column of the one or more columns of data corresponding to the plurality of textual records.

    SCHEMA EVOLUTION
    7.
    发明公开
    SCHEMA EVOLUTION 审中-公开

    公开(公告)号:US20230401180A1

    公开(公告)日:2023-12-14

    申请号:US18345987

    申请日:2023-06-30

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/211

    Abstract: Techniques for schema mismatch detection and evolution are described. When data is being uploaded into a source table, schema of the data to be uploaded can be compared with the schema for the source table. If a schema mismatch is detected, the schema of the source table can be modified, and the upload can be continued without data loss.

Patent Agency Ranking