Anyone had experience getting the twilio tap to wo...
# plugins-generalm
mark_poole
06/22/2021, 10:02 PMAnyone had experience getting the twilio tap to work with postgres target? I'm using the transferwise variant for both. First I tried with a twilio subaccount SID and that just returned a bunch of 404s from the API so I switched to the twilio master account ID and data seems to be pulled correctly. The error i'm getting is in the target
```tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=METRIC: {"type": "timer", "metric": "http_request_duration", "value": 0.024429798126220703, "tags": {"endpoint": "usage", "http_status_code": 200, "status": "succeeded"}}
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=METRIC: {"type": "counter", "metric": "record_count", "value": 1, "tags": {"endpoint": "usage"}}
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=Stream usage, batch processed 1 records
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=START Syncing: usage_records
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=START Sync for Stream: usage_records, parent_stream: usage, parent_id: None
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=stream: usage_records, bookmark_field: end_date, last_datetime: 2021-04-01T000000+00:00
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=START Sync for Stream: usage_records, Date window from: 2021-04-01 000000+00:00 to 2021-05-01 000000+00:00
tap-twilio | time=2021-06-22 215550 name=singer level=INFO message=URL for Stream usage_records: https://api.twilio.com/2010-04-01/Accounts/xxxxx/Usage/Records.json?StartDate=2021-04-01&EndDate=2021-05-01
target-postgres | time=2021-06-22 215550 name=target_postgres level=INFO message=Table '"message_media"' exists
target-postgres | time=2021-06-22 215550 name=target_postgres level=INFO message=Table '"message_media"' exists
target-postgres | time=2021-06-22 215550 name=target_postgres level=INFO message=Table '"usage"' does not exist. Creating... CREATE TABLE IF NOT EXISTS twilio."usage" ("_sdc_batched_at" timestamp without time zone, "_sdc_deleted_at" character varying, "_sdc_extracted_at" timestamp without time zone, "subresource_uris" jsonb, PRIMARY KEY (""))
target-postgres | Traceback (most recent call last):
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/bin/target-postgres", line 8, in <module>
target-postgres | sys.exit(main())
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/lib/python3.7/site-packages/target_postgres/__init__.py", line 373, in main
target-postgres | persist_lines(config, singer_messages)
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/lib/python3.7/site-packages/target_postgres/__init__.py", line 219, in persist_lines
target-postgres | stream_to_sync[stream].sync_table()
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/lib/python3.7/site-packages/target_postgres/db_sync.py", line 589, in sync_table
target-postgres | self.query(query)
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/lib/python3.7/site-packages/target_postgres/db_sync.py", line 313, in query
target-postgres | params
target-postgres | File "/home/meltano/meltano/twilio-qa/.meltano/loaders/target-postgres/venv/lib/python3.7/site-packages/psycopg2/extras.py", line 143, in execute
target-postgres | return super(DictCursor, self).execute(query, vars)
target-postgres | psycopg2.errors.SyntaxError: zero-length delimited identifier at or near """"
target-postgres | LINE 1: ...thout time zone, "subresource_uris" jsonb, PRIMARY KEY (""))
target-postgres | ^
target-postgres |
meltano | Loading failed (1): (see above)
meltano | ELT coul…