The table ID column in INFORMATION_SCHEMA.PARTITIONS is named table_name, not table_id (currently when these queries run they fail with the error "_Unrecognized name: tableid").
The table ID string value needs to be quoted in the SQL.
related: #37655
^ Add meaningful description above
Read the Pull Request Guidelines for more information.
In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
In case of a new dependency, check compliance with the ASF 3rd Party License Policy.
In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in newsfragments.
INFORMATION_SCHEMA.PARTITIONSis namedtable_name, nottable_id(currently when these queries run they fail with the error "_Unrecognized name: tableid").related: #37655
^ Add meaningful description above Read the Pull Request Guidelines for more information. In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed. In case of a new dependency, check compliance with the ASF 3rd Party License Policy. In case of backwards incompatible changes please leave a note in a newsfragment file, named
{pr_number}.significant.rstor{issue_number}.significant.rst, in newsfragments.