Google Account


User : EUA\analytic
Windows Password : CarloTentacule004
PIN Token : 202011 (fichier token dans le drive de l'équipe : .stdid)
Freshdesk password : CarloTentacule002

List of projects

Project NameProject IDBD&A OwnerBusiness ContactBilling AccountDescriptionStatusCategory

GBQ

Data source

Dominique

Owner

SBS-IS-Appli-Techno-BD-A-All@solvay.com as Editoradmin.revevol@solvay.com + Dawn Lai as OwnerAccess from external removed after projectRehosting request to infraOrganisation
Solvay Energy Aggregation Prodsolvay-energy-aggregation-prodDavid TONDAJean Charles Verneuilrevevol.euProject used for Solvay Energy for the aggregation of energy production/consumption dataWaiting DevActive - Prod
OKOKOKOKOKSolvay
Solvay Energy Aggregation Devsolvay-energy-aggregation-devDavid TONDAJean Charles Verneuilrevevol.euProject used for Solvay Energy for the aggregation of energy production/consumption dataIn DevelopmentActive - Dev
OKOKOKOKOKSolvay
Solvay-Ind-Conso-Prodsolvay-ind-conso-prodDavid TONDADavid TONDArevevol.euProject to store all BigQuery/GCS datasets that are global and related to industrial. Only IS + a few central industrial users should have access.In DevelopmentActive - Dev
OK 05/09OK 05/09OK 05/09OK 05/09OKSolvay
Solvay RI TLC Devsolvay-ri-tlc-devDavid TONDASebastien Issanchourevevol.euProject used by MuSigma for the Thin Layer Chromatography data analytics project.In DevelopmentActive - Dev
OK 05/09OK 05/09OK 05/09After projectOKSolvay
 Analytics-Spinetta-Polymersanalytics-spinetta-gcp-prodAlain FolletSandy Savoiarevevol.euProject which receives in BigQuery data necessary for the SAS analytics workloads of the Speciality Polymers Spinetta PlantIn DevelopmentActive - 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

???OKSolvay???
 INV-LINK-TOOLinv-link-tool??????My Billing Account?????????No GBQKOKOKO????????????
 MES Consolidation GCP Sandboxmes-consolidation-gcp-sandbox??????revevol.eu?????????
Table non accessible par moi DVE, mais uniquement les datasets "does not have bigquery.tables.list "
GBU_SA
LON_H2O2
ROS_SO
TOR_SO
OK 21/08/2018KO

OK 21/08/2018 revevol

KO Dawn

????????????
 solvay-data-catalog-prodsolvay-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/2018KOInvitation Pending 21/08/2018????????????
 solvay-data-gathering-pocsolvay-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/2018KOInvitation Pending 21/08/2018????????????
 solvay-rtr-workflow-testsolvay-rtr-workflow-test??????PC0845 - Solvay - Freshdesk European Project?????????No GBQOK 21/08/2018KOInvitation Pending 21/08/2018????????????
 solvay-sow-freshdesk-prodsolvay-sow-freshdesk-prod??????PC0845 - Solvay - Freshdesk European Project?????????No GBQOK 21/08/2018KOInvitation Pending 21/08/2018????????????
solvay-mdm-devsolvay-mdm-dev??????PC2737 - Solvay - MDM?????????
solvay-mdm-dev
 - solvay_mdm_dev
OK 21/08/2018KOInvitation Pending 21/08/2018????????????
solvay-rtr-validation-workflowsolvay-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/2018KOInvitation Pending 21/08/2018????????????
solvay-sow-freshdesk-devsolvay-sow-freshdesk-devPC0845 - Solvay - Freshdesk European Project???????????????solvay_groupsOK 21/08/2018KOInvitation Pending 21/08/201????????????
Waiting info gilles.michel@vendohm.comSES-GCP-SandboxEnguerran DALLETVERNEUIL, Jean-Charles
Project to host the Vendhom application for Solvay Energy ServicesLiveActive - Prod????????????????????????
solvay-sia-product-catalogsolvay-sia-product-catalogDavid TONDASebastien Issanchourevevol.euMVP for the SIA R&I Product Database appProjectActive - DevNo GBQOK 17/08/2018OK 17/08/2018OK 17/08/2018All except Thomas Laporte - Waiting documentationOK

solvay-support-kpi-prdsolvay-support-kpi-prdDavid 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.

ProjectActive - 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/2018OK 17/08/2018OK 17/08/2018

 


p-solvay-gp12615-cognitivecognitive-search-engineDavid TONDACedric ValentinoDevoteamCognitive Search for Innovation POC Project ProdStoppedInactive - Prod
KO 17/08/2018OK 17/08/2018KO 17/08/2018Waiting re-hostingNot done

d-solvay-gp12615-cognitivecognitive-search-engine-devDavid TONDACedric ValentinoDevoteamCognitive Search for Innovation POC Project DevStoppedInactive - 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/2018OK 17/08/2018KO 17/08/2018Waiting re-hostingNot done

solvay-sow-freshdesk-data-devsolvay-sow-freshdesk-data-devDavid TONDADenis BachevillierDevoteamOld project for ticketing created by Ciruseo - DevStoppedInactive - Dev
fd_logs
sfdc_raw
views
OK 17/08/2018OK 17/08/2018Invitation Pending 17/08/2018OK 17/08/2018Not done

solvay-sow-freshdesk-data-prdsolvay-sow-freshdesk-data-prd

David

TONDA

Denis BachevillierDevoteamOld project for ticket created by Ciruseo - ProdStoppedInactive - Prod
fd_logs
- fd_logs
KO 17/08/2018OK 17/08/2018Invitation Pending 17/08/2018OK 17/08/2018Not done

solvay-data-catalog-devsolvay-data-catalog-devEnguerran DALLETDavid Tonda

PC2354 - Solvay - Data gathering & analysis

Cirruseo

Strategy ECI (Economic & Competitive Intelligence) Data Catalog - DevMaintenanceActive - 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 pendingOK 17/08/2018OK 17/08/2018

Waiting re-hosting

Keep hanqing.jiang@cirruseo.com

Not done

solvay-support-assistantsolvay-support-assistantEnguerran DALLETMarie Line Ardito / Sandra Silveirarevevol.euSolvia Project. Smart ticketing app (and the ML related)ProjectActive - Dev
OK 17/08/2018OK 17/08/2018OK 17/08/201817/08/2018OK

BDA GCP Sandboxbi-gcp-sandboxDavid TondaDavid Tondarevevol.euSandbox for the Big Data & Analytics team - Shared with some of R&I SMART membersSandboxTeam sandbox

dss
flower
POC_HSE
Talend
Test_AFO_MES
Test_Gsr
Test_Pivot
Test_SES
Test_Tableau

OK 17/08/2018KO 23/08/2018OK 17/08/2018



solvay-data-catalog-labsolvay-data-catalog-labEnguerran DalletSofia Vides

PC2354 - Solvay - Data gathering & analysis

Cirruseo

Strategy ECI (Economic & Competitive Intelligence) Data CatalogMaintenanceActive - 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/2018OK 17/08/2018Invitation Pending 17/08/2018

Waiting re-hosting

Keep hanqing.jiang@cirruseo.com

Not done

solvay-freshdesk-bigquerysolvay-freshdesk-bigqueryDavid TondaFlorian KroellDevoteamProject for all ticketing data - used by Solvia & SBS Support Dashboard in Qlikview - DevProjectActive - Dev

DATA_SUPPORT_TICKETS_ALL
FASTCONNECT_ARCHIVES
FOOTPRINT_ARCHIVES
freshdesk
my_new_dataset
SALES_FORCE_ARCHIVES
SAS_FRESHDESK
WS_TICKETS

OK 23/08/2018OK 17/08/2018OK 17/08/2018Waiting re-hostingNot done

rni-datalake-batteries-devrni-datalake-batteries-devDavid TondaSebastien IssanchouRevevol.euProject for batteries used mainly or Big QueryProjectActive - Dev

rni_battery
- solvay_korea
- solvay_korea_copy
- solvay_korea_dev

20/08/2018

 

 

OKOK

 PredictiveCreditManagementpredictivecreditmanagementDavid TondaDavid TondaNo Billing AccountProject that was requested initially for the Predictive Credit Manage project in order to write data into Googlespreadsheet - Not used currentlyStoppedUn-used
KO 17/08/2018OK 17/08/2018KO 17/08/201817/08/2018OK

self service datalakesol-self-service-datalake-prodDavid TondaDavid TondaRevevol.euAllows user to explore data and do some heavy data treatmentSupportActive - 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!!!

KOOK 25/03/2021OK 25/03/2021OK
Solvay
SolvIAsolvay-support-assistantDavid TondaSandra SilveiraRevevol.euAllow user to create a SBS ticket with an IASupportAtive - Prod

Appengine (web server that hosts SolvIA)

Bigquery datasets : 

solvia-ml => anonymized data source for the IA model prediction algorythm

KOOK 25/03/2021OK 25/03/2021

Hugues.zimmermann@devoteam.com

To remove


Solvay



  • No labels