code: def test_create_create_information_schema_query_cross_db():
      columns = [
          "table_schema",
          "table_name",
          "column_name",
          "ordinal_position",
          "data_type",
      ]
  
      assert (
          create_information_schema_query(
              columns=columns,
              information_schema_table_name="information_schema.columns",
              tables_hierarchy={
                  "db": {"schema1": ["table1"]},
                  "db2": {"schema1": ["table2"]},
              },
          )
          == "SELECT db.information_schema.columns.table_schema, db.information_schema.columns.table_name, "
          "db.information_schema.columns.column_name, db.information_schema.columns.ordinal_position, "
          "db.information_schema.columns.data_type \n"
          "FROM db.information_schema.columns \n"
          "WHERE db.information_schema.columns.table_schema = 'schema1' "
          "AND db.information_schema.columns.table_name IN ('table1') "
          "UNION ALL "
          "SELECT db2.information_schema.columns.table_schema, db2.information_schema.columns.table_name, "
          "db2.information_schema.columns.column_name, db2.information_schema.columns.ordinal_position, "
          "db2.information_schema.columns.data_type \n"
          "FROM db2.information_schema.columns \n"
          "WHERE db2.information_schema.columns.table_schema = 'schema1' "
          "AND db2.information_schema.columns.table_name IN ('table2')"
      )
  
file_path: airflow/tests/providers/openlineage/utils/test_sql.py
imports: from __future__ import annotations
  from unittest.mock import MagicMock
  import pytest
  from openlineage.client.facet import SchemaDatasetFacet, SchemaField, set_producer
  from openlineage.client.run import Dataset
  from openlineage.common.models import DbColumn, DbTableSchema
  from openlineage.common.sql import DbTableMeta
  from sqlalchemy import Column, MetaData, Table
  from airflow.providers.openlineage import __version__
  from airflow.providers.openlineage.utils.sql import create_filter_clauses, create_information_schema_query, get_table_schemas
label_desc: Use image node_id 7 for calling a global function with example usage: test_create_create_information_schema_query_cross_db() without return types