How We Cut BigQuery Slot Usage by 90% On One Of Our Most Resource Hungry Service After An Outage

How We Cut BigQuery Slot Usage by 90% On One Of Our Most Resource Hungry Service After a Production Outage At Teads, one of our most important internal tools is the Audience Planning service. Its job is simple to explain: before an advertising campaign goes live, advertisers and operators need to know whether the campaign can realistically be delivered. If they target France, mobile web, a specific audience segment, and exclude another audience, how many ad impressions are available?