Running extract & load... No state was found, complete import. before_invoke hook 'run_discovery_hook' has failed: Schema discovery failed: command ['/var/meltano/project/.meltano/extractors/tap-zendesk/venv/bin/tap-zendesk', '--config', '/var/meltano/project/.meltano/run/tap-zendesk/tap.config.json', '--discover'] returned 1: INFO Using API Token authentication. INFO Starting discover INFO METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.005293607711791992, "tags": {"status": "failed"}} CRITICAL HTTPSConnectionPool(host='https', port=443): Max retries exceeded with url: //metageek.zendesk.com/.zendesk.com/api/v2/user_fields.json (Caused by NewConnectionError(': Failed to establish a new connection: [Errno -3] Temporary failure in name resolution',)) Traceback (most recent call last): File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connection.py", line 157, in _new_conn (self._dns_host, self.port), self.timeout, **extra_kw File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/util/connection.py", line 61, in create_connection for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM): File "/usr/lib/python3.6/socket.py", line 745, in getaddrinfo for res in _socket.getaddrinfo(host, port, family, type, proto, flags): socket.gaierror: [Errno -3] Temporary failure in name resolution During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 672, in urlopen chunked=chunked, File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 376, in _make_request self._validate_conn(conn) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 994, in _validate_conn conn.connect() File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connection.py", line 300, in connect conn = self._new_conn() File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connection.py", line 169, in _new_conn self, "Failed to establish a new connection: %s" % e urllib3.exceptions.NewConnectionError: : Failed to establish a new connection: [Errno -3] Temporary failure in name resolution During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/requests/adapters.py", line 449, in send timeout=timeout File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 760, in urlopen **response_kw File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 760, in urlopen **response_kw File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 760, in urlopen **response_kw File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/connectionpool.py", line 720, in urlopen method, url, error=e, _pool=self, _stacktrace=sys.exc_info()[2] File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/urllib3/util/retry.py", line 436, in increment raise MaxRetryError(_pool, url, error or ResponseError(cause)) urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='https', port=443): Max retries exceeded with url: //metageek.zendesk.com/.zendesk.com/api/v2/user_fields.json (Caused by NewConnectionError(': Failed to establish a new connection: [Errno -3] Temporary failure in name resolution',)) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/bin/tap-zendesk", line 11, in load_entry_point('tap-zendesk==1.4.6', 'console_scripts', 'tap-zendesk')() File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/singer/utils.py", line 192, in wrapped return fnc(*args, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/__init__.py", line 197, in main do_discover(client) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/__init__.py", line 46, in do_discover catalog = {"streams": discover_streams(client)} File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/discover.py", line 29, in discover_streams schema = singer.resolve_schema_references(s.load_schema(), refs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/streams.py", line 75, in load_schema return self._add_custom_fields(schema) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/streams.py", line 150, in _add_custom_fields field_gen = self.client.user_fields() File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/zenpy/lib/api.py", line 305, in __call__ return self._query_zendesk(self.endpoint, self.object_type, *args, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/zenpy/lib/api.py", line 256, in _query_zendesk return self._get(self._build_url(endpoint=endpoint(*endpoint_args, **endpoint_kwargs))) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/zenpy/lib/api.py", line 97, in _get response = self._call_api(self.session.get, url, timeout=self.timeout, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/zenpy/lib/api.py", line 118, in _call_api response = http_method(url, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/requests/sessions.py", line 543, in get return self.request('GET', url, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/tap_zendesk/__init__.py", line 39, in request_metrics_patch return request(self, method, url, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/requests/sessions.py", line 530, in request resp = self.send(prep, **send_kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/requests/sessions.py", line 643, in send r = adapter.send(request, **kwargs) File "/var/meltano/project/.meltano/extractors/tap-zendesk/venv/lib/python3.6/site-packages/requests/adapters.py", line 516, in send raise ConnectionError(e, request=request) requests.exceptions.ConnectionError: HTTPSConnectionPool(host='https', port=443): Max retries exceeded with url: //metageek.zendesk.com/.zendesk.com/api/v2/user_fields.json (Caused by NewConnectionError(': Failed to establish a new connection: [Errno -3] Temporary failure in name resolution',)) before_invoke hook 'apply_select_hook' has failed: Selection failed: catalog file is missing. /var/meltano/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: . """) INFO Using API Token authentication. Extract & load complete! Running transformation... Running with dbt=0.14.4 Checking ../.meltano/transformers/dbt/target/* Checking dbt_modules/* Cleaned dbt_modules/* Checking logs/* Cleaned logs/* Finished cleaning all paths. Running with dbt=0.14.4 WARNING: The git package "https://gitlab.com/meltano/dbt-tap-stripe.git" is not pinned. This can introduce breaking changes into your project without warning! See https://docs.getdbt.com/docs/package-management#section-specifying-package-versions WARNING: The git package "https://gitlab.com/meltano/dbt-tap-zendesk.git" is not pinned. This can introduce breaking changes into your project without warning! See https://docs.getdbt.com/docs/package-management#section-specifying-package-versions Installing https://gitlab.com/meltano/dbt-tap-stripe.git@master Installed from revision master Installing https://gitlab.com/meltano/dbt-tap-zendesk.git@master Installed from revision master Running with dbt=0.14.4 Found 22 models, 15 tests, 0 snapshots, 0 analyses, 117 macros, 0 operations, 0 seed files, 0 sources 18:00:04 | Concurrency: 2 threads (target='postgres') 18:00:04 | 18:00:04 | 1 of 8 START table model analytics.zendesk_organizations............. [RUN] 18:00:04 | 2 of 8 START table model analytics.zendesk_ticket_metrics............ [RUN] 18:00:04 | 1 of 8 ERROR creating table model analytics.zendesk_organizations.... [ERROR in 0.18s] 18:00:04 | 3 of 8 START table model analytics.zendesk_tickets................... [RUN] 18:00:04 | 2 of 8 ERROR creating table model analytics.zendesk_ticket_metrics... [ERROR in 0.20s] 18:00:04 | 4 of 8 START table model analytics.zendesk_users..................... [RUN] 18:00:04 | 3 of 8 ERROR creating table model analytics.zendesk_tickets.......... [ERROR in 0.09s] 18:00:04 | 5 of 8 START table model analytics.zendesk_dim_date.................. [RUN] 18:00:04 | 4 of 8 ERROR creating table model analytics.zendesk_users............ [ERROR in 0.07s] 18:00:04 | 6 of 8 START table model analytics.zendesk_tags...................... [RUN] 18:00:04 | 6 of 8 ERROR creating table model analytics.zendesk_tags............. [ERROR in 0.12s] 18:00:04 | 7 of 8 START table model analytics.zendesk_ticket_tags............... [RUN] 18:00:04 | 7 of 8 ERROR creating table model analytics.zendesk_ticket_tags...... [ERROR in 0.06s] 18:00:04 | 8 of 8 SKIP relation analytics.zendesk_tickets_xf.................... [SKIP] 18:00:05 | 5 of 8 OK created table model analytics.zendesk_dim_date............. [SELECT 29220 in 0.92s] 18:00:05 | 18:00:05 | Finished running 8 table models in 1.97s. Completed with 6 errors and 0 warnings: Database Error in model zendesk_organizations (models/base/zendesk_organizations.sql) relation "tap_zendesk.organizations" does not exist LINE 5: select * from tap_zendesk.organizations ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_organizations.sql Database Error in model zendesk_ticket_metrics (models/base/zendesk_ticket_metrics.sql) relation "tap_zendesk.ticket_metrics" does not exist LINE 5: select * from tap_zendesk.ticket_metrics ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_ticket_metrics.sql Database Error in model zendesk_tickets (models/base/zendesk_tickets.sql) relation "tap_zendesk.tickets" does not exist LINE 5: select * from tap_zendesk.tickets ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_tickets.sql Database Error in model zendesk_users (models/base/zendesk_users.sql) relation "tap_zendesk.users" does not exist LINE 5: select * from tap_zendesk.users ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_users.sql Database Error in model zendesk_tags (models/base/zendesk_tags.sql) relation "tap_zendesk.tags" does not exist LINE 5: select * from tap_zendesk.tags ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_tags.sql Database Error in model zendesk_ticket_tags (models/base/zendesk_ticket_tags.sql) relation "tap_zendesk.tickets" does not exist LINE 5: select * from tap_zendesk.tickets ^ compiled SQL at ../.meltano/transformers/dbt/target/compiled/tap_zendesk/base/zendesk_ticket_tags.sql Done. PASS=1 WARN=0 ERROR=6 SKIP=1 TOTAL=8 ELT could not complete, an error happened during the process: dbt run didn't exit cleanly. Exit code: 1 Traceback (most recent call last): File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/cli/elt.py", line 79, in elt run_transform(elt_context, transform_session, dry_run=dry, models=elt_context.extractor.ref.name) File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/cli/elt.py", line 114, in run_transform dbt_runner.run(session, **kwargs) # TODO: models from elt_context? File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/core/runner/dbt.py", line 63, in run loop.run_until_complete(self.dbt_service.run(models, env=env)) File "/usr/lib/python3.6/asyncio/base_events.py", line 484, in run_until_complete return future.result() File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/core/dbt_service.py", line 105, in run await self.invoke("run", *params, **kwargs) File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/core/dbt_service.py", line 78, in invoke f"dbt {cmd} didn't exit cleanly. Exit code: {handle.returncode}" Exception: dbt run didn't exit cleanly. Exit code: 1 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/var/meltano/.venv/lib/python3.6/site-packages/meltano/cli/elt.py", line 86, in elt raise click.Abort() click.exceptions.Abort