Materialize/misc/dbt-materialize/dbt/include/starter_project/models/example/winning_bids.sql

-- Copyright Materialize, Inc. and contributors. All rights reserved.
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License in the LICENSE file at the
-- root of this repository, or online at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.

{{ config(materialized='view', indexes=[{'columns': 'item'}, {'columns': 'buyer'}, {'columns': 'seller'}]) }}

SELECT DISTINCT ON
  (auctions.id) bids.*,
  auctions.item,
  auctions.seller
FROM {{ source('auction','auctions') }}
JOIN {{ source('auction','bids') }} ON auctions.id = bids.auction_id
WHERE bids.bid_time < auctions.end_time
  AND mz_now() >= auctions.end_time