Author: Matillion
Date Posted: Nov 16, 2023
Last Modified: Nov 16, 2023
Load Euro Foreign Exchange Reference Rates
Load Euro foreign exchange reference rates from the European Central Bank (ECB).
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
| Parameter | Description |
|---|---|
| S3 Bucket Name | Name of the S3 bucket where the data is colocated and archived |
| Table Name | Name 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