Improve how we authorise non-commiters to run Cosmos integration tests

[tatiana]

At the moment, Cosmos committers have to approve changes on a PR per commit to be able to run the integration tests.

It would be great if we looked into being able to approve once per PR, e.g., by adding a label "safe to test":

• https://github.com/astronomer/astro-provider-databricks/blob/main/.github/workflows/ci.yml

Apache Airflow also has this behaviour.

This would add less maintenance overhead to committers and allow the community to iterate faster

Approving per PR rather than per commit could have security implications, but it may be worth the change.

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.