Create DatafusionPipelineStateSensor

[turbaszek]

Description

Create a sensor that will wait for Cloud Datafusion pipeline to be in expected state.

Use case / motivation

Originally posted by @jaketf in #8954 (comment)

Related Issues

#8673

[turbaszek]

@mik-laj what is the reason to close this issue? Was this sensors implemented?

[mik-laj]

it felt like it was finished. I saw the related PR that is closed.

[turbaszek]

The PR fixed the operator that works in a synchronous manner. This ticket is about creating a sensors and allowing async mode in DatafusionCreatePipelineOperator similar to #10673

[eladkal]

functionality added in #17787