https://prefect.io
Join Slack
I know the UI shows upcoming runs that are late; however, is there any way to find historical runs t...
# prefect-ui
k
I know the UI shows upcoming runs that are late; however, is there any way to find historical runs that were late?
k
I don’t think there is a view in the UI. You would need to use the GraphQL API and check for the start time being later than the scheduled time
👍 1
k
@Kevin Kho I’m kind of new to GraphQL/Hasura/etc. I can’t seem to find/figure out how to compare a field to another. Have you ever done this before by chance?
k
I think you need to bring the query results to Python and then do the comparison there because you can’t in the query. Am looking through the UI code. Let me verify.
k
Gotcha, I could query for flow runs for the past x timeframe, then check the data in memory.
k
I checked and I think I’m right. You can use the 
client.graphql
to just do a simple query on flows with something like:
Copy code
query {
  flow {
    flow_runs {
      start_time
      scheduled_start_time
    }
  }
}
and then process the results in Python
🙏 1
Open in Slack
PreviousNext
Powered by

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Powered by