prompt: We are currently solving the following issue within our repository. Here is the issue text:
  --- BEGIN ISSUE ---
  get_validator method do not work
  Hello!
  I have a problem with get_validator component.
  
  Here’s my code:
  ```
  batch_request = BatchRequest(
      datasource_name="redshift_",
      data_connector_name="default_inferred_data_connector_name",
      data_asset_name="daily_chargeback_table_v1",  # this is the name of the table you want to retrieve
  )
  context.create_expectation_suite(
      expectation_suite_name="test_suite", overwrite_existing=True
  )
  validator = context.get_validator(
      batch_request=batch_request, expectation_suite_name="test_suite"
  )
  print(validator.head())
  ```
  
  I get this exception:
  ```
  ---------------------------------------------------------------------------
  TypeError                                 Traceback (most recent call last)
  <ipython-input-67-16f90e0aa558> in <module>
        8 )
        9 validator = context.get_validator(
  ---> 10     batch_request=batch_request, expectation_suite_name="test_suite"
       11 )
       12 print(validator.head())
  .
  .
  .
  
  ~/anaconda3/lib/python3.7/site-packages/great_expectations/execution_engine/sqlalchemy_execution_engine.py in _build_selectable_from_batch_spec(self, batch_spec)
      979                     )
      980                     .where(
  --> 981                         sa.and_(
      982                             split_clause,
      983                             sampler_fn(**batch_spec["sampling_kwargs"]),
  TypeError: table() got an unexpected keyword argument 'schema'
  ```
  
  My Datasource configuration like:
  ```
  name: redshift_
  class_name: Datasource
  execution_engine:
    class_name: SqlAlchemyExecutionEngine
    credentials:
      host: redshift_host
      port: '5443'
      username: username
      password: password
      database: dbname
      query:
        sslmode: prefer
      drivername: postgresql+psycopg2
  data_connectors:
    default_runtime_data_connector_name:
      class_name: RuntimeDataConnector
      batch_identifiers:
        - default_identifier_name
    default_inferred_data_connector_name:
      class_name: InferredAssetSqlDataConnector
      name: whole_table
  ```
  
  My environment:
  MacOS
  python 3.7.4
  great_expectations 0.13.34
  
  I will be grateful for any help.
  
  --- END ISSUE ---
  
  Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
  --- BEGIN FILES ---
  Path: `setup.py`
  Content:
  ```
  1 from setuptools import find_packages, setup
  2 
  3 import versioneer
  4 
  5 # Parse requirements.txt
  6 with open("requirements.txt") as f:
  7     required = f.read().splitlines()
  8 
  9 # try:
  10 #    import pypandoc
  11 #    long_description = pypandoc.convert_file('README.md', 'rst')
  12 # except (IOError, ImportError):
  13 long_description = "Always know what to expect from your data. (See https://github.com/great-expectations/great_expectations for full description)."
  14 
  15 config = {
  16     "description": "Always know what to expect from your data.",
  17     "author": "The Great Expectations Team",
  18     "url": "https://github.com/great-expectations/great_expectations",
  19     "author_email": "team@greatexpectations.io",
  20     "version": versioneer.get_version(),
  21     "cmdclass": versioneer.get_cmdclass(),
  22     "install_requires": required,
  23     "extras_require": {
  24         "spark": ["pyspark>=2.3.2"],
  25         "sqlalchemy": ["sqlalchemy>=1.3.16"],
  26         "airflow": ["apache-airflow[s3]>=1.9.0", "boto3>=1.7.3"],
  27         "gcp": [
  28             "google-cloud>=0.34.0",
  29             "google-cloud-storage>=1.28.0",
  30             "google-cloud-secret-manager>=1.0.0",
  31             "pybigquery==0.4.15",
  32         ],
  33         "redshift": ["psycopg2>=2.8"],
  34         "s3": ["boto3>=1.14"],
  35         "aws_secrets": ["boto3>=1.8.7"],
  36         "azure_secrets": ["azure-identity>=1.0.0", "azure-keyvault-secrets>=4.0.0"],
  37         "snowflake": ["snowflake-sqlalchemy>=1.2"],
  38     },
  39     "packages": find_packages(exclude=["contrib*", "docs*", "tests*", "examples*"]),
  40     "entry_points": {
  41         "console_scripts": ["great_expectations=great_expectations.cli:main"]
  42     },
  43     "name": "great_expectations",
  44     "long_description": long_description,
  45     "license": "Apache-2.0",
  46     "keywords": "data science testing pipeline data quality dataquality validation datavalidation",
  47     "include_package_data": True,
  48     "classifiers": [
  49         "Development Status :: 4 - Beta",
  50         "Intended Audience :: Developers",
  51         "Intended Audience :: Science/Research",
  52         "Intended Audience :: Other Audience",
  53         "Topic :: Scientific/Engineering",
  54         "Topic :: Software Development",
  55         "Topic :: Software Development :: Testing",
  56         "License :: OSI Approved :: Apache Software License",
  57         "Programming Language :: Python :: 3",
  58         "Programming Language :: Python :: 3.6",
  59         "Programming Language :: Python :: 3.7",
  60         "Programming Language :: Python :: 3.8",
  61         "Programming Language :: Python :: 3.9",
  62     ],
  63 }
  64 
  65 setup(**config)
  66
  ```
  --- END FILES ---
  
  Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.
  
  Here is an example:
  
  ```diff
  diff --git a/examples/server_async.py b/examples/server_async.py
  --- a/examples/server_async.py
  +++ b/examples/server_async.py
  @@ -313,4 +313,4 @@
   
   
   if __name__ == "__main__":
  -    asyncio.run(run_async_server("."), debug=True)
  +    asyncio.run(run_async_server(), debug=True)
  diff --git a/examples/server_sync.py b/examples/server_sync.py
  --- a/examples/server_sync.py
  +++ b/examples/server_sync.py
  @@ -313,5 +313,5 @@
   
   
   if __name__ == "__main__":
  -    server = run_sync_server(".")
  +    server = run_sync_server()
       server.shutdown()
  
  ```
  
