Google cloud storage

Source system	GCS file	Description
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_France_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/FRANCE (/Archive \| /Processed)
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_Italy_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/ITALY (/Archive \| /Processed)
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_Germany_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/GERMANY (/Archive \| /Processed)
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_Spain_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/SPAIN (/Archive \| /Processed)
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_Spain_ENS_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/SPAIN_ENS (/Archive \| /Processed)
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_ 0000_I_D_Spain_OBS_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	ROBUSTIFY/METEOLOGICA/SPAIN_OBS (/Archive \| /Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Wap_solid_fuels.csv	ROBUSTIFY/GSHEET/WAP_SOLID_FUELS (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_CO2_emissions.csv	ROBUSTIFY/GSHEET/CO2 (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_open_meteo_vendohm_dataset.csv	ROBUSTIFY/GSHEET/VENDOHM_METEO (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Vendohm_forwards.csv	ROBUSTIFY/GSHEET/VENDOHM_FORWARDS (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Vendohm_spot.csv	ROBUSTIFY/GSHEET/VENDOHM_SPOT (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{YYYYMMDDHHMI}_0000_F_D_irm_hubs.csv	ROBUSTIFY/GSHEET/IRM_HUBS (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_counter_parties.csv	ROBUSTIFY/GSHEET/COUNTER_PARTIES (/Processed)
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_sites_hedges.csv	ROBUSTIFY/GSHEET/SITES_HEDGES (/Processed)
IRM	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_energy_deals.csv	ROBUSTIFY/IRM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_421_0.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_421_1.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_836.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_epex_26.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_293.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_364.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_859.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_861.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_ometeo_870.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_omie_32.csv	ROBUSTIFY/VENDOHM (/Processed)
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_pegas_291.csv	ROBUSTIFY/VENDOHM (/Processed)

STG tables

Overview

--to the top ↑--

Source system	Source table/file	STG table	Description
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_France_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_france_powerprice_forecast_meteologica_total_hourly	Meteologica France
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_Italy_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_italy_powerprice_forecast_meteologica_total_hourly	Meteologica Italy
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_Germany_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_germany_powerprice_forecast_meteologica_total_hourly	Meteologica Germany
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_Spain_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_spain_powerprice_forecast_meteologica_total_hourly	Meteologica Spain
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_Spain_ENS_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_spain_ens_powerprice_forecast_meteologica_total_hourly	Meteologica Spain ENS
Meteologica FTP	FIL_IND_0000_0000_F001_{yyyymmddhhmm} _0000_I_D_Spain_OBS_PowerPrice_Forecast_Meteologica_Total_Hourly.csv	STG_FIL_0000_0000_F001_I_ D_spain_obs_powerprice_forecast_meteologica_total_hourly	Meteologica Spain OBS
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Wap_solid_fuels.csv	STG_FIL_0000_0000_F001_F_D_w ap_solid_fuels	Wap solid fuels
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_CO2_emissions.csv	STG_FIL_0000_0000_F001_F_D_co2_e missions	CO2 emissions
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_open_meteo_vendohm_dataset.csv	STG_FIL_0000_0000_F001_F_D_o pen_meteo_vendohm_dataset	Meteo metadata
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Vendohm_forwards.csv	STG_FIL_0000_0000_F001_F_D_vendohm_forwards	Vendohm forwards
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Vendohm_spot.csv	STG_FIL_0000_0000_F001_F_D_vendohm_spot	Vendohm spot
GSHEET	FIL_IND_0000_0000_F001_{YYYYMMDDHHMI}_0000_F_D_irm_hubs.csv	STG_FIL_0000_0000_F001_F_D_irm_hubs	IRM hubs
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_counter_parties.csv	STG_FIL_0000_0000_F001_F_D_irm_counter_parties	IRM counter parties
GSHEET	FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_sites_hedges.csv	STG_FIL_0000_0000_F001_F_D_irm_sites_hedges	IRM sites hedges
IRM	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_energy_deals.csv	STG_EXT_0000_0000_F001_F_D_irm_energy_deals	IRM energy deals
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_421_0.csv	STG_EXT_0000_0000_F001_I_D_curve_n_eex_421_0	n_eex_421_0
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_421_1.csv	STG_EXT_0000_0000_F001_I_D_curve_n_eex_421_1	curve_n_eex_421_1
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_836.csv	STG_EXT_0000_0000_F001_I_D_curve_n_eex_836	curve_n_eex_836
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_epex_26.csv	STG_EXT_0000_0000_F001_I_D_curve_n_epex_26	curve_n_epex_26
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_293.csv	STG_EXT_0000_0000_F001_I_D_curve_n_gme_293	curve_n_gme_293
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_364.csv	STG_EXT_0000_0000_F001_I_D_curve_n_gme_364	curve_n_gme_364
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_859.csv	STG_EXT_0000_0000_F001_I_D_curve_n_mibgas_859	curve_n_mibgas_859
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_861.csv	STG_EXT_0000_0000_F001_I_D_curve_n_mibgas_861	curve_n_mibgas_861
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_ometeo_870.csv	STG_EXT_0000_0000_F001_I_D_curve_n_ometeo_870	curve_n_ometeo_870
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_omie_32.csv	STG_EXT_0000_0000_F001_I_D_curve_n_omie_32	curve_n_omie_32
Vendohm	EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_pegas_291.csv	STG_EXT_0000_0000_F001_I_D_curve_n_pegas_291	curve_n_pegas_291

Tables

STG_FIL_0000_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_I_D_italy_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_I_D_germany_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_I_D_spain_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_I_D_spain_ens_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
ens00	FLOAT	NULLABLE	Price
. . .
ens50	FLOAT	NULLABLE	Price
top	FLOAT	NULLABLE	Price
bottom	FLOAT	NULLABLE	Price
average	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_I_D_spain_obs_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_wap_solid_fuels

--to the top ↑--

Column name	Data type	Mode	Description
date	DATE	NULLABLE	Date
week_day	STRING	NULLABLE	Week day
devnya_petcoke	FLOAT	NULLABLE	Devnya petcoke
devnya_russian_coal	FLOAT	NULLABLE	Devnya Russian coal
devnya_saf_coal	FLOAT	NULLABLE	Devnya saf coal
devnya_biomass	FLOAT	NULLABLE	Devnya biomass
dombasle_coal	FLOAT	NULLABLE	Dombasle coal
dombasle_biomass	FLOAT	NULLABLE	Dombasle biomass
rheinberg_coal	FLOAT	NULLABLE	Rheinberg coal
rheinberg_biomass	FLOAT	NULLABLE	Rheinberg biomass
torrelavega_coal	FLOAT	NULLABLE	Torrelavega coal
bernburg_anthracite	FLOAT	NULLABLE	Bernburg anthracite
devnya_anthracite_lumps	FLOAT	NULLABLE	Devnya anthracite lumps
devnya_anthracite_briquettes	FLOAT	NULLABLE	Devnya anthracite briquettes
dombasle_anthracite	FLOAT	NULLABLE	Dombasle anthracite
rheinberg_anthracite	FLOAT	NULLABLE	Rheinberg anthracite
rosignano_anthracite	FLOAT	NULLABLE	Rosignano anthracite
rosignano_metcoke	FLOAT	NULLABLE	Rosignano metcoke
torrelavega_anhracite	FLOAT	NULLABLE	Torrelavega anhracite
devnya_metcoke	FLOAT	NULLABLE	Devnya metcoke
dombasle_metcoke	FLOAT	NULLABLE	Dombasle metcoke
rheinberg_metcoke	FLOAT	NULLABLE	Rheinberg metcoke
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_co2_emissions

--to the top ↑--

Column name	Data type	Mode	Description
year	INTEGER	NULLABLE	Year
site	STRING	NULLABLE	Site
free_allocation	FLOAT	NULLABLE	Free allocation
exchange_3rd_parties	FLOAT	NULLABLE	Exchange 3rd parties
adj	FLOAT	NULLABLE	Adj
hedges	FLOAT	NULLABLE	Hedges
vol_covered	FLOAT	NULLABLE	Vol covered
emissions	FLOAT	NULLABLE	Emissions
hedge_unit_cost	FLOAT	NULLABLE	Hedge unit cost
hedge_cost	FLOAT	NULLABLE	Hedge cost
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_open_meteo_vendhom_dataset

--to the top ↑--

Column name	Data type	Mode	Description
datasetid	INTEGER	NULLABLE	Dataset ID
datasetname	STRING	NULLABLE	Dataset name
database	STRING	NULLABLE	Database
rawcurveid	INTEGER	NULLABLE	Raw curve id from Vendohm database
tablename	STRING	NULLABLE	Table name from Vendohm database
lc_group	STRING	NULLABLE	LC group
asset_class	STRING	NULLABLE	Asset class
asset_sub_class	STRING	NULLABLE	Asset sub class
asset_type	STRING	NULLABLE	Asset type
capacity_unit	STRING	NULLABLE	Capacity unit
commodity	STRING	NULLABLE	Commodity
coordinates	STRING	NULLABLE	Coordinates
curve_publishing	STRING	NULLABLE	Curve_Publishing
curve_type	STRING	NULLABLE	Curve_Type
granularity	STRING	NULLABLE	Granularity
hub	STRING	NULLABLE	Hub
hub_from	STRING	NULLABLE	Hub_From
hub_to	STRING	NULLABLE	Hub_To
issue_frequency	STRING	NULLABLE	Issue_Frequency
market	STRING	NULLABLE	Market
message_type	STRING	NULLABLE	Message_Type
model	STRING	NULLABLE	Model
object_type	STRING	NULLABLE	Object_Type
original_timezone	STRING	NULLABLE	Original timezone
owner	STRING	NULLABLE	Owner
pointconnect_contract	STRING	NULLABLE	Pointconnect contract
pointconnect_data_nature	STRING	NULLABLE	Pointconnect data nature
pointconnect_specification	STRING	NULLABLE	Pointconnect specification
ppagroups	STRING	NULLABLE	PPA groups
price_source_type	STRING	NULLABLE	Price Source Type
price_type	STRING	NULLABLE	Price type
price_unit	STRING	NULLABLE	Price unit
production_fuel_typ	STRING	NULLABLE	Production fuel type
production_type	STRING	NULLABLE	Production type
recipient	STRING	NULLABLE	Recipient
region	STRING	NULLABLE	Region
region_from	STRING	NULLABLE	Region from
region_to	STRING	NULLABLE	Region to
source_code	STRING	NULLABLE	Source code
source_name	STRING	NULLABLE	Source name
subscription_name	STRING	NULLABLE	Subscription name
tags	STRING	NULLABLE	Tags
unit	STRING	NULLABLE	Unit
usage	STRING	NULLABLE	Usage
volume_unit	STRING	NULLABLE	Volume Unit
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_vendohm_forwards

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
source_table	STRING	NULLABLE	Source table
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
name	STRING	NULLABLE	Name
commodity	STRING	NULLABLE	Commodity
contract	STRING	NULLABLE	Contract
timespan	INTEGER	NULLABLE	Time span
rolling	STRING	NULLABLE	Rolling
proprietary	STRING	NULLABLE	Proprietary
timezone	STRING	NULLABLE	Time zone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_vendohm_spot

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
source_table	STRING	NULLABLE	Source table
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
name	STRING	NULLABLE	Name
commodity	STRING	NULLABLE	Commodity
contract	STRING	NULLABLE	Contract
timespan	INTEGER	NULLABLE	Time span
proprietary	STRING	NULLABLE	Proprietary
timezone	STRING	NULLABLE	Time zone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_irm_hubs

--to the top ↑--

Column name	Data type	Mode	Description
underlying	STRING	NULLABLE	Underlying
market	STRING	NULLABLE	Market
timezone	STRING	NULLABLE	Timezone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_irm_counter_parties

--to the top ↑--

Column name	Data type	Mode	Description
folder_shortname	STRING	NULLABLE	Folder short name
folder_name	STRING	NULLABLE	Folder name
counterpart	STRING	NULLABLE	Counterpart
entity_split	STRING	NULLABLE	Entity split
gbu	STRING	NULLABLE	GBU
sites	STRING	NULLABLE	Sites
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_FIL_0000_0000_F001_F_D_irm_sites_hedges

--to the top ↑--

Column name	Data type	Mode	Description
master_counterparty	STRING	NULLABLE	Master counterparty
master_hub	STRING	NULLABLE	Master hub
folder	STRING	NULLABLE	Folder
gbu	STRING	NULLABLE	GBU
commodity	STRING	NULLABLE	Commodity
id_site	STRING	NULLABLE	Site id
comment	STRING	NULLABLE	Comment
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_EXT_0000_0000_F001_F_D_irm_energy_deals

--to the top ↑--

Column name	Data type	Mode	Description
id	STRING	NULLABLE	ID
commodity	STRING	NULLABLE	Commodity
del_type	STRING	NULLABLE	Deal type
abbreviation	STRING	NULLABLE	Abbreviation
book	STRING	NULLABLE	Book
product	STRING	NULLABLE	Product
folder	STRING	NULLABLE	Folder
trade_date	DATE	NULLABLE	Trade date
del_begin	DATE	NULLABLE	Deal begin date
del_end	DATE	NULLABLE	Deal end date
counterpart	STRING	NULLABLE	Counterpart
trader	STRING	NULLABLE	Trader
status	STRING	NULLABLE	Status
fixed_price	FLOAT	NULLABLE	Fixed price
fixed_power	FLOAT	NULLABLE	Fixed power
delivery	STRING	NULLABLE	Delivery
currency_quantity_unit	STRING	NULLABLE	Currency quantity unit
grid	STRING	NULLABLE	Grid
pod_market	STRING	NULLABLE	Pod market
del_profile	STRING	NULLABLE	Deal profile
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

STG_EXT_0000_0000_F001_I_D_curve_n_*

(curve_n_eex_421_0, curve_n_eex_421_1, curve_n_eex_836, curve_n_epex_26, curve_n_gme_293, curve_n_gme_364,
curve_n_mibgas_859, curve_n_mibgas_861, curve_n_ometeo_870, curve_n_omie_32, curve_n_pegas_291)

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
saved_date	DATETIME	NULLABLE	Saved date
published_date	DATETIME	NULLABLE	Published date
delivery_date	DATETIME	NULLABLE	Delivery date
value	FLOAT	NULLABLE	Value
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_file_name	STRING	NULLABLE	Meta column - source file name
meta_file_path	STRING	NULLABLE	Meta column - source file path
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS tables

Overview

--to the top ↑--

Source system	STG table	ODS table	Description
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_france_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly	Meteologica France
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_italy_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_italy_powerprice_forecast_meteologica_total_hourly	Meteologica Italy
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_germany_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_germany_powerprice_forecast_meteologica_total_hourly	Meteologica Germany
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_spain_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_spain_powerprice_forecast_meteologica_total_hourly	Meteologica Spain
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_spain_ens_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_spain_ens_powerprice_forecast_meteologica_total_hourly	Meteologica Spain ENS
Meteologica FTP	STG_FIL_0000_0000_F001_I_ D_spain_obs_powerprice_forecast_meteologica_total_hourly	ODS_FIL_0000_F001_I_D_spain_obs_powerprice_forecast_meteologica_total_hourly	Meteologica Spain OBS
GSHEET	STG_FIL_0000_0000_F001_F_D_w ap_solid_fuels	ODS_FIL_0000_F001_F_D_w ap_solid_fuels	Wap solid fuels
GSHEET	STG_FIL_0000_0000_F001_F_D_co2_e missions	ODS_FIL_0000_F001_F_D_co2_emissions	CO2 emissions
GSHEET	STG_FIL_0000_0000_F001_F_D_o pen_meteo_vendohm_dataset	ODS_FIL_0000_F001_F_D_o pen_meteo_vendohm_dataset	Meteo metadata
GSHEET	STG_FIL_0000_0000_F001_F_D_vendohm_forwards	ODS_FIL_0000_F001_F_D_vendohm_forwards	Vendohm forwards
GSHEET	STG_FIL_0000_0000_F001_F_D_vendohm_spot	ODS_FIL_0000_F001_F_D_vendohm_spot	Vendohm spot
GSHEET	STG_FIL_0000_0000_F001_F_D_irm_hubs	ODS_FIL_0000_F001_F_D_i rm_hubs	IRM hubs
GSHEET	STG_FIL_0000_0000_F001_F_D_i rm_counter_parties	ODS_FIL_0000_F001_F_D_i rm_counter_parties	IRM counter parties
GSHEET	STG_FIL_0000_0000_F001_F_D_i rm_sites_hedges	ODS_FIL_0000_F001_F_D_i rm_sites_hedges	IRM sites hedges
IRM	STG_EXT_0000_0000_F001_F_D_i rm_energy_deals	ODS_EXT_0000_F001_F_D_i rm_energy_deals	IRM energy deals
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_eex_421_0	ODS_EXT_0000_F001_I_D_curve_n_eex_421_0	n_eex_421_0
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_eex_421_1	ODS_EXT_0000_F001_I_D_curve_n_eex_421_1	curve_n_eex_421_1
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_eex_836	ODS_EXT_0000_F001_I_D_curve_n_eex_836	curve_n_eex_836
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_epex_26	ODS_EXT_0000_F001_I_D_curve_n_epex_26	curve_n_epex_26
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_gme_293	ODS_EXT_0000_F001_I_D_curve_n_gme_293	curve_n_gme_293
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_gme_364	ODS_EXT_0000_F001_I_D_curve_n_gme_364	curve_n_gme_364
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_mibgas_859	ODS_EXT_0000_F001_I_D_curve_n_mibgas_859	curve_n_mibgas_859
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_mibgas_861	ODS_EXT_0000_F001_I_D_curve_n_mibgas_861	curve_n_mibgas_861
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_ometeo_870	ODS_EXT_0000_F001_I_D_curve_n_ometeo_870	curve_n_ometeo_870
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_omie_32	ODS_EXT_0000_F001_I_D_curve_n_omie_32	curve_n_omie_32
Vendohm	STG_EXT_0000_0000_F001_I_D_curve_n_pegas_291	ODS_EXT_0000_F001_I_D_curve_n_pegas_291	curve_n_pegas_291

Tables

ODS_FIL_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_I_D_italy_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_I_D_germany_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_I_D_spain_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_I_D_spain_ens_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
ens00	FLOAT	NULLABLE	Price
. . .
ens50	FLOAT	NULLABLE	Price
top	FLOAT	NULLABLE	Price
bottom	FLOAT	NULLABLE	Price
average	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_I_D_spain_obs_powerprice_forecast_meteologica_total_hourly

--to the top ↑--

Column name	Data type	Mode	Description
datetime_from	TIMESTAMP	NULLABLE	Date from
utc_offset_from	STRING	NULLABLE	UTC offset
datetime_to	TIMESTAMP	NULLABLE	Date to
utc_offset_to	STRING	NULLABLE	UTC offset
price	FLOAT	NULLABLE	Price
datetime_forecasted	TIMESTAMP	NULLABLE	Date and time forecasted - generated column
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_wap_solid_fuels

--to the top ↑--

Column name	Data type	Mode	Description
date	DATE	NULLABLE	Date
week_day	STRING	NULLABLE	Week day
devnya_petcoke	FLOAT	NULLABLE	Devnya petcoke
devnya_russian_coal	FLOAT	NULLABLE	Devnya Russian coal
devnya_saf_coal	FLOAT	NULLABLE	Devnya saf coal
devnya_biomass	FLOAT	NULLABLE	Devnya biomass
dombasle_coal	FLOAT	NULLABLE	Dombasle coal
dombasle_biomass	FLOAT	NULLABLE	Dombasle biomass
rheinberg_coal	FLOAT	NULLABLE	Rheinberg coal
rheinberg_biomass	FLOAT	NULLABLE	Rheinberg biomass
torrelavega_coal	FLOAT	NULLABLE	Torrelavega coal
bernburg_anthracite	FLOAT	NULLABLE	Bernburg anthracite
devnya_anthracite_lumps	FLOAT	NULLABLE	Devnya anthracite lumps
devnya_anthracite_briquettes	FLOAT	NULLABLE	Devnya anthracite briquettes
dombasle_anthracite	FLOAT	NULLABLE	Dombasle anthracite
rheinberg_anthracite	FLOAT	NULLABLE	Rheinberg anthracite
rosignano_anthracite	FLOAT	NULLABLE	Rosignano anthracite
rosignano_metcoke	FLOAT	NULLABLE	Rosignano metcoke
torrelavega_anhracite	FLOAT	NULLABLE	Torrelavega anhracite
devnya_metcoke	FLOAT	NULLABLE	Devnya metcoke
dombasle_metcoke	FLOAT	NULLABLE	Dombasle metcoke
rheinberg_metcoke	FLOAT	NULLABLE	Rheinberg metcoke
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_co2_emissions

--to the top ↑--

Column name	Data type	Mode	Description
year	INTEGER	NULLABLE	Year
site	STRING	NULLABLE	Site
free_allocation	FLOAT	NULLABLE	Free allocation
exchange_3rd_parties	FLOAT	NULLABLE	Exchange 3rd parties
adj	FLOAT	NULLABLE	Adj
hedges	FLOAT	NULLABLE	Hedges
vol_covered	FLOAT	NULLABLE	Vol covered
emissions	FLOAT	NULLABLE	Emissions
hedge_unit_cost	FLOAT	NULLABLE	Hedge unit cost
hedge_cost	FLOAT	NULLABLE	Hedge cost
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_open_meteo_vendhom_dataset

--to the top ↑--

Column name	Data type	Mode	Description
datasetid	INTEGER	NULLABLE	Dataset ID
datasetname	STRING	NULLABLE	Dataset name
database	STRING	NULLABLE	Database
rawcurveid	INTEGER	NULLABLE	Raw curve id from Vendohm database
tablename	STRING	NULLABLE	Table name from Vendohm database
lc_group	STRING	NULLABLE	LC group
asset_class	STRING	NULLABLE	Asset class
asset_sub_class	STRING	NULLABLE	Asset sub class
asset_type	STRING	NULLABLE	Asset type
capacity_unit	STRING	NULLABLE	Capacity unit
commodity	STRING	NULLABLE	Commodity
coordinates	STRING	NULLABLE	Coordinates
curve_publishing	STRING	NULLABLE	Curve_Publishing
curve_type	STRING	NULLABLE	Curve_Type
granularity	STRING	NULLABLE	Granularity
hub	STRING	NULLABLE	Hub
hub_from	STRING	NULLABLE	Hub_From
hub_to	STRING	NULLABLE	Hub_To
issue_frequency	STRING	NULLABLE	Issue_Frequency
market	STRING	NULLABLE	Market
message_type	STRING	NULLABLE	Message_Type
model	STRING	NULLABLE	Model
object_type	STRING	NULLABLE	Object_Type
original_timezone	STRING	NULLABLE	Original timezone
owner	STRING	NULLABLE	Owner
pointconnect_contract	STRING	NULLABLE	Pointconnect contract
pointconnect_data_nature	STRING	NULLABLE	Pointconnect data nature
pointconnect_specification	STRING	NULLABLE	Pointconnect specification
ppagroups	STRING	NULLABLE	PPA groups
price_source_type	STRING	NULLABLE	Price Source Type
price_type	STRING	NULLABLE	Price type
price_unit	STRING	NULLABLE	Price unit
production_fuel_typ	STRING	NULLABLE	Production fuel type
production_type	STRING	NULLABLE	Production type
recipient	STRING	NULLABLE	Recipient
region	STRING	NULLABLE	Region
region_from	STRING	NULLABLE	Region from
region_to	STRING	NULLABLE	Region to
source_code	STRING	NULLABLE	Source code
source_name	STRING	NULLABLE	Source name
subscription_name	STRING	NULLABLE	Subscription name
tags	STRING	NULLABLE	Tags
unit	STRING	NULLABLE	Unit
usage	STRING	NULLABLE	Usage
volume_unit	STRING	NULLABLE	Volume Unit
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_vendohm_forwards

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
source_table	STRING	NULLABLE	Source table
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
name	STRING	NULLABLE	Name
commodity	STRING	NULLABLE	Commodity
contract	STRING	NULLABLE	Contract
timespan	INTEGER	NULLABLE	Time span
rolling	STRING	NULLABLE	Rolling
proprietary	STRING	NULLABLE	Proprietary
timezone	STRING	NULLABLE	Time zone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_table_name	STRING	NULLABLE	Meta column - source table name
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_ods_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_vendohm_spot

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
source_table	STRING	NULLABLE	Source table
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
name	STRING	NULLABLE	Name
commodity	STRING	NULLABLE	Commodity
contract	STRING	NULLABLE	Contract
timespan	INTEGER	NULLABLE	Time span
proprietary	STRING	NULLABLE	Proprietary
timezone	STRING	NULLABLE	Time zone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_table_name	STRING	NULLABLE	Meta column - source table name
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_ods_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_irm_hubs

--to the top ↑--

Column name	Data type	Mode	Description
underlying	STRING	NULLABLE	Underlying
market	STRING	NULLABLE	Market
timezone	STRING	NULLABLE	Timezone
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_irm_counter_parties

--to the top ↑--

Column name	Data type	Mode	Description
folder_shortname	STRING	NULLABLE	Folder short name
folder_name	STRING	NULLABLE	Folder name
counterpart	STRING	NULLABLE	Counterpart
entity_split	STRING	NULLABLE	Entity split
gbu	STRING	NULLABLE	GBU
sites	STRING	NULLABLE	Sites
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_FIL_0000_F001_F_D_irm_sites_hedges

--to the top ↑--

Column name	Data type	Mode	Description
master_counterparty	STRING	NULLABLE	Master counterparty
master_hub	STRING	NULLABLE	Master hub
folder	STRING	NULLABLE	Folder
gbu	STRING	NULLABLE	GBU
commodity	STRING	NULLABLE	Commodity
id_site	STRING	NULLABLE	Site id
comment	STRING	NULLABLE	Comment
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_EXT_0000_F001_F_D_irm_energy_deals

--to the top ↑--

Column name	Data type	Mode	Description
id	STRING	NULLABLE	ID
commodity	STRING	NULLABLE	Commodity
del_type	STRING	NULLABLE	Deal type
abbreviation	STRING	NULLABLE	Abbreviation
book	STRING	NULLABLE	Book
product	STRING	NULLABLE	Product
folder	STRING	NULLABLE	Folder
trade_date	DATE	NULLABLE	Trade date
del_begin	DATE	NULLABLE	Deal begin date
del_end	DATE	NULLABLE	Deal end date
counterpart	STRING	NULLABLE	Counterpart
trader	STRING	NULLABLE	Trader
status	STRING	NULLABLE	Status
fixed_price	FLOAT	NULLABLE	Fixed price
fixed_power	FLOAT	NULLABLE	Fixed power
delivery	STRING	NULLABLE	Delivery
currency_quantity_unit	STRING	NULLABLE	Currency quantity unit
grid	STRING	NULLABLE	Grid
pod_market	STRING	NULLABLE	Pod market
del_profile	STRING	NULLABLE	Deal profile
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

ODS_EXT_0000_F001_I_D_curve_n_*

(curve_n_eex_421_0, curve_n_eex_421_1, curve_n_eex_836, curve_n_epex_26, curve_n_gme_293, curve_n_gme_364,
curve_n_mibgas_859, curve_n_mibgas_861, curve_n_ometeo_870, curve_n_omie_32, curve_n_pegas_291)

--to the top ↑--

Column name	Data type	Mode	Description
id	INTEGER	NULLABLE	Id
raw_curve_id	INTEGER	NULLABLE	Raw curve Id
saved_date	DATETIME	NULLABLE	Saved date
published_date	DATETIME	NULLABLE	Published date
delivery_date	DATETIME	NULLABLE	Delivery date
value	FLOAT	NULLABLE	Value
meta_run_id	STRING	NULLABLE	Meta column - job run id
meta_md5_hsh	STRING	NULLABLE	Meta column - md5 hash
meta_execution_id	STRING	NULLABLE	Meta column - job execution id
meta_bucket_load_date	STRING	NULLABLE	Meta column - bucket load date
meta_business_date	TIMESTAMP	NULLABLE	Meta column - business date
meta_stg_insert_date	TIMESTAMP	NULLABLE	Meta column - insertion date
meta_source_system	STRING	NULLABLE	Meta column - source system

DM tables

Overview

--to the top ↑--

Source tables	Transformation	DM table	Description
ODS_EXT_0000_F001_I_D_curve_n_* (curve_n_eex_421_0, curve_n_eex_421_1, curve_n_eex_836, curve_n_epex_26, curve_n_gme_293, curve_n_gme_364, curve_n_mibgas_859, curve_n_mibgas_861, curve_n_omie_32, curve_n_pegas_291), DIM_energy_price_info	From Vendohm tables → lookup on DIM_energy_price_info by energy_price_info_business_key	FACT_energy_price	Contains data about current and forecasted Vendohm energy prices
ODS_FIL_0000_F001_F_D_vendohm_spot, ODS_FIL_0000_F001_F_D_vendohm_forwards	Union	DIM_energy_price_info	Contains meta data about the source tables and curves from Vendohm database. (SCD2)
ODS_FIL_0000_F001_I_D_italy_powerprice_forecast_meteologica_total_hourly, ODS_FIL_0000_F001_I_D_spain_powerprice_forecast_meteologica_total_hourly, ODS_FIL_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly, ODS_FIL_0000_F001_I_D_germany_powerprice_forecast_meteologica_total_hourly	Union	FACT_energy_price_forecast	Contains forecasted data for energy prices by country.
ODS_FIL_0000_F001_F_D_open_meteo_vendhom_dataset	/	DIM_meteo_info	Contains meta data about the meteo curves from Vendohm table (SCD2)
ODS_EXT_0000_F001_I_D_curve_n_curve_n_ometeo_870, DIM_meteo_info	From Vendohm table→ lookup on DIM_meteo_info by meteo_info_business_key	FACT_meteo_data	Contains meteo data for each site.
ODS_FIL_0000_F001_F_D_co2_emissions	/	FACT_co2_emissions	Contains data about the co2 cost
ODS_FIL_0000_F001_F_D_wap_solid_fuels	/	FACT_s olid_fuel_wap	Contains wap solid fuels data on monthly level
ODS_EXT_0000_F001_F_D_irm_energy_deals, ODS_FIL_0000_F001_F_D_irm_hubs, ODS_FIL_0000_F001_F_D_irm_counter_parties, ODS_FIL_0000_F001_F_D_irm_sites_hedges	irm_energy_deals → lookup on irm_hubs, irm_counter_parties and irm_sites_hedges for additional data.	FACT_energy_deals	Contains energy deals data (hedging data) from IRM database.
FACT_energy_price	Derived with custom rules and calculations.	FACT_energy_price_hourly	Contains data about current and forecasted Vendohm energy prices on hourly level.
FACT_energy_deals	Derived with custom rules and calculations.	FACT_energy_deals_daily	Contains energy deals data (hedging data) from IRM database on daily bases.

Tables

FACT_energy_price

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
energy_price_actual_key	STRING	NULLABLE	MD5(vendohm source table + "\|" + id + "\|" + meta_ods_insert_date)	Energy price actual key
raw_curve_id	INTEGER	NULLABLE	/	Raw curve id
saved_date	DATETIME	NULLABLE	/	Saved date
published_date	DATETIME	NULLABLE	/	Published date
delivery_date	DATETIME	NULLABLE	/	Delivery date
energy_price_info_key	STRING	NULLABLE	From the DIM_energy_price info	Energy price info key
price	FLOAT	NULLABLE	/	Price
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

DIM_energy_price_info

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
energy_price_info_key	STRING	REQUIRED	MD5(meta_source_system + "\|" + vendohm source table + "\|" + raw_curve_id + "\|" + meta_ods_insert_date)	Energy price info key
energy_price_info_business_key	STRING	NULLABLE	vendohm source table + "\|" + raw_curve_id	Energy price info business key
name	STRING	NULLABLE	/	Name
country	STRING	NULLABLE	Derived from the name by two letter country code	Country
commodity	STRING	NULLABLE	/	Commodity
contract	STRING	NULLABLE	/	Contract
timespan	INTEGER	NULLABLE	/	Time span
rolling	STRING	NULLABLE	/	Rolling
type	STRING	NULLABLE	Derived from the source (Spot or Forwards)	Type
proprietary	STRING	NULLABLE	/	Proprietary
common__name	STRING	NULLABLE	Derived from the commodity and name	Common name
timezone	STRING	NULLABLE	/	Time zone
start_date	TIMESTAMP	NULLABLE	/	Start date
end_date	TIMESTAMP	NULLABLE	/	End date
current_flag	BOOLEAN	NULLABLE	/	Current flag
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
updated_date	TIMESTAMP	NULLABLE	/	Updated date
delete_flag	BOOLEAN	NULLABLE	/	Delete flag
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_energy_price_forecast

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
energy_price_forecast_key	STRING	NULLABLE	MD5(datetime_forecasted+ "\|" + country)	Energy price forecast key
datetime_forecasted	TIMESTAMP	NULLABLE	Last forecasted date by country	Date time forecasted
datetime_from	TIMESTAMP	NULLABLE	/	Date time from
datetime_to	TIMESTAMP	NULLABLE	/	Date time to
country	STRING	NULLABLE	Derived basod on the ODS table by country	Country
price	FLOAT	NULLABLE	/	Price
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

DIM_meteo_info

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
meteo_info_key	STRING	NULLABLE	MD5(meta_source_system + "\|" + rawcurveid + "\|" + meta_ods_insert_date)	Meteo info key
meteo_info_business_key	INTEGER	NULLABLE	rawcurveid	Meteo info business key
name	STRING	NULLABLE	/	Name
country	STRING	NULLABLE	/	Country
database_name	STRING	NULLABLE	/	Database name
lc_group	STRING	NULLABLE	/	Lc group
asset_class	STRING	NULLABLE	/	Asset class
asset_sub_class	STRING	NULLABLE	/	Asset sub class
asset_type	STRING	NULLABLE	/	Asset type
capacity_unit	STRING	NULLABLE	/	Capacity unit
commodity	STRING	NULLABLE	/	Commodity
curve_publishing	STRING	NULLABLE	/	Curve publishing
curve_type	STRING	NULLABLE	/	Curve type
hub	STRING	NULLABLE	/	Hub
market	STRING	NULLABLE	/	Market
object_type	STRING	NULLABLE	/	Object type
owner	STRING	NULLABLE	/	Owner
region	STRING	NULLABLE	/	Region
unit	STRING	NULLABLE	/	Unit
volume_unit	STRING	NULLABLE	/	Volume unit
start_date	TIMESTAMP	NULLABLE	/	Start date
end_date	TIMESTAMP	NULLABLE	/	End date
current_flag	BOOLEAN	NULLABLE	/	Current flag
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
updated_date	TIMESTAMP	NULLABLE	/	Updated date
delete_flag	BOOLEAN	NULLABLE	/	Delete flag
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_meteo_data

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
meteo_data_key	STRING	NULLABLE	MD5(id + "\|" + meta_ods_insert_date)	Meteo data key
raw_curve_id	INTEGER	NULLABLE	/	Raw curve id
saved_date	DATETIME	NULLABLE	/	Saved date
published_date	DATETIME	NULLABLE	/	Published date
delivery_date	DATETIME	NULLABLE	/	Delivery date
meteo_info_key	STRING	NULLABLE	From DIM_Meteo_info	Meteo info key
meteo_value	FLOAT	NULLABLE	/	Meteo value
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_co2_emissions

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
co2_data_key	STRING	NULLABLE	MD5(year + "\|" + site)	CO2 data key
year	INTEGER	NULLABLE	/	Year
site	STRING	NULLABLE	/	Site
free_allocation	FLOAT	NULLABLE	/	Free allocation
exchange_3rd_parties	FLOAT	NULLABLE	/	Exchange 3rd parties
adj	FLOAT	NULLABLE	/	Adjustment
hedges	FLOAT	NULLABLE	/	Hedges
vol_covered	FLOAT	NULLABLE	/	Vol covered
emissions	FLOAT	NULLABLE	/	Emissions
hegde_unit_cost	FLOAT	NULLABLE	/	Hedge unit cost
hedge_cost	FLOAT	NULLABLE	/	Hedge cost
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_solid_fuel_wap

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
solid_fuel_wap_key	STRING	NULLABLE	MD5(date)	Solid fuel wap data key
date	DATE	NULLABLE	/	Date
week_day	STRING	NULLABLE	/	Week day
devnya_petcoke	FLOAT	NULLABLE	/	Devnya petcoke
devnya_russian_coal	FLOAT	NULLABLE	/	Devnya russian coal
devnya_saf_coal	FLOAT	NULLABLE	/	Devnya saf coal
devnya_biomass	FLOAT	NULLABLE	/	Devnya biomass
dombasle_coal	FLOAT	NULLABLE	/	Dombasle coal
dombasle_biomass	FLOAT	NULLABLE	/	Dombasle biomass
rheinberg_coal	FLOAT	NULLABLE	/	Rheinberg coal
rheinberg_biomass	FLOAT	NULLABLE	/	Rheinberg biomass
torrelavega_coal	FLOAT	NULLABLE	/	Torrelavega coal
bernburg_anthracite	FLOAT	NULLABLE	/	Bernburg anthracite
devnya_anthracite_lumps	FLOAT	NULLABLE	/	Devnya anthracite lumps
devnya_anthracite_briquettes	FLOAT	NULLABLE	/	Devnya anthracite briquettes
dombasle_anthracite	FLOAT	NULLABLE	/	Dombasle anthtracite
rheinberg_anthracite	FLOAT	NULLABLE	/	Rheinberg antrhracite
rosignano_anthracite	FLOAT	NULLABLE	/	Rosignano anthracite
rosignano_metcoke	FLOAT	NULLABLE	/	Rosignano metcoke
torrelavega_anhracite	FLOAT	NULLABLE	/	Torrelavega anhracite
devnya_metcoke	FLOAT	NULLABLE	/	Devnya metcoke
dombasle_metcoke	FLOAT	NULLABLE	/	Dombasle metcoke
rheinberg_metcoke	FLOAT	NULLABLE	/	Rheinberg metcoke
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_energy_deals

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
energy_deals_data_key	STRING	NULLABLE	MD5(id)	Unique key
id	STRING	NULLABLE	/	Deal ID
commodity	STRING	NULLABLE	/	Commodity
del_type	STRING	NULLABLE	/	Deal type
abbreviation	STRING	NULLABLE	/	Abbreviation
book	STRING	NULLABLE	/	Book
product	STRING	NULLABLE	/	Product
folder	STRING	NULLABLE	/	Folder
trade_date	DATE	NULLABLE	/	Trade date
del_begin	DATE	NULLABLE	/	Deal begin date
del_end	DATE	NULLABLE	/	Deal end date
counterpart	STRING	NULLABLE	/	Counterpart
trader	STRING	NULLABLE	/	Trader
status	STRING	NULLABLE	/	Status
fixed_price	FLOAT	NULLABLE	/	Fixed price
fixed_power	FLOAT	NULLABLE	/	Fixed power
delivery	STRING	NULLABLE	/	Delivery
currency_quantity_unit	STRING	NULLABLE	/	Currency queantity unit
grid	STRING	NULLABLE	/	Grid
pod_market	STRING	NULLABLE	/	Pod market
del_profile	STRING	NULLABLE	/	Deal profile
master_hub	STRING	NULLABLE	From sites hedges, lookup on hubs by market and lookup on counter parties by counterpart, market, folder and gbu	Master hub
entity	STRING	NULLABLE	Lookup on counter parties by folder and counter part	Entity
gbu	STRING	NULLABLE	From sites hedges, lookup on hubs by market and lookup on counter parties by counterpart, market, folder and gbu	GBU
site_id	STRING	NULLABLE	From sites hedges, lookup on hubs by market and lookup on counter parties by counterpart, market, folder and gbu	Site id
meta_run_id	STRING	NULLABLE	/	Meta column - job run id
meta_execution_id	STRING	NULLABLE	/	Meta column - job execution id
inserted_date	TIMESTAMP	NULLABLE	/	Insertion date
meta_source_system	STRING	NULLABLE	/	Meta column - source system

FACT_energy_price_hourly

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
date	TIMESTAMP	NULLABLE	Split from energy price delivery date (first and last)	Date (hourly)
elec_DE_EPEX	FLOAT	NULLABLE	Pivot from energy price common name	Electricity price - Germany
elec_FR_EPEX	FLOAT	NULLABLE	Pivot from energy price common name	Electricity price - France
elec_IT_PUN	FLOAT	NULLABLE	Pivot from energy price common name	Electricity price - Italy
elec_SP_OMEI	FLOAT	NULLABLE	Pivot from energy price common name	Electricity price - Spain
gas_DE_THE	FLOAT	NULLABLE	Pivot from energy price common name	Gas price - Germany
gas_FR_PEG	FLOAT	NULLABLE	Pivot from energy price common name	Gas price - France
gas_IT_PSV	FLOAT	NULLABLE	Pivot from energy price common name	Gas price - Italy
gas_SP_PVB	FLOAT	NULLABLE	Pivot from energy price common name	Gas price - Spain
gas_TTF	FLOAT	NULLABLE	Pivot from energy price common name	Gas price - TTF
inserted_date	TIMESTAMP	NULLABLE	/	Date of the transformation

FACT_energy_deals_daily

--to the top ↑--

Column name	Data type	Mode	Source columns transformation	Description
deal_id	STRING	NULLABLE	/	Deal ID
day	DATE	NULLABLE	Split from energy deal begin and end date by day	Day
counterpart	STRING	NULLABLE	/	Counterpart
master_hub	STRING	NULLABLE	/	Master hub
folder	STRING	NULLABLE	/	Folder
deal_type	STRING	NULLABLE	/	Deal type
volume	FLOAT	NULLABLE	/	Volume
volume_unit	STRING	NULLABLE	/	Volume unit
unit_price	FLOAT	NULLABLE	/	Unit price
amount	FLOAT	NULLABLE	/	Amount
delivery	STRING	NULLABLE	/	Delivery
book	STRING	NULLABLE	/	Book
entity	STRING	NULLABLE	/	Entity
gbu	STRING	NULLABLE	/	GBU
commodity	STRING	NULLABLE	/	Commodity
site_id	STRING	NULLABLE	/	Site ID
month	INTEGER	NULLABLE	From Day	Month from the date (day)
quarter	STRING	NULLABLE	From Day	Quarter from the date (day)
year	INTEGER	NULLABLE	From Day	Year from the date (day)
inserted_date	TIMESTAMP	NULLABLE	/	Date of the transformation

Responsible & contact points:

Alessandro Mainardi - Project Owner
Simon Bourguignon - Delivery Manager
Alba Carrero/ Gaetan Frenoy - Product Owner
Rui Ferraz - Project Manager