Invention Grant
- Patent Title: Reverse extract, transform, load (ETL) tool
-
Application No.: US17463261Application Date: 2021-08-31
-
Publication No.: US11269913B1Publication Date: 2022-03-08
- Inventor: Russell Connor Dervay , Venkata Satyanarayana Kota , Kristen Michelle Werner
- 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/25
- IPC: G06F16/25 ; G06F8/65 ; G06F21/62 ; G06F9/54 ; G06F16/2455

Abstract:
Provided herein are systems and methods for an application connector (also referred to as a reverse extract, transform, load (ETL) connector) in a database system. For example, a method includes retrieving an application connector corresponding to an application of a plurality of available applications. The application connector includes connector configuration information and connector code. A user-defined query is detected within the connector configuration information. The user-defined query is executed to obtain a query result. The query result is based on data stored in a storage device shared by the plurality of applications. The connector code of the application connector is executed to perform an update of the application, the update based on the query result.
Information query