- Patent Title: Accessing files in a database stage using a user defined function
-
Application No.: US17657548Application Date: 2022-03-31
-
Publication No.: US11550845B2Publication Date: 2023-01-10
- Inventor: Elliott Brossard , Sukruth Komarla Sukumar , Isaac Kunen , Ju-yi Kuo , Jonathan Lee Leang , Edward Ma , Schuyler James Manchester , Polita Paulus , Saurin Shah , Igor Zinkovsky
- Applicant: Snowflake Inc.
- Applicant Address: US MT Bozeman
- Assignee: Snowflake Inc.
- Current Assignee: Snowflake Inc.
- Current Assignee Address: US MT Bozeman
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/901 ; G06F16/955 ; G06F16/2455 ; G06F16/22 ; G06F16/908

Abstract:
A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF interfaces and file reference objects that can be called by other users. Upon a UDF being called, files on a stage, one or more interface objects (e.g., InputStream), and file reference objects can be implemented by execution nodes of the distributed database system. The execution nodes can implement multiple threads that are authenticated and can download file data from a staging location concurrently.
Public/Granted literature
- US20220237231A1 ACCESSING FILES IN A DATABASE STAGE USING A USER DEFINED FUNCTION Public/Granted day:2022-07-28
Information query