| Project Name | Project ID | BD&A Owner | Business Contact | Billing Account | Description | Status | Category | GBQ Data source | Dominique Owner | SBS-IS-Appli-Techno-BD-A-All@solvay.com as Editor | admin.revevol@solvay.com + Dawn Lai as Owner | Access from external removed after project | Rehosting request to infra | Organisation | |
|---|
| Analytics-Spinetta-Polymers | analytics-spinetta-gcp-prod | ??? | ??? | revevol.eu | ??? | ??? | ??? | dlk_spinetta_sas
- v_spp_sas_sap
ods
- spp_picasso_forecast
- spp_salesforce_actual_vs_budget
- spp_sap_Z1V_LIST_ORDER
spp_spinetta
- spp_picasso_forecast
- spp_sap
- spp_sf_account
- spp_sf_product
- spp_sf_report
- spp_sf_sales | OK 21/08/2018 | OK 21/08/2018 | OK 21/08/2018 revevol KO Dawn | ??? | ??? | ??? | ??? |
| INV-LINK-TOOL | inv-link-tool | ??? | ??? | My Billing Account | ??? | ??? | ??? | No GBQ | KO | KO | KO | ??? | ??? | ??? | ??? |
| MES Consolidation GCP Sandbox | mes-consolidation-gcp-sandbox | ??? | ??? | revevol.eu | ??? | ??? | ??? | Table non accessible par moi DVE, mais uniquement les datasets "does not have bigquery.tables.list " GBU_SA | OK 21/08/2018 | KO | OK 21/08/2018 revevol KO Dawn | ??? | ??? | ??? | ??? |
| solvay-data-catalog-prod | solvay-data-catalog-prod | ??? | ??? | PC2354 - Solvay - Data gathering & analysis | ??? | ??? | ??? | acc_business_chemistry
- ods_acc_business_chemistry_201805
- ods_acc_business_chemistry_201806
- ods_acc_business_chemistry_201807
- ods_acc_business_chemistry_201808
- staging_acc_business_chemistry
acc_global_chemical_industry_production_index
- ods_acc_global_chemical_industry_production_index_201805
- ods_acc_global_chemical_industry_production_index_201806
- ods_acc_global_chemical_industry_production_index_201807
- ods_acc_global_chemical_industry_production_index_201808
- staging_acc_global_chemical_industry_production_index
acc_global_macroeconomic_indicators
- ods_acc_global_macroeconomic_indicators_201805
- ods_acc_global_macroeconomic_indicators_201806
- ods_acc_global_macroeconomic_indicators_201807
- ods_acc_global_macroeconomic_indicators_201808
- staging_acc_global_macroeconomic_indicators
acc_survey_economic_forecasters
- ods_acc_survey_economic_forecasters_201805
- ods_acc_survey_economic_forecasters_201806
- ods_acc_survey_economic_forecasters_201807
- ods_acc_survey_economic_forecasters_201808
- staging_acc_survey_economic_forecasters
bloomberg_commodities
- ods_bloomberg_commodities_201805
- ods_bloomberg_commodities_201806
- ods_bloomberg_commodities_201807
- ods_bloomberg_commodities_201808
- staging_bloomberg_commodities
bloomberg_currencies
- ods_bloomberg_currencies_201805
- ods_bloomberg_currencies_201806
- ods_bloomberg_currencies_201807
- ods_bloomberg_currencies_201808
- staging_bloomberg_currencies
bloomberg_debts
- ods_bloomberg_debts_201805
- ods_bloomberg_debts_201806
- ods_bloomberg_debts_201807
- ods_bloomberg_debts_201808
- staging_bloomberg_debts
bloomberg_interest_rates
- ods_bloomberg_interest_rates_201805
- ods_bloomberg_interest_rates_201806
- ods_bloomberg_interest_rates_201807
- ods_bloomberg_interest_rates_201808
- staging_bloomberg_interest_rates
bloomberg_money_supply
- ods_bloomberg_money_supply_201805
- ods_bloomberg_money_supply_201806
- ods_bloomberg_money_supply_201807
- ods_bloomberg_money_supply_201808
- staging_bloomberg_money_supply
bloomberg_others
- ods_bloomberg_others_201805
- ods_bloomberg_others_201806
- ods_bloomberg_others_201807
- ods_bloomberg_others_201808
- staging_bloomberg_others
bloomberg_pmi
- ods_bloomberg_pmi_201805
- ods_bloomberg_pmi_201806
- ods_bloomberg_pmi_201807
- ods_bloomberg_pmi_201808
- staging_bloomberg_pmi
bloomberg_stock_exchange
- ods_bloomberg_stock_exchange_201805
- ods_bloomberg_stock_exchange_201806
- ods_bloomberg_stock_exchange_201807
- ods_bloomberg_stock_exchange_201808
- staging_bloomberg_stock_exchange
bloomberg_trade_balance
- ods_bloomberg_trade_balance_201805
- ods_bloomberg_trade_balance_201806
- ods_bloomberg_trade_balance_201807
- ods_bloomberg_trade_balance_201808
- staging_bloomberg_trade_balance
eiu_macroeconomic_databank
- ods_eiu_macroeconomic_databank_201805
- ods_eiu_macroeconomic_databank_201806
- ods_eiu_macroeconomic_databank_201807
- ods_eiu_macroeconomic_databank_201808
- staging_eiu_macroeconomic_databank
eurostat_business_climate_indicator
- ods_eurostat_business_climate_indicator_201805
- ods_eurostat_business_climate_indicator_201806
- ods_eurostat_business_climate_indicator_201807
- ods_eurostat_business_climate_indicator_201808
- staging_eurostat_business_climate_indicator
eurostat_construction
- ods_eurostat_construction_201805
- ods_eurostat_construction_201806
- ods_eurostat_construction_201807
- ods_eurostat_construction_201808
- staging_eurostat_construction
eurostat_consumers
- ods_eurostat_consumers_201805
- ods_eurostat_consumers_201806
- ods_eurostat_consumers_201807
- ods_eurostat_consumers_201808
- staging_eurostat_consumers
eurostat_energy
- ods_eurostat_energy_201805
- ods_eurostat_energy_201806
- ods_eurostat_energy_201807
- ods_eurostat_energy_201808
- staging_eurostat_energy
eurostat_industry
- ods_eurostat_industry_201805
- ods_eurostat_industry_201806
- ods_eurostat_industry_201807
- ods_eurostat_industry_201808
- staging_eurostat_industry
eurostat_production_in_construction
- ods_eurostat_production_in_construction_201805
- ods_eurostat_production_in_construction_201806
- ods_eurostat_production_in_construction_201807
- ods_eurostat_production_in_construction_201808
- staging_eurostat_production_in_construction
eurostat_production_in_industry
- ods_eurostat_production_in_industry_201805
- ods_eurostat_production_in_industry_201806
- ods_eurostat_production_in_industry_201807
- ods_eurostat_production_in_industry_201808
- staging_eurostat_production_in_industry
eurostat_services
- ods_eurostat_services_201805
- ods_eurostat_services_201806
- ods_eurostat_services_201807
- ods_eurostat_services_201808
- staging_eurostat_services
eurostat_wholesale_and_retail_trade
- ods_eurostat_wholesale_and_retail_trade_201805
- ods_eurostat_wholesale_and_retail_trade_201806
- ods_eurostat_wholesale_and_retail_trade_201807
- ods_eurostat_wholesale_and_retail_trade_201808
- staging_eurostat_wholesale_and_retail_trade
fed_g17_capacity_utilization
- ods_fed_g17_capacity_utilization_201805
- ods_fed_g17_capacity_utilization_201806
- ods_fed_g17_capacity_utilization_201807
- ods_fed_g17_capacity_utilization_201808
- staging_fed_g17_capacity_utilization
fed_g17_industrial_production
- ods_fed_g17_industrial_production_201805
- ods_fed_g17_industrial_production_201806
- ods_fed_g17_industrial_production_201807
- ods_fed_g17_industrial_production_201808
- staging_fed_g17_industrial_production
ihs_chemical_price_economics
- ods_ihs_chemical_price_economics_201805
- ods_ihs_chemical_price_economics_201806
- ods_ihs_chemical_price_economics_201807
- ods_ihs_chemical_price_economics_201808
- staging_ihs_chemical_price_economics
ihs_chemical_supply_demand
- ods_ihs_chemical_supply_demand_201805
- ods_ihs_chemical_supply_demand_201806
- ods_ihs_chemical_supply_demand_201807
- ods_ihs_chemical_supply_demand_201808
- staging_ihs_chemical_supply_demand
lmc_global_automotive_monthly_production
- ods_lmc_global_automotive_monthly_production_201805
- ods_lmc_global_automotive_monthly_production_201806
- ods_lmc_global_automotive_monthly_production_201807
- ods_lmc_global_automotive_monthly_production_201808
- staging_lmc_global_automotive_monthly_production
lmc_global_automotive_monthly_production_bv4
- ods_lmc_global_automotive_monthly_production_bv4_201805
- ods_lmc_global_automotive_monthly_production_bv4_201806
- ods_lmc_global_automotive_monthly_production_bv4_201807
- staging_lmc_global_automotive_monthly_production_bv4
main_data
- main_data
- pivoted_main_data_201805
- pivoted_main_data_201806
- pivoted_main_data_201807
- pivoted_main_data_201808
- timedimension_monthid
meps_prices
- ods_meps_prices_201805
- ods_meps_prices_201806
- ods_meps_prices_201807
- ods_meps_prices_201808
- staging_meps_prices
oecd_business_tendency_surveys
- ods_oecd_business_tendency_surveys_201805
- ods_oecd_business_tendency_surveys_201806
- ods_oecd_business_tendency_surveys_201807
- ods_oecd_business_tendency_surveys_201808
- staging_oecd_business_tendency_surveys
oecd_composite_leading_indicators
- ods_oecd_composite_leading_indicators_201805
- ods_oecd_composite_leading_indicators_201806
- staging_oecd_composite_leading_indicators
oecd_consumer_opinion_surveys
- ods_oecd_consumer_opinion_surveys_201805
- ods_oecd_consumer_opinion_surveys_201806
- staging_oecd_consumer_opinion_surveys
oecd_industry_services_statistics_orders
- ods_oecd_industry_services_statistics_orders_201805
- ods_oecd_industry_services_statistics_orders_201806
- ods_oecd_industry_services_statistics_orders_201807
- ods_oecd_industry_services_statistics_orders_201808
- staging_oecd_industry_services_statistics_orders
oecd_industry_services_statistics_production
- ods_oecd_industry_services_statistics_production_201805
- ods_oecd_industry_services_statistics_production_201806
- staging_oecd_industry_services_statistics_production
oecd_industry_services_statistics_sales
- ods_oecd_industry_services_statistics_sales_201805
- ods_oecd_industry_services_statistics_sales_201806
- ods_oecd_industry_services_statistics_sales_201807
- ods_oecd_industry_services_statistics_sales_201808
- staging_oecd_industry_services_statistics_sales
pie_polymers_prices
- ods_pie_polymers_prices_201805
- ods_pie_polymers_prices_201806
- ods_pie_polymers_prices_201807
- ods_pie_polymers_prices_201808
- staging_pie_polymers_prices
technical_params
- geography_short_name
- geography_short_name_buffer
- mircostrategy_attributes
- mircostrategy_metrics
- mircostrategy_operators
- mircostrategy_parameters
- mircostrategy_prompts
- mircostrategy_reports
- new_indicator_id_for_mstr
- new_indicator_id_for_mstr_buffer
temporary_merged_results
wind_asean_macroeconomic_indicators
- ods_wind_asean_macroeconomic_indicators_201805
- ods_wind_asean_macroeconomic_indicators_201806
- ods_wind_asean_macroeconomic_indicators_201808
- staging_wind_asean_macroeconomic_indicators
worldbank_prices_in_nominal
- ods_worldbank_prices_in_nominal_201805
- ods_worldbank_prices_in_nominal_201806
- ods_worldbank_prices_in_nominal_201807
- ods_worldbank_prices_in_nominal_201808
- staging_worldbank_prices_in_nominal | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-data-gathering-poc | solvay-data-gathering | ??? | ??? | PC2354 - Solvay - Data gathering & analysis | ??? | ??? | ??? | gdp
- gdp_fr
- sts_inpr_m_fr
poc_bloomberg_commodities
- ods_bloomberg_commodities
- staging_bloomberg_commodities
poc_bloomberg_currencies
- ods_bloomberg_currencies
- staging_bloomberg_currencies
poc_bloomberg_debts
- ods_bloomberg_debts
- staging_bloomberg_debts
poc_bloomberg_interest_rates
- ods_bloomberg_interest_rates
- staging_bloomberg_interest_rates
poc_bloomberg_others
- ods_bloomberg_others
- staging_bloomberg_others
poc_bloomberg_pmi
- ods_bloomberg_pmi
- staging_bloomberg_pmi
poc_bloomberg_stock_exchange
- ods_bloomberg_stock_exchange
- staging_bloomberg_stock_exchange
poc_eurostat_production_in_industry
- ods_eurostat_production_in_industry
_ staging_eurostat_production_in_industry
poc_ihs_chemical_supply_and_demand
- ods_ihs_chemical_supply_and_demand
- staging_ihs_chemical_supply_and_demand
poc_lmc_global_automotive_production
- staging_lmc_global_automotive_production_annual
- staging_lmc_global_automotive_production_forecast
- staging_lmc_global_automotive_production_monthly
- staging_lmc_global_automotive_pro
poc_meps_prices
- prices_asia
- prices_eu
- prices_north_america
- staging_meps_prices_asia
- staging_meps_prices_eu
- staging_meps_prices_namerica
poc_merge_results
- main_data
- results_20170626_072424
- results_20170705_135425
- results_20170725_074557
- results_20170731_082348
- results_20170911_142205
- results_20171002_125305
- results_20171010_185522
- results_20171023_142442
- results_20171025_093743
sts_inpr_m
- sts_inpr_m_C20
- sts_inpr_m_C201
- sts_inpr_m_C2011
- sts_inpr_m_C2012
- sts_inpr_m_C2013
- sts_inpr_m_C2014
- sts_inpr_m_C2015
- sts_inpr_m_C2016
- sts_inpr_m_C2017
- sts_inpr_m_C202
- sts_inpr_m_C203
- sts_inpr_m_C204
- sts_inpr_m_C2041
- sts_inpr_m_C2042
- sts_inpr_m_C205
- sts_inpr_m_C2051
- sts_inpr_m_C2052
- sts_inpr_m_C2053
- sts_inpr_m_C2059
- sts_inpr_m_C206
- sts_inpr_m_chemicals
sts_inpr_m_processed
- isnull_table
- notnull_table
- sts_inpr_m_C2011_ema
- sts_inpr_m_C2011_joined
- sts_inpr_m_C2011_raw
- sts_inpr_m_C2012_ema
- sts_inpr_m_C2012_joined
- sts_inpr_m_C2012_raw
- sts_inpr_m_C2013_ema
- sts_inpr_m_C2013_joined
- sts_inpr_m_C2013_raw
- sts_inpr_m_C2014_ema
- sts_inpr_m_C2014_joined
- sts_inpr_m_C2014_raw
- sts_inpr_m_C2015_ema
- sts_inpr_m_C2015_joined
- sts_inpr_m_C2015_raw
- sts_inpr_m_C2016_ema
- sts_inpr_m_C2016_joined
- sts_inpr_m_C2016_raw
- sts_inpr_m_C2017_ema
- sts_inpr_m_C2017_joined
- sts_inpr_m_C2017_raw
- sts_inpr_m_C201_ema
- sts_inpr_m_C201_joined
- sts_inpr_m_C201_raw
- sts_inpr_m_C202_ema
- sts_inpr_m_C202_joined
- sts_inpr_m_C202_raw
- sts_inpr_m_C203_ema
- sts_inpr_m_C203_joined
- sts_inpr_m_C203_raw
- sts_inpr_m_C2041_ema
- sts_inpr_m_C2041_joined
- sts_inpr_m_C2041_raw
- sts_inpr_m_C2042_ema
- sts_inpr_m_C2042_joined
- sts_inpr_m_C2042_raw
- sts_inpr_m_C204_ema
- sts_inpr_m_C204_joined
- sts_inpr_m_C204_raw
- sts_inpr_m_C2051_ema
- sts_inpr_m_C2051_joined
- sts_inpr_m_C2051_raw
- sts_inpr_m_C2052_ema
- sts_inpr_m_C2052_joined
- sts_inpr_m_C2052_raw
- sts_inpr_m_C2053_ema
- sts_inpr_m_C2053_joined
- sts_inpr_m_C2053_raw
- sts_inpr_m_C2059_ema
- sts_inpr_m_C2059_joined
- sts_inpr_m_C2059_raw
- sts_inpr_m_C205_ema
- sts_inpr_m_C205_joined
- sts_inpr_m_C205_raw
- sts_inpr_m_C206_ema
- sts_inpr_m_C206_joined
- sts_inpr_m_C206_raw
- sts_inpr_m_C20_ema
- sts_inpr_m_C20_joined
- sts_inpr_m_C20_raw
- sts_inpr_m_chemicals
- sts_inpr_m_chemicals_ema
- sts_inpr_m_ma
- sts_inpr_volume_demo | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-rtr-workflow-test | solvay-rtr-workflow-test | ??? | ??? | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | No GBQ | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-sow-freshdesk-prod | solvay-sow-freshdesk-prod | ??? | ??? | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | No GBQ | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-mdm-dev | solvay-mdm-dev | ??? | ??? | PC2737 - Solvay - MDM | ??? | ??? | ??? | | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-rtr-validation-workflow | solvay-rtr-validation-workflow | ??? | ??? | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | application_logs - appengine_googleapis_com_request_log_ (544) - appengine_googleapis_com_request_log_restore_ (2) - cloudaudit_googleapis_com_activity_ (535) - cloudaudit_googleapis_com_activity_restore_ (4) - cloudaudit_googleapis_com_data_access_ (5) - compute_googleapis_com_activity_log_ | OK 21/08/2018 | KO | OK 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-sow-freshdesk-dev | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? |
| Waiting info gilles.michel@vendohm.com | SES-GCP-Sandbox | Enguerran DALLET | VERNEUIL, Jean-Charles | | Project to host the Vendhom application for Solvay Energy Services | Live | Active - Prod | | | | | | | | |
| solvay-sia-product-catalog | solvay-sia-product-catalog | David TONDA | Sebastien Issanchou | revevol.eu | MVP for the SIA R&I Product Database app | Project | Active - Dev | | 17/08/2018 | OK 17/08/2018 | OK 17/08/2018 | All except Thomas Laporte - Waiting documentation | OK | | |
| solvay-support-kpi-prd | solvay-support-kpi-prd | David TONDA | Denis Bachevillier | revevol.eu | Project for all ticketing data - used by Solvia & SBS Support Dashboard in Qlikview | Project | Active - Prod | | 17/08/2018 | OK 17/08/2018 | OK 17/08/2018 | | | | |
| p-solvay-gp12615-cognitive | cognitive-search-engine | David TONDA | Cedric Valentino | Devoteam | Cognitive Search for Innovation POC Project Prod | Stopped | Inactive - Prod | | ERROR 17/08/2018 | 17/08/2018 | ERROR 17/08/2018 | Waiting re-hosting | Not done | | |
| d-solvay-gp12615-cognitive | cognitive-search-engine-dev | David TONDA | Cedric Valentino | Devoteam | Cognitive Search for Innovation POC Project Dev | Stopped | Inactive - Dev | | ERROR 17/08/2018 | 17/08/2018 | ERROR 17/08/2018 | Waiting re-hosting | Not done | | |
| solvay-sow-freshdesk-data-dev | solvay-sow-freshdesk-data-dev | David TONDA | Denis Bachevillier | Devoteam | Old project for ticketing created by Ciruseo - Dev | Stopped | Inactive - Dev | | OK 17/08/2018 | OK 17/08/2018 | Invitation Pending 17/08/2018 | OK 17/08/2018 | Not done | | |
| solvay-sow-freshdesk-data-prd | solvay-sow-freshdesk-data-prd | David TONDA | Denis Bachevillier | Devoteam | Old project for ticket created by Ciruseo - Prod | Stopped | Inactive - Prod | | ERROR 17/08/2018 | 17/08/2018 | Invitation Pending 17/08/2018 | OK 17/08/2018 | Not done | | |
| solvay-data-catalog-dev | solvay-data-catalog-dev | Enguerran DALLET | David Tonda | Cirruseo | Strategy ECI (Economic & Competitive Intelligence) Data Catalog - Dev | Maintenance | Active - Dev | | Invitation pending | 17/08/2018 | OK 17/08/2018 | Waiting re-hosting Keep hanqing.jiang@cirruseo.com | Not done | | |
| solvay-support-assistant | solvay-support-assistant | Enguerran DALLET | Marie Line Ardito / Sandra Silveira | revevol.eu | Solvia Project. Smart ticketing app (and the ML related) | Project | Active - Dev | | 17/08/2018 | 17/08/2018 | OK 17/08/2018 | 17/08/2018 | OK | | |
| BDA GCP Sandbox | bi-gcp-sandbox | David Tonda | David Tonda | revevol.eu | Sandbox for the Big Data & Analytics team - Shared with some of R&I SMART members | Sandbox | Team sandbox | | | | | | | | |
| solvay-data-catalog-lab | solvay-data-catalog-lab | Enguerran Dallet | Sofia Vides | Cirruseo | Strategy ECI (Economic & Competitive Intelligence) Data Catalog | Maintenance | Active - Prod | | OK 17/08/2018 | 17/08/2018 | Invitation pending 17/08/2018 | Waiting re-hosting Keep hanqing.jiang@cirruseo.com | Not done | | |
| solvay-freshdesk-bigquery | solvay-freshdesk-bigquery | David Tonda | Denis Bachevillier | Devoteam | Project for all ticketing data - used by Solvia & SBS Support Dashboard in Qlikview - Dev | Project | Active - Dev | | ERROR 17/08/2018 | 17/08/2018 | OK 17/08/2018 | Waiting re-hosting | Not done | | |
| rni-datalake-batteries-dev | rni-datalake-batteries-dev | David Tonda | Sebastien Issanchou | Revevol.eu | Project for batteries used mainly or Big Query | Project | Active - Dev | | 20/08/2018 | | | OK | OK | | |
| PredictiveCreditManagement | predictivecreditmanagement | David Tonda | David Tonda | No Billing Account | Project that was requested initially for the Predictive Credit Manage project in order to write data into Googlespreadsheet - Not used currently | Stopped | Un-used | | ERROR 17/08/2018 | 17/08/2018 | ERROR 17/08/2018 | 17/08/2018 | OK | | |
