Skip to main content

​
Columns

ColumnDescriptionAPI Field Name
buyer_idPrimary key and buyer unique identifier.id
createdThe timestamp when the buyer record was created.
modifiedThe timestamp when the buyer record was last modified.
is_deletedIndicates whether the buyer record is deleted.
nameThe display name of the buyer.name
cityThe city where the buyer is located.city
stateThe state where the buyer is located.state
postalcodeThe postal code of the buyer’s location.postalcode
location_idThe corporate location identifier associated with this buyer.location_id
last_updatedThe timestamp when the buyer record was last updated.
vetcove_corporate_idThe unique identifier of the corporate group associated with this record.

​
SQL Definition

/*
    This model provides a business-ready, denormalized view of buyer data
    mirroring the buyer API.
*/

"
    )
}}

with buyer as (
    select * from {{ ref('buyer') }}
)

select
    buyer.id as buyer_id
    , buyer.created
    , buyer.modified
    , buyer.is_deleted
    , buyer.name
    , buyer.city
    , buyer.state
    , buyer.postalcode
    , buyer.location_id
    , buyer.last_updated
    , buyer.vetcove_corporate_id
from buyer