BigQueryInsertJobOperator broken

[DrStriky]

Apache Airflow Provider(s)

google

Versions of Apache Airflow Providers

7.0.0

Apache Airflow version

2.2.5

Operating System

google composer

Deployment

Composer

Deployment details

No response

What happened

BigQueryInsertJobOperator can not be used to run SQL query without specifying destination table explicitly in the operator

"query": {
                "query": f"""
                          INSERT INTO `{{{{params.project}}}}-{os.getenv('COMPOSER_ENVIRONMENT_STAGE')}.{{{{params.dataset}}}}.{{{{params.table_order_objects}}}}`
                          SELECT
                              *
                          FROM
                              `{{{{params.project}}}}-{os.getenv('COMPOSER_ENVIRONMENT_STAGE')}.{{{{params.dataset}}}}.{{{{params.table_order_objects}}}}_SZ`;
                          TRUNCATE TABLE `{{{{params.project}}}}-{os.getenv('COMPOSER_ENVIRONMENT_STAGE')}.{{{{params.dataset}}}}.{{{{params.table_order_objects}}}}_SZ`;
                          """,
                "useLegacySql": False,
            }

Traceback (most recent call last):
  File "/opt/python3.8/lib/python3.8/site-packages/airflow/providers/google/cloud/operators/bigquery.py", line 2269, in execute
    table = job.to_api_repr()["configuration"]["query"]["destinationTable"]

What you think should happen instead

To run a SQL a destination is not necessary to be specified

How to reproduce

Airflow 2.2.5 and airflow provider 7.0.0, BigQueryInsertJobOperator without specifying destinationTable

Anything else

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template!

[eladkal]

Duplicate #23826