We are trying to extract the data from azure blob storage using tap-spreadsheets-anywhere extractor and loading it to local machine using target-csv loader
below is my meltano.yml file
version: 1
default_environment: dev
project_id: c6750c09-214e-4641-bf13-8e02e7d89f30
environments:
- name: dev
- name: staging
- name: prod
plugins:
extractors:
- name: tap-spreadsheets-anywhere
variant: ets
pip_url: git+
https://github.com/ets/tap-spreadsheets-anywhere.git
config:
tables:
- path:
azure://d0s-proto/
name: e
pattern: .*\.csv
start_date: '2023-11-20T11
0253Z'
key_properties: []
format: csv
loaders:
- name: target-csv
variant: singer-io
pip_url: target-csv
config:
destination_path: C:\meltano-project1
I'm getting below error, please suggest how to resolve this.
BrokenPipeError: [WinError 109] The pipe has been ended
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
│ 573 │ │ │ except OSError as exc: │
│ 574 │ │ │ │ if exc.winerror in (_overlapped.ERROR_NETNAME_DELETED, │
│ 575 │ │ │ │ │ │ │ │ │ _overlapped.ERROR_OPERATION_ABORTED): │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
BrokenPipeError: [WinError 109] The pipe has been ended
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
│ 574 │ │ │ │ if exc.winerror in (_overlapped.ERROR_NETNAME_DELETED, │
│ 575 │ │ │ │ │ │ │ │ │ _overlapped.ERROR_OPERATION_ABORTED): │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
BrokenPipeError: [WinError 109] The pipe has been ended
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
BrokenPipeError: [WinError 109] The pipe has been ended
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
Exception ignored in: <function BaseSubprocessTransport.
del at 0x000002C596FD91C0>
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close
Traceback (most recent call last):
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in
del
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close
self.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close
proto.pipe.close()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close
self._loop.call_soon(self._call_connection_lost, None)
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 761, in call_soon
self._check_closed()
File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 519, in _check_closed
raise RuntimeError('Event loop is closed')
RuntimeError: Event loop is closed