Add support for Automations

[TaliaSRTR]

It would be convenient to be able to manage these resources like Automations and Service Accounts via the Terraform provider. Managing them via code as opposed to the UI (or even the API) would be nice because these kinds of resources are often:

1. Relatively static
2. Configured very similarly from one to the next, and so would lend themselves to being built out via custom Terraform modules

In the case of Service Accounts, these objects also generate sensitive output that needs to be pushed to other secrets stores like AWS Secrets Manager, for example. Making changes to these resources (e.g. refreshing API tokens) and having the changes instantly propagated to your secrets vault/manager of choice would remove some of the tedium of having to do this kind of stuff manually.

[parkedwards]

Great connecting today - we'll kick tires on Automations, and Service Accounts were added in #49, with key rotation handled in #73

[dacreify]

Automations would be extremely valuable. For example, configuring notifications for flows that run longer than expected in a standardized and reusable way.

[taylor-curran]

I have another customer strongly asking for automations to be supported by the terraform provider.

[mitchnielsen]

With Service Accounts addressed in #27 and #80, I'm going to modify the issue title to focus on Automations so we can track this more accurately 👍🏼

[mitchnielsen]

As a breadcrumb, Eddie has created #177 to scope the work to add this.

[parkedwards]

released in v2.8.0

https://registry.terraform.io/providers/PrefectHQ/prefect/latest/docs/resources/automation