Error running dlt pipeline to send loaded table query result to s3!
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/duckdb_engine/__init__.py", line 139, in execute
    self.__c.execute(statement, parameters)
duckdb.duckdb.IOException: IO Error: Unknown error for HTTP HEAD to 'https://s3.us-east-2.amazonaws.com/analytics/charge_dataset/staging/year%3D2024/quarter%3DQ4/month%3D10/day%3D06/1728253531.8655741.3e73fb1f29.parquet'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/concurrent/futures/thread.py", line 58, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/utils.py", line 235, in _parallel_gen
    return next(gen)  # type: ignore[call-overload]
  File "/app/app/dlt_sources.py", line 60, in query_resource
    query_result = conn.execute(text(query))
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1422, in execute
    return meth(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 514, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1644, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1850, in _execute_context
    return self._exec_single_context(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1990, in _exec_single_context
    self._handle_dbapi_exception(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2357, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1971, in _exec_single_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 919, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.10/site-packages/duckdb_engine/__init__.py", line 139, in execute
    self.__c.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (duckdb.duckdb.IOException) IO Error: Unknown error for HTTP HEAD to 'https://s3.us-east-2.amazonaws.com/analytics/charge_dataset/staging/year%3D2024/quarter%3DQ4/month%3D10/day%3D06/1728253531.8655741.3e73fb1f29.parquet'
[SQL: WITH charge AS (
                            SELECT * EXCLUDE(_dlt_load_id, _dlt_id) FROM read_parquet('s3://analytics/charge_dataset/staging/year=2024/quarter=Q4/month=10/day=06/1728253531.8655741.3e73fb1f29.parquet')
                            )
                        select * from charge]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 433, in extract
    self._extract_source(
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 1149, in _extract_source
    load_id = extract.extract(
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/extract.py", line 404, in extract
    self._extract_single_source(
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/extract.py", line 327, in _extract_single_source
    for pipe_item in pipes:
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/pipe_iterator.py", line 163, in __next__
    pipe_item = self._futures_pool.resolve_next_future(
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/concurrency.py", line 182, in resolve_next_future
    return self._resolve_future(future)
  File "/usr/local/lib/python3.10/site-packages/dlt/extract/concurrency.py", line 142, in _resolve_future
    raise ResourceExtractionError(pipe.name, future, str(ex), "future") from ex
dlt.extract.exceptions.ResourceExtractionError: In processing pipe step3: extraction of resource step3 in future <Future at 0x7f4a7665fd30 state=finished raised OperationalError> caused an exception: (duckdb.duckdb.IOException) IO Error: Unknown error for HTTP HEAD to 'https://s3.us-east-2.amazonaws.com/analytics/charge_dataset/staging/year%3D2024/quarter%3DQ4/month%3D10/day%3D06/1728253531.8655741.3e73fb1f29.parquet'
[SQL: WITH charge AS (
                            SELECT * EXCLUDE(_dlt_load_id, _dlt_id) FROM read_parquet('s3://analytics/charge_dataset/staging/year=2024/quarter=Q4/month=10/day=06/1728253531.8655741.3e73fb1f29.parquet')
                            )
                        select * from charge]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/app/app/data_pipeline.py", line 980, in run_pipeline
    pipe_info = s3_pipeline.run(
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 222, in _wrap
    step_info = f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 267, in _wrap
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 684, in run
    self.extract(
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 222, in _wrap
    step_info = f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 176, in _wrap
    rv = f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 162, in _wrap
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 267, in _wrap
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/dlt/pipeline/pipeline.py", line 453, in extract
    raise PipelineStepFailed(
dlt.pipeline.exceptions.PipelineStepFailed: Pipeline execution failed at stage extract when processing package 1728413987.4298942 with exception:

<class 'dlt.extract.exceptions.ResourceExtractionError'>
In processing pipe step3: extraction of resource step3 in future <Future at 0x7f4a7665fd30 state=finished raised OperationalError> caused an exception: (duckdb.duckdb.IOException) IO Error: Unknown error for HTTP HEAD to 'https://s3.us-east-2.amazonaws.com/analytics/charge_dataset/staging/year%3D2024/quarter%3DQ4/month%3D10/day%3D06/1728253531.8655741.3e73fb1f29.parquet'
[SQL: WITH charge AS (
                            SELECT * EXCLUDE(_dlt_load_id, _dlt_id) FROM read_parquet('s3://analytics/charge_dataset/staging/year=2024/quarter=Q4/month=10/day=06/1728253531.8655741.3e73fb1f29.parquet')
                            )
                        select * from charge]
(Background on this error at: https://sqlalche.me/e/20/e3q8)