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.

Prefect Community

Hi - sorry to keep peppering yall with questions about the automations api. I'm trying to add/configure automations into my flow deployment process. I've gotten it figured out with state change automations, but I'm struggling with SLA automations. Basically, I'm trying to write a query to see if a SLA automation already exists for a given flow_group_id and if it does not, I will create the flow_sla_config, and then the flow_sla_failed_hook.

So my question is, how can I query if a flow_sla_config exists for a given flow (using the flow_group_id)?

conceptually - I think what I'm struggling with is what the relationship is between "flow_groups" which is an argument in the `flow_sla_config` query, and "flow_group_id"

never-mind, I figured it out. It's `flow_group_sla` that I should query to see if the the sla rule exists for the flow_group_id and you enforce uniqueness on this to begin with