text: 
    create view "test"."public"."stg_payments__dbt_tmp" as (
      with source as (
      select * from "test"."public"."raw_payments"
  
  ),
  
  renamed as (
  
      select
          id as payment_id,
          order_id,
          payment_method,
  
          --`amount` is currently stored in cents, so we convert it to dollars
          amount / 100 as amount
  
      from source
  
  )
  
  select * from renamed
    );
  