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
}