| 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 |
|
|---|
| Solvay Energy Aggregation Prod | solvay-energy-aggregation-prod | David TONDA | Jean Charles Verneuil | revevol.eu | Project used for Solvay Energy for the aggregation of energy production/consumption data | Waiting Dev | Active - Prod |
| OK | OK | OK | OK | OK | Solvay |
|
| Solvay Energy Aggregation Dev | solvay-energy-aggregation-dev | David TONDA | Jean Charles Verneuil | revevol.eu | Project used for Solvay Energy for the aggregation of energy production/consumption data | In Development | Active - Dev |
| OK | OK | OK | OK | OK | Solvay |
|
| Solvay-Ind-Conso-Prod | solvay-ind-conso-prod | David TONDA | David TONDA | revevol.eu | Project to store all BigQuery/GCS datasets that are global and related to industrial. Only IS + a few central industrial users should have access. | In Development | Active - Dev |
| OK 05/09 | OK 05/09 | OK 05/09 | OK 05/09 | OK | Solvay |
|
| Solvay RI TLC Dev | solvay-ri-tlc-dev | David TONDA | Sebastien Issanchou | revevol.eu | Project used by MuSigma for the Thin Layer Chromatography data analytics project. | In Development | Active - Dev |
| OK 05/09 | OK 05/09 | OK 05/09 | After project | OK | Solvay |
|
| Analytics-Spinetta-Polymers | analytics-spinetta-gcp-prod | Alain Follet | Sandy Savoia | revevol.eu | Project which receives in BigQuery data necessary for the SAS analytics workloads of the Speciality Polymers Spinetta Plant | In Development | Active - Dev | 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 | ??? | OK | Solvay | ??? |
| 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 | Invitation Pending 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 | Invitation Pending 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-rtr-workflow-test | solvay-rtr-workflow-test | ??? | ??? | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | No GBQ | OK 21/08/2018 | KO | Invitation Pending 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-sow-freshdesk-prod | solvay-sow-freshdesk-prod | ??? | ??? | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | No GBQ | OK 21/08/2018 | KO | Invitation Pending 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-mdm-dev | solvay-mdm-dev | ??? | ??? | PC2737 - Solvay - MDM | ??? | ??? | ??? | | OK 21/08/2018 | KO | Invitation Pending 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 | Invitation Pending 21/08/2018 | ??? | ??? | ??? | ??? |
| solvay-sow-freshdesk-dev | solvay-sow-freshdesk-dev | PC0845 - Solvay - Freshdesk European Project | ??? | ??? | ??? | ??? | ??? | solvay_groups | OK 21/08/2018 | KO | Invitation Pending 21/08/201 | ??? | ??? | ??? | ??? |
| 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 | No GBQ | OK 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 | Florian Kroell + Sandra Silveira | revevol.eu | Project for all ticketing data - used by Solvia & SBS Support Dashboard in Qlikview
Warning : There are sensitive personal data inside Freshdesk tickets. Request access to that data must be done by openning a ticket with ITSM and get the approval of Sandra Silveira. | Project | Active - Prod | CAP_EXPORT - Closed_Tickets_July2017 - combined_tickets_enriched CGI_EXPORT - Act_ticket_backlog_non_cgi - Act_ticket_clos_reprise - Activities_backlog - backlog_tickets - Pb_Time_zone - Reprise_ticket_clos - Ticket_backlog_non_cgi DATA_EXPORT - COMBINED_TICKETS - complaints_only - FRESHDESK_CLEAN - FRESHDESK_EXTRACT - FRESHDESK_ML_DATA - FRESHDESK_SAMPLE - otc_export - REMEDY - REMEDY_CLEAN - REMEDY_SAMPLE - result_for_analysis_enguerran - results_20170925_154902_dtonda - temp - test DATA_FRESHDESK - API_REMAINING DATA_SUPPORT_COMMON_ALL - agent - contacts - contacts_confidential - groups - groups_mapping - LOADS - time_zone_offset_time DATA_SUPPORT_TICKETS_ALL - tickets_active_time - tickets_business_time - tickets_enriched - tickets_first_priority - tickets_group_moves - tickets_notes_number - tickets_pending - tickets_resolution_time - tickets_SLA DATA_SUPPORT_TICKETS_IS - Raw_freshdesk_ticket_activities - Raw_freshdesk_tickets - tickets_enriched_is - tickets_list - tickets_pending_is - tickets_utb_IS_Request dataiku - FRESHDESK_ANALYSIS_companies_dataset_bq - FRESHDESK_ANALYSIS_tickets_gcs_bq - FRESHDESK_ANALYSIS_users_dataset_bq FASTCONNECT_ARCHIVES - categorias - centros - clases - country - divisiones - incidencias - persgrupos - personal - prioridades - problemas - sistemas_SAP - sites FOOTPRINT_ARCHIVES - footprint_data - reporting_fp ODS_SOLMAN - change_document_activities - change_document_new - support_dashboard_dev - support_dashboard_rec SALES_FORCE_ARCHIVES - Account - Attachment - Case - case_enriched - Case_w_link - CaseComment - CaseHistory2 - CaseSolution - Contact - ContentContent - ContentReference - Document - EmailMessage - Event - FeedPost - FieldHistory - RecordType - RecordType2 - RecordTypeConf - RichTextAreaFieldData - Task - TaskRelation - User - UserRole SAS_FRESHDESK - agent_datastore - agents - agents_confidential - agents_confidential_temp - agents_temp - api_calls - contacts - contacts_bucket - contacts_temp - groups - groups_confidential - groups_confidential_temp - groups_temp - LOADS - satisfaction_ratings - satisfaction_ratings_confidential - satisfaction_ratings_confidential_temp - satisfaction_ratings_temp - ticket_activities - ticket_activities_confidential - ticket_activities_confidential_temp - ticket_activities_since_05122017 - ticket_activities_temp - tickets - tickets_confidential - tickets_confidential_temp - tickets_language_analysis - tickets_language_analysis_confidential - tickets_temp SAS_MANUAL_DATA - groups_mapping - mapping_country_freshdesk - mapping_GBU - SLA_targets - status_mapping - time_zone_offset_time SAS_ONESHOT - RemedyForce SAS_REMEDY SAV_FRESHDESK - sav_agent_final_ (30) - sav_agent_sas_confidential_ (30) - sav_agent_sas_public_ (30) - sav_contact_final_ (30) - sav_contact_sas_ (30) - sav_groups_final_ (30) - sav_groups_sas_confidential_ (30) - sav_groups_sas_public_ (30) - sav_satisfaction_ratings_ (30) - sav_tickets_ (30) - sav_tickets_activities_ (30) - sav_tickets_language_analysis_ (30) - groups_mapping - mapping_country_freshdesk - mapping_GBU - SLA_targets - status_mapping - time_zone_offset_time SAS_ONESHOT - RemedyForce SAS_REMEDY SAV_FRESHDESK - sav_agent_final_ (30) - sav_agent_sas_confidential_ (30) - sav_agent_sas_public_ (30) - sav_contact_final_ (30) - sav_contact_sas_ (30) - sav_groups_final_ (30) - sav_groups_sas_confidential_ (30) - sav_groups_sas_public_ (30) - sav_satisfaction_ratings_ (30) - sav_tickets_ (30) - sav_tickets_activities_ (30) - sav_tickets_language_analysis_ (30) SAVE - Case_20171031 - Case_Sales_force - EmailMessage_copy - Logs_web - test - test_change_schema - ticket_activities - ticket_activities_20170104_2 - ticket_activities_ (2) - ticket_activities_new_schema - ticket_activities_save_05072017 - ticket_activities_save_2 - ticket_activities_save_after_merge - tickets - tickets_copy - tickets_copy_26072017 - tickets_language_analysis_copy - tickets_language_analysis_copy_ (2) - tickets_language_analysis_copy_27072017 - tickets_language_analysis_copy_test_1000batch - treated_tickets_25072017 SolvIA - Categories - combined_tickets - combined_tickets_enriched - combined_tickets_fixed - freshdesk_enriched - Freshdesk_tickets - Logs_web - Logs_web_dev - mapping_frshdsk_prcss_categ - prediction_vs_final - remedy_tickets - reporting_010 - reporting_020 - reporting_030 - reporting_040 - reporting_050 - reporting_060 solvia_ml_training - keras_perf - perfs - test TEST_JSON WS_TICKETS - activities_times_group_step_001 - activities_times_group_step_0015 - activities_times_group_step_002 - activities_times_group_step_0021 - activities_times_group_step_0022 - activities_times_group_step_003 - activities_times_group_step_0031 - activities_times_group_step_004 - activities_times_group_step_005 - activities_times_group_step_006 - activities_times_group_step_007 - activities_times_group_step_008 - activities_times_group_step_009 - activities_times_group_step_0091 - activities_times_group_step_010 - activities_times_group_step_011 - agent_add - agent_step_001 - calendar_D1_D4 - contact_step_001 - contact_step_002 - contact_step_003 - contacts_add - first_closed_date - first_priority_step_001 - first_priority_step_002 - first_priority_step_003 - first_priority_step_004 - first_status_step_001 - first_status_step_002 - Last_activities_closed_date - last_resolved_date_before_first_closed_date - reopen_tickets - survey_step_001 - survey_step_002 - tags_step_001 - tags_step_002 - tags_step_003 - tags_step_004 - tickets_step_001 - tickets_step_002 - tickets_step_003 - tickets_step_004 - tickets_step_005 - tickets_step_006 - tickets_step_007 | 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 |
| KO 17/08/2018 | OK 17/08/2018 | KO 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 | competitive_intel - document - graph - sentence - vocabulary - word CSE - appengine_googleapis_com_request_log_ (63) - dataset_aroma - dataset_competitive_intel - dataset_ri_hse - dataset_silica - dataset_water_treatment - docs_plain_url - documents_ (5) - stats - word_counts TMP - documents_20170914_BAK | KO 17/08/2018 | OK 17/08/2018 | KO 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 | fd_logs | 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 | fd_logs | KO 17/08/2018 | OK 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 | PC2354 - Solvay - Data gathering & analysis Cirruseo | Strategy ECI (Economic & Competitive Intelligence) Data Catalog - Dev | Maintenance | Active - Dev | acc_business_chemistry acc_global_chemical_industry_production_index acc_global_macroeconomic_indicators acc_survey_economic_forecasters bloomberg_commodities bloomberg_currencies bloomberg_debts bloomberg_interest_rates bloomberg_money_supply bloomberg_others bloomberg_pmi bloomberg_stock_exchange bloomberg_trade_balance eiu_macroeconomic_databank eurostat_business_climate_indicator eurostat_construction eurostat_consumers eurostat_energy eurostat_industry eurostat_production_in_construction eurostat_production_in_industry eurostat_services eurostat_wholesale_and_retail_trade fed_g17_capacity_utilization fed_g17_industrial_production ihs_chemical_price_economics ihs_chemical_supply_demand lmc_global_automotive_monthly_production lmc_global_automotive_monthly_production_bv4 main_data meps_prices oecd_business_tendency_surveys oecd_composite_leading_indicators oecd_consumer_opinion_surveys oecd_industry_services_statistics_orders oecd_industry_services_statistics_production oecd_industry_services_statistics_sales pie_polymers_prices technical_params temporary_merged_results wind_asean_macroeconomic_indicators worldbank_prices_in_nominal | Invitation pending | OK 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 |
| OK 17/08/2018 | OK 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 | dss flower POC_HSE Talend Test_AFO_MES Test_Gsr Test_Pivot Test_SES Test_Tableau | OK 17/08/2018 | KO 23/08/2018 | OK 17/08/2018 |
|
|
|
|
| solvay-data-catalog-lab | solvay-data-catalog-lab | Enguerran Dallet | Sofia Vides | PC2354 - Solvay - Data gathering & analysis Cirruseo | Strategy ECI (Economic & Competitive Intelligence) Data Catalog | Maintenance | Active - Prod | acc_business_chemistry acc_global_chemical_industry_production_index acc_global_macroeconomic_indicators acc_survey_economic_forecasters bloomberg_commodities bloomberg_currencies bloomberg_debts bloomberg_interest_rates bloomberg_money_supply bloomberg_others bloomberg_pmi bloomberg_stock_exchange bloomberg_trade_balance eiu_macroeconomic_databank eurostat_business_climate_indicator eurostat_construction eurostat_consumers eurostat_energy eurostat_industry eurostat_production_in_construction eurostat_production_in_industry eurostat_services eurostat_wholesale_and_retail_trade fed_g17_capacity_utilization fed_g17_industrial_production ihs_chemical_price_economics ihs_chemical_supply_demand lmc_global_automotive_monthly_production_bv4 main_data meps_prices oecd_business_tendency_surveys oecd_composite_leading_indicators oecd_consumer_opinion_surveys oecd_industry_services_statistics_orders oecd_industry_services_statistics_production oecd_industry_services_statistics_sales pie_polymers_prices technical_params temporary_merged_results wind_asean_macroeconomic_indicators worldbank_prices_in_nominal | OK 17/08/2018 | OK 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 | Florian Kroell | Devoteam | Project for all ticketing data - used by Solvia & SBS Support Dashboard in Qlikview - Dev | Project | Active - Dev | DATA_SUPPORT_TICKETS_ALL FASTCONNECT_ARCHIVES FOOTPRINT_ARCHIVES freshdesk my_new_dataset SALES_FORCE_ARCHIVES SAS_FRESHDESK WS_TICKETS | OK 23/08/2018 | OK 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 | rni_battery - solvay_korea - solvay_korea_copy - solvay_korea_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 |
| KO 17/08/2018 | OK 17/08/2018 | KO 17/08/2018 | 17/08/2018 | OK |
|
|
| self service datalake | sol-self-service-datalake-prod | David Tonda | David Tonda | Revevol.eu | Allows user to explore data and do some heavy data treatment | Support | Active - Prod | each user have his own space (Cloud storage + Dataset) called by his windows login.
Everybody can request access by creating a ticket and requesting access to Self Service Datalake
each user will have the following rights : IAM => BigQuery→Job User => bucket list - custom role Dataset => BigQuery→Data Owner => BigQuery→ Admin Bucket => Cloud Storage → Admin => Cloud Storage Legacy → Bucket Owner
/!\ Some tools need more than IAM => BigQuery → Job user like dataiku, Qlikview and more. In that case choose BigQuery User. The user will see all dataset and all table names!!! | KO | OK 25/03/2021 | OK 25/03/2021 | OK |
| Solvay |
|
| SolvIA | solvay-support-assistant | David Tonda | Sandra Silveira | Revevol.eu | Allow user to create a SBS ticket with an IA | Support | Ative - Prod | Appengine (web server that hosts SolvIA) Bigquery datasets : solvia-ml => anonymized data source for the IA model prediction algorythm | KO | OK 25/03/2021 | OK 25/03/2021 | Hugues.zimmermann@devoteam.com To remove |
| Solvay |
|