Find out about the reference architectures that are available to help you learn how to use OCI Functions.
Reference architectures are architectures, configurations, and best practices for deploying on Oracle Cloud Infrastructure. They are available from the Oracle Cloud Infrastructure Architecture Center.
Automate Loading Data to a Data Warehouse Using a Serverless Application
The Automate Loading Data to a Data Warehouse Using a Serverless Application reference architecture shows how to use a serverless function to automate the process of extracting data from files generated by various databases or applications and loading the data into a data warehouse for analysis.
In this architecture, the Events service is triggered when zipped CSV files are uploaded to a specific bucket in Oracle Cloud Infrastructure Object Storage. The emitted event invokes a function in OCI Functions, which extracts the data from the uploaded files and loads the data into an Oracle Autonomous Data Warehouse instance. After the data is loaded to the data warehouse, the processed CSV files are moved to a different bucket in Object Storage.