- Created by TRAJKOVIC-ext, Nikola, last modified on Oct 14, 2023
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 29 Next »
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_Hedging_soda_ash_table.csv | ROBUSTIFY/GSHEET/HEDGING (/Processed) |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Marginal_cost.csv | ROBUSTIFY/GSHEET/MARGINAL (/Processed) |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_CO2_data.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 | FIL_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_ENS_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_Hedging_soda_ash_table.csv | Hedging | |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_Marginal_cost.csv | Marginal cost | |
GSHEET | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_CO2_data.csv | CO2 | |
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 | FIL_IND_0000_0000_F001_{yyyymmddhhmm}_0000_F_D_irm_energy_deals.csv | STG_FIL_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_hedging_soda_ash_table
Column name | Data type | Mode | Description |
|---|---|---|---|
site | STRING | NULLABLE | Site |
country | STRING | NULLABLE | Country |
region | STRING | NULLABLE | Region |
lat_long | STRING | NULLABLE | Latitude and longitude |
month | INTEGER | NULLABLE | Month |
year | INTEGER | NULLABLE | Year |
commodity | STRING | NULLABLE | Commoditiy |
direction | STRING | NULLABLE | Direction |
volume | FLOAT | NULLABLE | Volume |
unit | STRING | NULLABLE | Unit |
price | FLOAT | NULLABLE | Price |
currency | STRING | NULLABLE | Currency |
date | DATE | NULLABLE | Date |
budget_vol | FLOAT | NULLABLE | Budget volume |
budget_price | FLOAT | NULLABLE | Budget price |
proj_vol | FLOAT | NULLABLE | Projection volume |
proj_price | FLOAT | NULLABLE | Projection price |
forwards_price | FLOAT | NULLABLE | Forwards price |
real_vol | FLOAT | NULLABLE | Real volume |
max_vol_to_hedge | FLOAT | NULLABLE | Maximum volume to hedge |
potential_gain | FLOAT | NULLABLE | Potential gain |
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_marginal_cost
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_data
| 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_FIL_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_hedging_soda_ash_table
Column name | Data type | Mode | Description |
|---|---|---|---|
site | STRING | NULLABLE | Site |
country | STRING | NULLABLE | Country |
region | STRING | NULLABLE | Region |
lat_long | STRING | NULLABLE | Latitude and longitude |
month | INTEGER | NULLABLE | Month |
year | INTEGER | NULLABLE | Year |
commodity | STRING | NULLABLE | Commoditiy |
direction | STRING | NULLABLE | Direction |
volume | FLOAT | NULLABLE | Volume |
unit | STRING | NULLABLE | Unit |
price | FLOAT | NULLABLE | Price |
currency | STRING | NULLABLE | Currency |
date | DATE | NULLABLE | Date |
budget_vol | FLOAT | NULLABLE | Budget volume |
budget_price | FLOAT | NULLABLE | Budget price |
proj_vol | FLOAT | NULLABLE | Projection volume |
proj_price | FLOAT | NULLABLE | Projection price |
forwards_price | FLOAT | NULLABLE | Forwards price |
real_vol | FLOAT | NULLABLE | Real volume |
max_vol_to_hedge | FLOAT | NULLABLE | Maximum volume to hedge |
potential_gain | FLOAT | NULLABLE | Potential gain |
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_marginal_cost
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_data
| 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_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_FIL_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) | |
| FACT_energy_price_forecast | |||
| DIM_meteo_info | |||
| FACT_meteo_data | |||
| FACT_co2_data | |||
| FACT_marginal_cost_data | |||
| FACT_hedging_data | |||
| FACT_energy_deals | |||
| FACT_energy_price_hourly | |||
| FACT_energy_deals_daily |
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 | / | Energy price forecast key |
datetime_forecasted | TIMESTAMP | NULLABLE | / | Date time forecasted |
datetime_from | TIMESTAMP | NULLABLE | / | Date time from |
datetime_to | TIMESTAMP | NULLABLE | / | Date time to |
country | STRING | NULLABLE | / | 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 | / | Meteo info key |
meteo_info_business_key | INTEGER | NULLABLE | / | 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 | / | 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 | / | 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_data
| Column name | Data type | Mode | Source columns transformation | Description |
|---|---|---|---|---|
co2_data_key | STRING | NULLABLE | / | 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_marginal_cost_data
| Column name | Data type | Mode | Source columns transformation | Description |
|---|---|---|---|---|
marginal_cost_data_key | STRING | NULLABLE | / | Marginal cost 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_hedging_data
| Column name | Data type | Mode | Source columns transformation | Description |
|---|---|---|---|---|
hedging_data_key | STRING | NULLABLE | / | Hedging data key |
site | STRING | NULLABLE | / | Site |
country | STRING | NULLABLE | / | Country |
region | STRING | NULLABLE | / | Region |
lat_long | STRING | NULLABLE | / | Lat long |
month | INTEGER | NULLABLE | / | Latitude and Longitude |
year | INTEGER | NULLABLE | / | Year |
commodity | STRING | NULLABLE | / | Commodity |
direction | STRING | NULLABLE | / | Direction |
volume | FLOAT | NULLABLE | / | Volume |
unit | STRING | NULLABLE | / | Unit |
price | FLOAT | NULLABLE | / | Price |
currency | STRING | NULLABLE | / | Currency |
date | DATE | NULLABLE | / | Date |
budget_vol | FLOAT | NULLABLE | / | Budget volume |
budget_price | FLOAT | NULLABLE | / | Budget price |
proj_vol | FLOAT | NULLABLE | / | Projection volume |
proj_price | FLOAT | NULLABLE | / | Projection price |
forwards_price | FLOAT | NULLABLE | / | Forwards price |
real_vol | FLOAT | NULLABLE | / | Real volume |
max_vol_to_hedge | FLOAT | NULLABLE | / | Max volume to hedge |
potential_gain | FLOAT | NULLABLE | / | Potential gain |
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 | / | 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 | / | Master hub |
entity | STRING | NULLABLE | / | Entity |
gbu | STRING | NULLABLE | / | GBU |
site_id | STRING | NULLABLE | / | 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 | / | Date (hourly) |
elec_DE_EPEX | FLOAT | NULLABLE | / | Electricity price - Germany |
elec_FR_EPEX | FLOAT | NULLABLE | / | Electricity price - France |
elec_IT_PUN | FLOAT | NULLABLE | / | Electricity price - Italy |
elec_SP_OMEI | FLOAT | NULLABLE | / | Electricity price - Spain |
gas_DE_THE | FLOAT | NULLABLE | / | Gas price - Germany |
gas_FR_PEG | FLOAT | NULLABLE | / | Gas price - France |
gas_IT_PSV | FLOAT | NULLABLE | / | Gas price - Italy |
gas_SP_PVB | FLOAT | NULLABLE | / | Gas price - Spain |
gas_TTF | FLOAT | NULLABLE | / | 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 | / | 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 | / | Month from the date (day) |
quarter | STRING | NULLABLE | / | Quarter from the date (day) |
year | INTEGER | NULLABLE | / | 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