[FEATURE] Add subscriptions to SQL Alert job tasks

[orolega]

Use-cases

Currently there is no way of adding subscriptions (destinations and users) to an alert itself. This must be done via the GUI. However API also does not appear to have this functionality for alerts. There are SQL alert tasks in a job where you can also define subscriptions. These jobs also allow you to schedule when to check the alert (feature also missing on just an alert object in the api and thus terraform). However still lacks the ability to define those subscriptions in the terraform resource. It is possible to define them if creating the job via the API.

So ultimately the use case is being able to add subscriptions to alerts beyond just the creator of them.

Attempted Solutions

No solution possible given existing features. Must use the API directly

Proposal

Enable the functionality of the Job API that adds subscriptions to the existing SQL Alert Task resource

References

[alexott]

duplicate of #1983

[orolega]

duplicate of #1983

Not a duplicate given what I am proposing does have an API endpoint. You claim it does not.

TBH I think its just adding the subscriptions object here

from the API documentation. Sorry the formatting is off:

alert object

If alert, indicates that this job must refresh a SQL alert.

alert_id required string

The canonical identifier of the SQL alert.

subscriptions

Array of objects

If specified, alert notifications are sent to subscribers.

Array

user_name string

The user name to receive the subscription email.

destination_id string

The canonical identifier of the destination to receive email notification.

pause_subscriptions boolean

If true, the alert notifications are not sent to subscribers.

[orolega]

definitely not a duplicate. The other ticket is about creating a destination. I am requesting assigning an existing one to the list of subscriptions when creating a SQL alert task. See the below screen cap

[orolega]

Currently the terraform resource only has alert - (Optional) block consisting of single string field: alert_id - identifier of the Databricks SQL Alert.

subscriptions and pause_subscriptions should be added per the API

[alexott]

ah, sorry - misread it...

[orolega]

beat me to a PR. spent some time yesterday figuring this out. Was trying to test the binary locally to be sure... Anyways, thanks for solving this!

[alexott]

for development you can use this approach: https://developer.hashicorp.com/terraform/cli/config/config-file#development-overrides-for-provider-developers

but frankly speaking, we had some problems with docs, so it would be hard to get it correct using only the api spec.