pandas.read_sql_redshift() throws S3WaitObjectTimeout

[simonstu]

The function pandas.read_sql_redshift() throws a S3WaitObjectTimeout when the SQL query returns no rows.
Everything works fine when the query returns some rows. I am using awswrangler-layer-0.2.5-py3.7.zip.

Detailed Error Message:

Response:
{
  "errorMessage": "Waited for s3://XYZ/tmp2/temp_redshift_08f05b022cba42f5b3f5a159f5312bb7/manifest for 30.000000000000156 seconds",
  "errorType": "S3WaitObjectTimeout",
  "stackTrace": [
    "  File \"/var/task/functions/for_testing.py\", line 60, in lambda_handler\n    temp_s3_path=\"s3://\" + bucket_name + \"/tmp2\")\n",
    "  File \"/opt/python/awswrangler/pandas.py\", line 1598, in read_sql_redshift\n    raise ex\n",
    "  File \"/opt/python/awswrangler/pandas.py\", line 1587, in read_sql_redshift\n    connection=connection)\n",
    "  File \"/opt/python/awswrangler/redshift.py\", line 459, in to_parquet\n    self._session.s3.wait_object_exists(path=f\"{path}manifest\", timeout=30.0)\n",
    "  File \"/opt/python/awswrangler/s3.py\", line 103, in wait_object_exists\n    raise S3WaitObjectTimeout(f\"Waited for {path} for {time_acc} seconds\")\n"
  ]
}

[igorborgest]

Thanks @simonstu. Valuable issue!

Already fixed and will be released in the next version on the weekend.