- Created by TRAJKOVIC-ext, Nikola, last modified on Nov 30, 2023
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
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_ | 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_ | 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_ | 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_ | 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_ | 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_ | Meteologica Spain OBS |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Wap_solid_fuels.csv | Wap solid fuels | |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_CO2_emissions.csv | CO2 emissions | |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_open_meteo_vendohm_dataset.csv | STG_FIL_0000_0000_F001_F_D_open_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 | 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 | n_eex_421_0 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_421_1.csv | curve_n_eex_421_1 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_eex_836.csv | curve_n_eex_836 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_epex_26.csv | curve_n_epex_26 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_293.csv | curve_n_gme_293 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_gme_364.csv | curve_n_gme_364 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_859.csv | curve_n_mibgas_859 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_mibgas_861.csv | curve_n_mibgas_861 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_ometeo_870.csv | curve_n_ometeo_870 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_omie_32.csv | curve_n_omie_32 | |
Vendohm | EXT_IND_0000_0000_F001_{yyyymmddhhmm}_0000_I_D_curve_n_pegas_291.csv | curve_n_pegas_291 |
Tables
STG_FIL_0000_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly
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
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
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
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
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
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
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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)
| 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
Tables
ODS_FIL_0000_F001_I_D_france_powerprice_forecast_meteologica_total_hourly
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
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
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
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
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
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
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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)
| 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
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, 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 | 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, | 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_solid_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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
- No labels