Skip to main content

Community

Destination Improvement: Optimize the queries written by HVR to load data to Google BigQuery

Please sign in to leave a comment.

Comments

1 comment

    Hi Samyak,

    There is an argument that the BigQuery query optimizer should be smart enough to recognize the ability to use partitioning with the way HVR generated this query.

    However, I also think that it would generally be cleaner if we uplifted the restriction on the driving table out of the sub query.

    Let me discuss with engineering whether we can do this easily.

    Thanks,
    Mark.