golden_diff: diff --git a/setup.py b/setup.py
  --- a/setup.py
  +++ b/setup.py
  @@ -22,7 +22,7 @@
       "install_requires": required,
       "extras_require": {
           "spark": ["pyspark>=2.3.2"],
  -        "sqlalchemy": ["sqlalchemy>=1.3.16"],
  +        "sqlalchemy": ["sqlalchemy>=1.3.18"],
           "airflow": ["apache-airflow[s3]>=1.9.0", "boto3>=1.7.3"],
           "gcp": [
               "google-cloud>=0.34.0",
  
verification_info: {"golden_diff": "diff --git a/setup.py b/setup.py\n--- a/setup.py\n+++ b/setup.py\n@@ -22,7 +22,7 @@\n     \"install_requires\": required,\n     \"extras_require\": {\n         \"spark\": [\"pyspark>=2.3.2\"],\n-        \"sqlalchemy\": [\"sqlalchemy>=1.3.16\"],\n+        \"sqlalchemy\": [\"sqlalchemy>=1.3.18\"],\n         \"airflow\": [\"apache-airflow[s3]>=1.9.0\", \"boto3>=1.7.3\"],\n         \"gcp\": [\n             \"google-cloud>=0.34.0\",\n", "issue": "get_validator method do not work\nHello!\r\nI have a problem with get_validator component.\r\n\r\nHere\u2019s my code:\r\n```\r\nbatch_request = BatchRequest(\r\n    datasource_name=\"redshift_\",\r\n    data_connector_name=\"default_inferred_data_connector_name\",\r\n    data_asset_name=\"daily_chargeback_table_v1\",  # this is the name of the table you want to retrieve\r\n)\r\ncontext.create_expectation_suite(\r\n    expectation_suite_name=\"test_suite\", overwrite_existing=True\r\n)\r\nvalidator = context.get_validator(\r\n    batch_request=batch_request, expectation_suite_name=\"test_suite\"\r\n)\r\nprint(validator.head())\r\n```\r\n\r\nI get this exception:\r\n```\r\n---------------------------------------------------------------------------\r\nTypeError                                 Traceback (most recent call last)\r\n<ipython-input-67-16f90e0aa558> in <module>\r\n      8 )\r\n      9 validator = context.get_validator(\r\n---> 10     batch_request=batch_request, expectation_suite_name=\"test_suite\"\r\n     11 )\r\n     12 print(validator.head())\r\n.\r\n.\r\n.\r\n\r\n~/anaconda3/lib/python3.7/site-packages/great_expectations/execution_engine/sqlalchemy_execution_engine.py in _build_selectable_from_batch_spec(self, batch_spec)\r\n    979                     )\r\n    980                     .where(\r\n--> 981                         sa.and_(\r\n    982                             split_clause,\r\n    983                             sampler_fn(**batch_spec[\"sampling_kwargs\"]),\r\nTypeError: table() got an unexpected keyword argument 'schema'\r\n```\r\n\r\nMy Datasource configuration like:\r\n```\r\nname: redshift_\r\nclass_name: Datasource\r\nexecution_engine:\r\n  class_name: SqlAlchemyExecutionEngine\r\n  credentials:\r\n    host: redshift_host\r\n    port: '5443'\r\n    username: username\r\n    password: password\r\n    database: dbname\r\n    query:\r\n      sslmode: prefer\r\n    drivername: postgresql+psycopg2\r\ndata_connectors:\r\n  default_runtime_data_connector_name:\r\n    class_name: RuntimeDataConnector\r\n    batch_identifiers:\r\n      - default_identifier_name\r\n  default_inferred_data_connector_name:\r\n    class_name: InferredAssetSqlDataConnector\r\n    name: whole_table\r\n```\r\n\r\nMy environment:\r\nMacOS\r\npython 3.7.4\r\ngreat_expectations 0.13.34\r\n\r\nI will be grateful for any help.\n", "before_files": [{"content": "from setuptools import find_packages, setup\n\nimport versioneer\n\n# Parse requirements.txt\nwith open(\"requirements.txt\") as f:\n    required = f.read().splitlines()\n\n# try:\n#    import pypandoc\n#    long_description = pypandoc.convert_file('README.md', 'rst')\n# except (IOError, ImportError):\nlong_description = \"Always know what to expect from your data. (See https://github.com/great-expectations/great_expectations for full description).\"\n\nconfig = {\n    \"description\": \"Always know what to expect from your data.\",\n    \"author\": \"The Great Expectations Team\",\n    \"url\": \"https://github.com/great-expectations/great_expectations\",\n    \"author_email\": \"team@greatexpectations.io\",\n    \"version\": versioneer.get_version(),\n    \"cmdclass\": versioneer.get_cmdclass(),\n    \"install_requires\": required,\n    \"extras_require\": {\n        \"spark\": [\"pyspark>=2.3.2\"],\n        \"sqlalchemy\": [\"sqlalchemy>=1.3.16\"],\n        \"airflow\": [\"apache-airflow[s3]>=1.9.0\", \"boto3>=1.7.3\"],\n        \"gcp\": [\n            \"google-cloud>=0.34.0\",\n            \"google-cloud-storage>=1.28.0\",\n            \"google-cloud-secret-manager>=1.0.0\",\n            \"pybigquery==0.4.15\",\n        ],\n        \"redshift\": [\"psycopg2>=2.8\"],\n        \"s3\": [\"boto3>=1.14\"],\n        \"aws_secrets\": [\"boto3>=1.8.7\"],\n        \"azure_secrets\": [\"azure-identity>=1.0.0\", \"azure-keyvault-secrets>=4.0.0\"],\n        \"snowflake\": [\"snowflake-sqlalchemy>=1.2\"],\n    },\n    \"packages\": find_packages(exclude=[\"contrib*\", \"docs*\", \"tests*\", \"examples*\"]),\n    \"entry_points\": {\n        \"console_scripts\": [\"great_expectations=great_expectations.cli:main\"]\n    },\n    \"name\": \"great_expectations\",\n    \"long_description\": long_description,\n    \"license\": \"Apache-2.0\",\n    \"keywords\": \"data science testing pipeline data quality dataquality validation datavalidation\",\n    \"include_package_data\": True,\n    \"classifiers\": [\n        \"Development Status :: 4 - Beta\",\n        \"Intended Audience :: Developers\",\n        \"Intended Audience :: Science/Research\",\n        \"Intended Audience :: Other Audience\",\n        \"Topic :: Scientific/Engineering\",\n        \"Topic :: Software Development\",\n        \"Topic :: Software Development :: Testing\",\n        \"License :: OSI Approved :: Apache Software License\",\n        \"Programming Language :: Python :: 3\",\n        \"Programming Language :: Python :: 3.6\",\n        \"Programming Language :: Python :: 3.7\",\n        \"Programming Language :: Python :: 3.8\",\n        \"Programming Language :: Python :: 3.9\",\n    ],\n}\n\nsetup(**config)\n", "path": "setup.py"}], "after_files": [{"content": "from setuptools import find_packages, setup\n\nimport versioneer\n\n# Parse requirements.txt\nwith open(\"requirements.txt\") as f:\n    required = f.read().splitlines()\n\n# try:\n#    import pypandoc\n#    long_description = pypandoc.convert_file('README.md', 'rst')\n# except (IOError, ImportError):\nlong_description = \"Always know what to expect from your data. (See https://github.com/great-expectations/great_expectations for full description).\"\n\nconfig = {\n    \"description\": \"Always know what to expect from your data.\",\n    \"author\": \"The Great Expectations Team\",\n    \"url\": \"https://github.com/great-expectations/great_expectations\",\n    \"author_email\": \"team@greatexpectations.io\",\n    \"version\": versioneer.get_version(),\n    \"cmdclass\": versioneer.get_cmdclass(),\n    \"install_requires\": required,\n    \"extras_require\": {\n        \"spark\": [\"pyspark>=2.3.2\"],\n        \"sqlalchemy\": [\"sqlalchemy>=1.3.18\"],\n        \"airflow\": [\"apache-airflow[s3]>=1.9.0\", \"boto3>=1.7.3\"],\n        \"gcp\": [\n            \"google-cloud>=0.34.0\",\n            \"google-cloud-storage>=1.28.0\",\n            \"google-cloud-secret-manager>=1.0.0\",\n            \"pybigquery==0.4.15\",\n        ],\n        \"redshift\": [\"psycopg2>=2.8\"],\n        \"s3\": [\"boto3>=1.14\"],\n        \"aws_secrets\": [\"boto3>=1.8.7\"],\n        \"azure_secrets\": [\"azure-identity>=1.0.0\", \"azure-keyvault-secrets>=4.0.0\"],\n        \"snowflake\": [\"snowflake-sqlalchemy>=1.2\"],\n    },\n    \"packages\": find_packages(exclude=[\"contrib*\", \"docs*\", \"tests*\", \"examples*\"]),\n    \"entry_points\": {\n        \"console_scripts\": [\"great_expectations=great_expectations.cli:main\"]\n    },\n    \"name\": \"great_expectations\",\n    \"long_description\": long_description,\n    \"license\": \"Apache-2.0\",\n    \"keywords\": \"data science testing pipeline data quality dataquality validation datavalidation\",\n    \"include_package_data\": True,\n    \"classifiers\": [\n        \"Development Status :: 4 - Beta\",\n        \"Intended Audience :: Developers\",\n        \"Intended Audience :: Science/Research\",\n        \"Intended Audience :: Other Audience\",\n        \"Topic :: Scientific/Engineering\",\n        \"Topic :: Software Development\",\n        \"Topic :: Software Development :: Testing\",\n        \"License :: OSI Approved :: Apache Software License\",\n        \"Programming Language :: Python :: 3\",\n        \"Programming Language :: Python :: 3.6\",\n        \"Programming Language :: Python :: 3.7\",\n        \"Programming Language :: Python :: 3.8\",\n        \"Programming Language :: Python :: 3.9\",\n    ],\n}\n\nsetup(**config)\n", "path": "setup.py"}]}