style: fix ruff issues (#2172)

Introduce sleep in tests to avoid bigquery rate limits (#2110)

We're encountering difficulties achieving success with the 
integration test `test_aql_replace_existing_table` in our CI
environment.
The issue stems from `Google BigQuery` imposing rate limits on table 
operations—specifically, restricting them to `5` per `10` seconds per
table.
As a consequence, our CI pipeline fails, thereby hindering the release
of
version `1.18.0.`
The rate limits are documented here: 
https://cloud.google.com/bigquery/quotas#standard_tables

Initially, I contemplated skipping this test in CI. However,
implementing
a `10s` sleep for the problematic `BigQuery` test appears to 
circumvent the rate limit error, resulting in a fully successful CI
build.

I will cherrypick this PR in the release branch.

Bump up version to 1.7.0

Update constraints for Astro SDK 1.7.0

Update the changelog

Release 1.6.1 (#1947)

Bug Fixes
* Fix AstroCustomXcomBackend circular import issue.
#1943

Release 1.5.4 (#1944)

Bug Fixes
- Fix AstroCustomXcomBackend circular import issue.
[#1943](#1943)

Release Python SDK 1.7.0a1

Release 1.6.0

Update constraints for Astro SDK 1.6.0