fix serivce_area_pricing_daily when missing date

PHOTO EMBED

Sun Jul 18 2021 22:16:03 GMT+0000 (UTC)

Saved by @alvaroferrer #sql #bigquery

INSERT `reby-cloud.analytics_reby_v1_eu.service_area_pricing_daily`
    (date, name, company_id,service_area_id,vehicle_type,price_per_minute,
    price_base_amount,original_price_per_minute,original_price_base_amount)
SELECT date('2021-07-17'), name, company_id,service_area_id,vehicle_type,price_per_minute,
    price_base_amount,original_price_per_minute,original_price_base_amount
FROM `reby-cloud.analytics_reby_v1_eu.service_area_pricing_daily`
where date = '2021-07-18'
content_copyCOPY