""" uuid: a0d2b4c5-1f72-4377-84dd-b343f87a278e\n langcode: en\n status: true\n dependencies:\n enforced:\n module:\n - dp_import\n _core:\n default_config_hash: gj6RMgoGY8PXiBtAq60hoX1WsoKfsTW-SC_ip9JcfxM\n id: dp_updates\n class: null\n field_plugin_method: null\n cck_plugin_method: null\n migration_tags: DP\n migration_group: dp_import\n label: 'DP updates data import'\n source:\n plugin: csv\n path: /var/www/html/private/derivativepartners/dp_updates_new_UTF8.csv\n delimiter: ;\n enclosure: '"'\n header_offset: 0\n ids:\n - Product_ID\n - Underlying_Product_ID\n track_changes: true\n process:\n product_currency_tradingbased_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Currency_TradingBased_Short\n product_exchange_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Exchange_Name\n product_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_ID\n product_isin:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_ISIN\n product_knock_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_Knock_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_knock_status:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Knock_Status\n product_protection_level_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Protection_Level_Percent\n product_quotes_lastmodifieddate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_Quotes_LastModifiedDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_redemption_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Redemption_Percent\n product_valuations_ask_size_average:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Ask_Size_Average\n product_valuations_bid_size_average:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Bid_Size_Average\n product_valuations_bonus_yield:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Bonus_Yield\n product_valuations_bonus_yield_pa:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Bonus_Yield_PA\n product_valuations_break_even:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Break_Even\n product_valuations_calcprice:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_CalcPrice\n product_valuations_calcprice_strike:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_CalcPrice_Strike\n product_valuations_calcprice_underlying:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_CalcPrice_Underlying\n product_valuations_daystomaturity:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_DaysToMaturity\n product_valuations_delta:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Delta\n product_valuations_discount_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Discount_Percent\n product_valuations_fair_value:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Fair_Value\n product_valuations_fair_value_gap:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Fair_Value_Gap\n product_valuations_fair_value_issuer:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Fair_Value_Issuer\n product_valuations_gamma:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Gamma\n product_valuations_gearing:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Gearing\n product_valuations_implvola_ask:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_ImplVola_Ask\n product_valuations_implvola_bid:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_ImplVola_Bid\n product_valuations_implvola_calcprice:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_ImplVola_CalcPrice\n product_valuations_implvola_change:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_ImplVola_Change\n product_valuations_intrinsic_value:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Intrinsic_Value\n product_valuations_lastmodifieddate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_Valuations_LastModifiedDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_valuations_leverage_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Leverage_Percent\n product_valuations_liquidity_rating_code:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Liquidity_Rating_Code\n product_valuations_market_making_index:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Market_Making_Index\n product_valuations_moneyness:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Moneyness\n product_valuations_outperformance_level:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Outperformance_Level\n product_valuations_premium:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Premium\n product_valuations_premium_pa:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Premium_PA\n product_valuations_price_rating_code:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Price_Rating_Code\n product_valuations_product_rating_code:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Product_Rating_Code\n product_valuations_qqm_average_buy_volume:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Average_Buy_Volume\n product_valuations_qqm_average_buy_volume_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Average_Buy_Volume_Price\n product_valuations_qqm_average_sell_volume:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Average_Sell_Volume\n product_valuations_qqm_average_sell_volume_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Average_Sell_Volume_Price\n product_valuations_qqm_average_spread:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Average_Spread\n product_valuations_qqm_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_Valuations_QQM_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_valuations_qqm_last_best_ask_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Last_Best_Ask_Price\n product_valuations_qqm_last_best_ask_volume:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Last_Best_Ask_Volume\n product_valuations_qqm_last_best_bid_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Last_Best_Bid_Price\n product_valuations_qqm_last_best_bid_volume:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Last_Best_Bid_Volume\n product_valuations_qqm_quotes_availability_ratio:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Quotes_Availability_Ratio\n product_valuations_qqm_spreads_availability_ratio:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_QQM_Spreads_Availability_Ratio\n product_valuations_ratings_risk_classcode:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Ratings_Risk_ClassCode\n product_valuations_ratings_risk_value:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Ratings_Risk_Value\n product_valuations_redemption_max:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Redemption_Max\n product_valuations_rho:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Rho\n product_valuations_sideward_yield:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Sideward_Yield\n product_valuations_sideward_yield_pa:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Sideward_Yield_PA\n product_valuations_spread_average:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Spread_Average\n product_valuations_spread_homo:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Spread_Homo\n product_valuations_spread_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Spread_Percent\n product_valuations_strikesensitivity:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_StrikeSensitivity\n product_valuations_theta_1day:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Theta_1Day\n product_valuations_theta_7days:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Theta_7Days\n product_valuations_timevalue:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_TimeValue\n product_valuations_turnover_chf_average:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Turnover_CHF_Average\n product_valuations_underperformance_level:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Underperformance_Level\n product_valuations_vega:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Vega\n product_valuations_yield_max:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Yield_Max\n product_valuations_yield_max_pa:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Valuations_Yield_Max_PA\n underlying_component_currency:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Currency\n underlying_component_isin:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_ISIN\n underlying_component_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Name\n underlying_component_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Price\n underlying_component_strike_1_activation_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Underlying_Component_Strike_1_Activation_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n underlying_component_strike_1_distance:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_Distance\n underlying_component_strike_1_distance_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_Distance_Percent\n underlying_component_strike_1_isknocked:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_IsKnocked\n underlying_component_strike_2_activation_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Underlying_Component_Strike_2_Activation_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n underlying_component_strike_2_distance:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_Distance\n underlying_component_strike_2_distance_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_Distance_Percent\n underlying_component_strike_2_isknocked:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_IsKnocked\n underlying_component_strike_3_activation_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Underlying_Component_Strike_3_Activation_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n underlying_component_strike_3_distance:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_Distance\n underlying_component_strike_3_distance_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_Distance_Percent\n underlying_component_strike_3_isknocked:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_IsKnocked\n underlying_component_strike_4_activation_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Underlying_Component_Strike_4_Activation_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n underlying_component_strike_4_distance:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_Distance\n underlying_component_strike_4_distance_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_Distance_Percent\n underlying_component_strike_4_isknocked:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_IsKnocked\n underlying_component_symbol:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Symbol\n underlying_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_ID\n underlying_product_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Product_ID\n underlying_valuations_histvola_180days:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Valuations_HistVola_180Days\n underlying_valuations_histvola_30days:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Valuations_HistVola_30Days\n underlying_valuations_histvola_90days:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Valuations_HistVola_90Days\n destination:\n plugin: table\n table_name: dp_updates\n batch_size: 1000\n id_fields:\n product_id:\n type: integer\n underlying_product_id:\n type: integer\n fields:\n product_currency_tradingbased_short: product_currency_tradingbased_short\n product_exchange_name: product_exchange_name\n product_id: product_id\n product_isin: product_isin\n product_knock_date: product_knock_date\n product_knock_status: product_knock_status\n product_protection_level_percent: product_protection_level_percent\n product_quotes_lastmodifieddate: product_quotes_lastmodifieddate\n product_redemption_percent: product_redemption_percent\n product_valuations_ask_size_average: product_valuations_ask_size_average\n product_valuations_bid_size_average: product_valuations_bid_size_average\n product_valuations_bonus_yield: product_valuations_bonus_yield\n product_valuations_bonus_yield_pa: product_valuations_bonus_yield_pa\n product_valuations_break_even: product_valuations_break_even\n product_valuations_calcprice: product_valuations_calcprice\n product_valuations_calcprice_strike: product_valuations_calcprice_strike\n product_valuations_calcprice_underlying: product_valuations_calcprice_underlying\n product_valuations_daystomaturity: product_valuations_daystomaturity\n product_valuations_delta: product_valuations_delta\n product_valuations_discount_percent: product_valuations_discount_percent\n product_valuations_fair_value: product_valuations_fair_value\n product_valuations_fair_value_gap: product_valuations_fair_value_gap\n product_valuations_fair_value_issuer: product_valuations_fair_value_issuer\n product_valuations_gamma: product_valuations_gamma\n product_valuations_gearing: product_valuations_gearing\n product_valuations_implvola_ask: product_valuations_implvola_ask\n product_valuations_implvola_bid: product_valuations_implvola_bid\n product_valuations_implvola_calcprice: product_valuations_implvola_calcprice\n product_valuations_implvola_change: product_valuations_implvola_change\n product_valuations_intrinsic_value: product_valuations_intrinsic_value\n product_valuations_lastmodifieddate: product_valuations_lastmodifieddate\n product_valuations_leverage_percent: product_valuations_leverage_percent\n product_valuations_liquidity_rating_code: product_valuations_liquidity_rating_code\n product_valuations_market_making_index: product_valuations_market_making_index\n product_valuations_moneyness: product_valuations_moneyness\n product_valuations_outperformance_level: product_valuations_outperformance_level\n product_valuations_premium: product_valuations_premium\n product_valuations_premium_pa: product_valuations_premium_pa\n product_valuations_price_rating_code: product_valuations_price_rating_code\n product_valuations_product_rating_code: product_valuations_product_rating_code\n product_valuations_qqm_average_buy_volume: product_valuations_qqm_average_buy_volume\n product_valuations_qqm_average_buy_volume_price: product_valuations_qqm_average_buy_volume_price\n product_valuations_qqm_average_sell_volume: product_valuations_qqm_average_sell_volume\n product_valuations_qqm_average_sell_volume_price: product_valuations_qqm_average_sell_volume_price\n product_valuations_qqm_average_spread: product_valuations_qqm_average_spread\n product_valuations_qqm_date: product_valuations_qqm_date\n product_valuations_qqm_last_best_ask_price: product_valuations_qqm_last_best_ask_price\n product_valuations_qqm_last_best_ask_volume: product_valuations_qqm_last_best_ask_volume\n product_valuations_qqm_last_best_bid_price: product_valuations_qqm_last_best_bid_price\n product_valuations_qqm_last_best_bid_volume: product_valuations_qqm_last_best_bid_volume\n product_valuations_qqm_quotes_availability_ratio: product_valuations_qqm_quotes_availability_ratio\n product_valuations_qqm_spreads_availability_ratio: product_valuations_qqm_spreads_availability_ratio\n product_valuations_ratings_risk_classcode: product_valuations_ratings_risk_classcode\n product_valuations_ratings_risk_value: product_valuations_ratings_risk_value\n product_valuations_redemption_max: product_valuations_redemption_max\n product_valuations_rho: product_valuations_rho\n product_valuations_sideward_yield: product_valuations_sideward_yield\n product_valuations_sideward_yield_pa: product_valuations_sideward_yield_pa\n product_valuations_spread_average: product_valuations_spread_average\n product_valuations_spread_homo: product_valuations_spread_homo\n product_valuations_spread_percent: product_valuations_spread_percent\n product_valuations_strikesensitivity: product_valuations_strikesensitivity\n product_valuations_theta_1day: product_valuations_theta_1day\n product_valuations_theta_7days: product_valuations_theta_7days\n product_valuations_timevalue: product_valuations_timevalue\n product_valuations_turnover_chf_average: product_valuations_turnover_chf_average\n product_valuations_underperformance_level: product_valuations_underperformance_level\n product_valuations_vega: product_valuations_vega\n product_valuations_yield_max: product_valuations_yield_max\n product_valuations_yield_max_pa: product_valuations_yield_max_pa\n underlying_component_currency: underlying_component_currency\n underlying_component_isin: underlying_component_isin\n underlying_component_name: underlying_component_name\n underlying_component_price: underlying_component_price\n underlying_component_strike_1_activation_date: underlying_component_strike_1_activation_date\n underlying_component_strike_1_distance: underlying_component_strike_1_distance\n underlying_component_strike_1_distance_percent: underlying_component_strike_1_distance_percent\n underlying_component_strike_1_isknocked: underlying_component_strike_1_isknocked\n underlying_component_strike_2_activation_date: underlying_component_strike_2_activation_date\n underlying_component_strike_2_distance: underlying_component_strike_2_distance\n underlying_component_strike_2_distance_percent: underlying_component_strike_2_distance_percent\n underlying_component_strike_2_isknocked: underlying_component_strike_2_isknocked\n underlying_component_strike_3_activation_date: underlying_component_strike_3_activation_date\n underlying_component_strike_3_distance: underlying_component_strike_3_distance\n underlying_component_strike_3_distance_percent: underlying_component_strike_3_distance_percent\n underlying_component_strike_3_isknocked: underlying_component_strike_3_isknocked\n underlying_component_strike_4_activation_date: underlying_component_strike_4_activation_date\n underlying_component_strike_4_distance: underlying_component_strike_4_distance\n underlying_component_strike_4_distance_percent: underlying_component_strike_4_distance_percent\n underlying_component_strike_4_isknocked: underlying_component_strike_4_isknocked\n underlying_component_symbol: underlying_component_symbol\n underlying_id: underlying_id\n underlying_product_id: underlying_product_id\n underlying_valuations_histvola_180days: underlying_valuations_histvola_180days\n underlying_valuations_histvola_30days: underlying_valuations_histvola_30days\n underlying_valuations_histvola_90days: underlying_valuations_histvola_90days\n migration_dependencies: { }\n """