Question

Has anyone successfully created a View for Redshift stl_load_errors table?

  • 11 February 2021
  • 0 replies
  • 11 views

I want to analyze the errors we are getting in our Redshift stl_load_errors table.

In my development environment (Aginity) running as root, I see many entries with “SELECT * FROM stl_load_errors”

Then I created a View (see below), and it runs without any errors, however the PDT it creates is empty.

I also tried it as just a simple table with the same result - when I create an Explore it returns No Results

I also did it with the fully qualified name:  pg_catalog.stl_load_errors and still Not Results

I thought it might be a permissions issue, so I ran “GRANT SELECT ON pg_catalog.stl_load_errors TO looker;” - but I still get No Results

There doesn’t seem to be any issue with syntax or formatting, only I am just not getting any data.

Has anyone every successfully created a Redshift stl_load_errors View?

Thanks,

    --Chris

 

view: stl_load_errors_pdt {
    derived_table:  {

        sql: SELECT * FROM stl_load_errors ;;

        sql_trigger_value: select to_char( max( getDate() ), 'YYYY-MM-DD-HH24' ) ;;

        distribution: "query"

         sortkeys: ["starttime"]

    }

    -- Dimensions omitted

    -- Measures omitted

}

 

view: stl_load_errors {
  sql_table_name: stl_load_errors ;;

    -- Dimensions omitted

    -- Measures omitted

}

 

view: stl_load_errors2 {
  sql_table_name: pg_catalog.stl_load_errors ;;

    -- Dimensions omitted

    -- Measures omitted

}


0 replies

Be the first to reply!

Reply