{{ config(materialized='view') }}

SELECT
  SAFE_CAST(CUS_CUST_ID AS INT64)                AS cus_cust_id_int,
  UPPER(TRIM(ADD_STATE_NAME_SHP))                AS seller_state,
  UPPER(TRIM(SIT_SITE_ID))                       AS seller_site_id
FROM {{ source('meli_case_raw','raw_sellers_data_ext') }}
WHERE CUS_CUST_ID IS NOT NULL
