Redshift Load Errors

load_errors.yml

- explore: etl_errors
  label: 'ETL Errors'
  hidden: true
- view: etl_errors
  derived_table:
    sql: |
      select distinct errors.starttime as error_time
        , detail.filename as file_name
        , errors.err_reason
      from stl_loaderror_detail as detail, stl_load_errors as errors
      where detail.query = errors.query
  fields:

  - dimension_group: error
    type: time
    timeframes: [time, date]
    sql: ${TABLE}.error_time

  - dimension: file_name
    type: string
    sql: ${TABLE}.file_name

  - dimension: error_reason
    type: string
    sql: ${TABLE}.err_reason