Snowflake Inc.
Reverse extract, transform, load (ETL) tool

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 executing at a first computing node, a user-defined function (UDF) to invoke an application programming interface (API) during an API call. The API is invoked via a second computing node that is external to the first computing node. The method further includes retrieving during the API call, data stored in a storage device shared by a plurality of applications. The method further includes updating using an integration function of the API, at least one application of the plurality of applications based on the data.