- Patent Title: Accessing files in a database stage using a user defined function
-
Application No.: US17522276Application Date: 2021-11-09
-
Publication No.: US11645243B2Publication Date: 2023-05-09
- 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: G06F12/00
- IPC: G06F12/00 ; G06F16/00 ; G06F16/182 ; G06F9/54 ; G06F16/14 ; G06F16/176 ; G06F16/13

Abstract:
A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF signatures and interfaces (e.g., classes, sub-classes) that can be called by other users. Upon a UDF being called, one or more interface objects (e.g., InputStream) can be created and requests transferred to a execution node via a network channel. The execution node can implement multiple threads that are authorized and download file data from a staging location (e.g., internal stage, external stage) concurrently.
Public/Granted literature
- US20220391357A1 ACCESSING FILES IN A DATABASE STAGE USING A USER DEFINED FUNCTION Public/Granted day:2022-12-08
Information query