old_contents: #
  # Licensed to the Apache Software Foundation (ASF) under one
  # or more contributor license agreements.  See the NOTICE file
  # distributed with this work for additional information
  # regarding copyright ownership.  The ASF licenses this file
  # to you under the Apache License, Version 2.0 (the
  # "License"); you may not use this file except in compliance
  # with the License.  You may obtain a copy of the License at
  #
  #   http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing,
  # software distributed under the License is distributed on an
  # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  # KIND, either express or implied.  See the License for the
  # specific language governing permissions and limitations
  # under the License.
  """System tests for Google BigQuery hooks"""
  
  import unittest
  
  import pytest
  
  from airflow.providers.google.cloud.hooks import bigquery as hook
  from tests.providers.google.cloud.utils.gcp_authenticator import GCP_BIGQUERY_KEY
  
  
  @pytest.mark.system("google.cloud")
  @pytest.mark.credential_file(GCP_BIGQUERY_KEY)
  class BigQueryDataframeResultsSystemTest(unittest.TestCase):
      def setUp(self):
          self.instance = hook.BigQueryHook()
  
      def test_output_is_dataframe_with_valid_query(self):
          import pandas as pd
  
          df = self.instance.get_pandas_df('select 1')
          assert isinstance(df, pd.DataFrame)
  
      def test_throws_exception_with_invalid_query(self):
          with pytest.raises(Exception) as ctx:
              self.instance.get_pandas_df('from `1`')
          assert 'Reason: ' in str(ctx.value), ""
  
      def test_succeeds_with_explicit_legacy_query(self):
          df = self.instance.get_pandas_df('select 1', dialect='legacy')
          assert df.iloc(0)[0][0] == 1
  
      def test_succeeds_with_explicit_std_query(self):
          df = self.instance.get_pandas_df('select * except(b) from (select 1 a, 2 b)', dialect='standard')
          assert df.iloc(0)[0][0] == 1
  
      def test_throws_exception_with_incompatible_syntax(self):
          with pytest.raises(Exception) as ctx:
              self.instance.get_pandas_df('select * except(b) from (select 1 a, 2 b)', dialect='legacy')
          assert 'Reason: ' in str(ctx.value), ""
  
new_contents: #
  # Licensed to the Apache Software Foundation (ASF) under one
  # or more contributor license agreements.  See the NOTICE file
  # distributed with this work for additional information
  # regarding copyright ownership.  The ASF licenses this file
  # to you under the Apache License, Version 2.0 (the
  # "License"); you may not use this file except in compliance
  # with the License.  You may obtain a copy of the License at
  #
  #   http://www.apache.org/licenses/LICENSE-2.0
  #
  # Unless required by applicable law or agreed to in writing,
  # software distributed under the License is distributed on an
  # "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  # KIND, either express or implied.  See the License for the
  # specific language governing permissions and limitations
  # under the License.
  """System tests for Google BigQuery hooks"""
  
  import pytest
  
  from airflow.providers.google.cloud.hooks import bigquery as hook
  from tests.providers.google.cloud.utils.gcp_authenticator import GCP_BIGQUERY_KEY
  from tests.test_utils.gcp_system_helpers import GoogleSystemTest
  
  
  @pytest.mark.system("google.cloud")
  @pytest.mark.credential_file(GCP_BIGQUERY_KEY)
  class BigQueryDataframeResultsSystemTest(GoogleSystemTest):
      def setUp(self):
          self.instance = hook.BigQueryHook()
  
      def test_output_is_dataframe_with_valid_query(self):
          import pandas as pd
  
          df = self.instance.get_pandas_df('select 1')
          assert isinstance(df, pd.DataFrame)
  
      def test_throws_exception_with_invalid_query(self):
          with pytest.raises(Exception) as ctx:
              self.instance.get_pandas_df('from `1`')
          assert 'Reason: ' in str(ctx.value), ""
  
      def test_succeeds_with_explicit_legacy_query(self):
          df = self.instance.get_pandas_df('select 1', dialect='legacy')
          assert df.iloc(0)[0][0] == 1
  
      def test_succeeds_with_explicit_std_query(self):
          df = self.instance.get_pandas_df('select * except(b) from (select 1 a, 2 b)', dialect='standard')
          assert df.iloc(0)[0][0] == 1
  
      def test_throws_exception_with_incompatible_syntax(self):
          with pytest.raises(Exception) as ctx:
              self.instance.get_pandas_df('select * except(b) from (select 1 a, 2 b)', dialect='legacy')
          assert 'Reason: ' in str(ctx.value), ""
  
subject: Fix BQ hook system test (#13944)