code: def test_get_table_schemas_with_mixed_schemas():
      hook = MagicMock()
      ANOTHER_DB_SCHEMA_NAME = "ANOTHER_DB_SCHEMA"
  
      rows = [
          (DB_SCHEMA_NAME, DB_TABLE_NAME.name, "ID", 1, "int4"),
          (DB_SCHEMA_NAME, DB_TABLE_NAME.name, "AMOUNT_OFF", 2, "int4"),
          (
              DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "CUSTOMER_EMAIL",
              3,
              "varchar",
          ),
          (
              DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "STARTS_ON",
              4,
              "timestamp",
          ),
          (
              DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "ENDS_ON",
              5,
              "timestamp",
          ),
          (ANOTHER_DB_SCHEMA_NAME, DB_TABLE_NAME.name, "ID", 1, "int4"),
          (
              ANOTHER_DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "AMOUNT_OFF",
              2,
              "int4",
          ),
          (
              ANOTHER_DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "CUSTOMER_EMAIL",
              3,
              "varchar",
          ),
          (
              ANOTHER_DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "STARTS_ON",
              4,
              "timestamp",
          ),
          (
              ANOTHER_DB_SCHEMA_NAME,
              DB_TABLE_NAME.name,
              "ENDS_ON",
              5,
              "timestamp",
          ),
      ]
  
      hook.get_conn.return_value.cursor.return_value.fetchall.side_effect = [
          rows,
          [],
      ]
  
      table_schemas = get_table_schemas(
          hook=hook,
          namespace="bigquery",
          database=DB_NAME,
          schema=DB_SCHEMA_NAME,
          in_query="fake_sql",
          out_query="another_fake_sql",
      )
  
      assert table_schemas == (
          [
              Dataset(
                  namespace="bigquery",
                  name="FOOD_DELIVERY.PUBLIC.DISCOUNTS",
                  facets={"schema": SCHEMA_FACET},
              ),
              Dataset(
                  namespace="bigquery",
                  name="FOOD_DELIVERY.ANOTHER_DB_SCHEMA.DISCOUNTS",
                  facets={"schema": SCHEMA_FACET},
              ),
          ],
          [],
      )
  
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 3 for calling a global function with example usage: test_get_table_schemas_with_mixed_schemas() without return types