egorsmkv / export-facebook-insights-to-bigquery Goto Github PK

BEGIN
    BEGIN TRANSACTION;
        MERGE `{bigquery_table_main}` tmain 
        USING `{bigquery_table_raw}` traw ON tmain.ad_id = traw.id 
        WHEN MATCHED THEN UPDATE SET value = traw.value WHEN NOT MATCHED THEN INSERT

        INSERT INTO 
        (ad_id,adset_id,campaign_id,impressions,reach,spend,clicks,conversions,date_start,date_stop)
            VALUES
        ("{ad_id}", "{adset_id}", "{campaign_id}", {impressions}, {reach}, {spend}, {clicks}, {conversions}, "{date_start}", "{date_stop}");
    COMMIT TRANSACTION;

    EXCEPTION WHEN ERROR THEN
        SELECT @@error.message;
    ROLLBACK TRANSACTION;
END;