Matillion ETL Shared Job

Load Euro Foreign Exchange Reference Rates

Load Euro foreign exchange reference rates from the European Central Bank (ECB).

Load Euro Foreign Exchange Reference Rates

This shared job fetches Euro foreign exchange reference rates issued by the European Central Bank (ECB) and loads the data into a transient Snowflake database table. The rates are refreshed every day at around 16:00 CET.

The daily data is archived as a gzipped CSV. Add a retention policy to your bucket if you just want to keep the data for a fixed number of days.

Based on original work by Michael at TUI.

Parameters

ParameterDescription
S3 Bucket NameName of the S3 bucket where the data is colocated and archived
Table NameName of the transient Snowflake database table to create

Prerequisites

This shared job attempts to read and write to S3. Ensure that the EC2 instance credentials attached to your Matillion ETL instance include the privilege to do this. For more information, refer to the “IAM in AWS” section in this article on RBAC in the Cloud.

Downloads

Licensed under: Matillion Free Subscription License

Download METL-aws-sf-1.68.3-load-euro-foreign-exchange-reference-rates.melt

  • Platform: AWS
  • Target: Snowflake
  • Version: 1.68.3 or higher

Installation Instructions

How to Install a Matillion ETL Shared Job
Author: Matillion
Date Posted: Nov 16, 2023
Last Modified: Nov 16, 2023