Issue 1:
This is the second attempt (rc2) of releasing July Providers :). I carried over the "checkmarks" from the last testing (#17037) so there is no need to re-test those.

I have a kind request for all the contributors to the latest provider packages release.

Could you help us to test the RC versions of the providers and let us know in the comment, if the issue is addressed there.

Providers that need testing

Those are providers that require testing as there were some substantial changes introduced:

Provider airbyte: 2.1.0rc2

Fixed wrongly escaped characters in amazon's changelog (#17020): @potiuk

Provider amazon: 2.1.0rc2

Allow attaching to previously launched task in ECSOperator (#16685): @pmalafosse

Update AWS Base hook to use refreshable credentials (#16770) (#16771): @baolsen

Added select_query to the templated fields in RedshiftToS3Operator (#16767): @hewe

AWS Hook - allow IDP HTTP retry (#12639) (#16612): @baolsen

Update Boto3 API calls in ECSOperator (#16050): @scottypate

Adding custom Salesforce connection type + SalesforceToS3Operator updates (#17162): @josh-fell

Adding SalesforceToS3Operator to Amazon Provider (#17094): @josh-fell

AWS DataSync Operator does not cancel task on Exception (#11011): @baolsen

Fix wrong template_fields_renderers for AWS operators (#16820): @codenamestif

AWS DataSync cancel task on exception (#11011) (#16589): @baolsen

Fixed template_fields_renderers for Amazon provider (#17087): @oyarushe

removing try-catch block to fix timeout exception getting ignored in aws batch operator (#17081): @ayushchauhan0811

ECSOperator / pass context to self.xcom_pull as it was missing (when using reattach) (#17141): @pmalafosse

Made S3ToRedshiftOperator transaction safe (#17117): @oyarushe

Provider apache.druid: 2.0.1rc2

Fix error in Druid connection attribute retrieval (#17095): @potiuk

Provider apache.hive: 2.0.1rc2

Add python 3.9 (#15515): @potiuk

Provider apache.spark: 2.0.0rc2

Make SparkSqlHook use Connection (#15794): @uranusjr

Provider apache.sqoop: 2.0.1rc2

Fix Minor Bugs in Apache Sqoop Hook and Operator (#16350): @ciancolo

Provider cncf.kubernetes: 2.0.1rc2

BugFix: Using json string in template_field fails with K8s Operators (#16930): @kaxil

Provider dingding: 2.0.0rc2

Fix hooks extended from http hook (#16109): @msumit

Provider discord: 2.0.0rc2

Fix hooks extended from http hook (#16109): @msumit

Provider docker: 2.1.0rc2

Adds option to disable mounting temporary folder in DockerOperator (#16932): @potiuk

[FIX] Docker provider - retry docker in docker (#17061): @raphaelauv

Fix string encoding in DockerOperator when using xcom / json (#13536): @AlessioM

Provider google: 5.0.0rc2

apache-airflow-providers-google: google-ads-12.0.0 (#17111): @rv-irosario

Google Ads Hook: Support newer versions of the google-ads library (#17160): @infused-kim

Standardise dataproc location param to region (#16034): @Daniel-Han-Yang

Adding custom Salesforce connection type + SalesforceToS3Operator updates (#17162): @josh-fell

Update alias for field_mask in Google Memmcache (#16975): @potiuk

fix: get_cluster call project_id as self.project_id (#17075): @iostreamdoth

Fix GCStoGCS operator with replace diabled and existing destination object (#16991): @aslantar

Provider hashicorp: 2.0.0rc2

Sanitize end of line character when loading token from a file (vault) (#16407): @mmenarguezpear

Provider http: 2.0.0rc2

Update SimpleHttpOperator to take auth type object (#15605): @fredthomsen

HttpHook. Use request factory and respect defaults (#14701): @ngaranko

Provider jenkins: 2.0.1rc2

Fixed to check number key from jenkins response (#16963): @namjals

Provider microsoft.azure: 3.1.0rc2

Add support for managed identity in WASB hook (#16628): @malthe

WASB hook: reduce log messages for happy path (#16626): @malthe

Fix multiple issues in Microsoft AzureContainerInstancesOperator (#15634): @BKronenbitter

Provider mysql: 2.1.0rc2

Added template_fields_renderers for MySQL Operator (#16914): @oyarushe

Extended template_fields_renderers for MySQL provider (#16987): @oyarushe

Parse JSON template parameters field for MySQL operator (#17080): @oyarushe

Provider odbc: 2.0.0rc2

OdbcHook returns None. Related to #15016 issue. (#15510): @Goodkat

Fix OdbcHook handling of port (#15772): @dstandish

Provider opsgenie: 2.0.0rc2

Fix hooks extended from http hook (#16109): @msumit

Provider oracle: 2.0.0rc2

Add optional result handler to database hooks (#15581): @malthe

[Oracle] Add port to DSN (#15589): @malthe

Add link to Oracle Connection Docs (#15632): @sunkickr

Provider papermill: 2.0.0rc2

Emit error on duplicated DAG ID (#15302): @uranusjr

Provider plexus: 2.0.0rc2

Removes arrow higher limits for plexus provider (#16026): @potiuk

Provider postgres: 2.1.0rc2

Add schema override in DbApiHook (#16521): @LukeHong

Provider qubole: 2.0.0rc2

Qubole Hook Does Not Support 'include_headers' (#15598): @levyitay

Feature qubole hook support headers (#15683): @levyitay

Feature qubole hook support headers (#15615): @levyitay

Provider samba: 2.0.0rc2

Add support for extra parameters to samba client (#16115): @malthe

Provider salesforce: 3.1.0rc2

Adding custom Salesforce connection type + SalesforceToS3Operator updates (#17162): @josh-fell

Provider sftp: 2.1.0rc2

Add support for non-RSA type client host key (#16314): @malthe

Provider slack: 4.0.0rc2

Fix hooks extended from http hook (#16109): @msumit

Provider snowflake: 2.1.0rc2

Adding: Snowflake Role in snowflake provider hook (#16735): @saurasingh

Provider ssh: 2.1.0rc2

Add support for non-RSA type client host key (#16314): @malthe

SSHHook: Using correct hostname for host_key when using non-default ssh port (#15964): @freget

Correctly load openssh-gerenated private keys in SSHHook (#16756): @ashb

Provider tableau: 2.1.0rc2

Allow disable SSL for TableauHook (#16365): @ciancolo

Deprecate Tableau personal token authentication (#16916): @samgans

Fix bool conversion Verify parameter in Tableau Hook (#17125): @ciancolo

New Providers

apache.drill: 1.0.0rc1 @dzamo

Issue 2:
Discussed in #23220

Originally posted by yashk97 April 25, 2022

Hi,

My use case is in case multiple DAG Runs fail on some task (not the same one in all of them), I want to individually re-trigger each of these DAG Runs. Currently, I have to rely on the Airflow UI (attached screenshots) where I select the failed task and clear its state (along with the downstream tasks) to re-run from that point. While this works, it becomes tedious if the number of failed DAG runs is huge.

I checked the REST API Documentation and came across the clear Task Instances API with the following URL: /api/v1/dags/{dag_id}/clearTaskInstances

However, it filters task instances of the specified DAG in a given date range.

I was wondering if, for a specified DAG Run, we can clear a task along with its downstream tasks irrespective of the states of the tasks or the DAG run through REST API.

This will give us more granular control over re-running DAGs from the point of failure.