text: WITH source AS (
  
      SELECT *
      FROM {{ source('gitlab_dotcom', 'design_management_designs') }}
      QUALIFY ROW_NUMBER() OVER (PARTITION BY id ORDER BY _uploaded_at DESC) = 1
  
  ), renamed AS (
  
      SELECT
        id::NUMBER                                 AS design_id,
        project_id::NUMBER                         AS project_id,
        issue_id::NUMBER                           AS issue_id,
        filename::VARCHAR                           AS design_filename
      FROM source
  
  )
  
  SELECT *
  FROM renamed
  