zeger-jan_van_de_weg
01/13/2023, 12:00 PMtap-github
, Meltano variant, I got the following error:
2023-01-12T11:40:22.875196Z [info ] 2023-01-12 12:40:22,875 Tap has custom mapper. Using 1 provided map(s). cmd_type=elb consumer=False name=tap-github producer=True stdio=stderr string_id=tap-github
2023-01-12T11:40:22.876882Z [info ] CRITICAL '2023-01-12T12:40:22.874033+00:00' is not a 'date' cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877005Z [info ] CRITICAL cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877075Z [info ] CRITICAL Failed validating 'format' in schema['properties']['fetched_at']: cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877178Z [info ] CRITICAL {'format': 'date', 'type': ['string', 'null']} cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877239Z [info ] CRITICAL cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877320Z [info ] CRITICAL On instance['fetched_at']: cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.877378Z [info ] CRITICAL '2023-01-12T12:40:22.874033+00:00' cmd_type=elb consumer=True name=target-sqlite producer=False stdio=stderr string_id=target-sqlite
2023-01-12T11:40:22.930778Z [error ] Loader failed
If the target is either SQLite or BigQuery, the same error occurs. It seems as a new user there's an incompatibility between the tap and any target? How do I resolve this?aaronsteers
01/13/2023, 2:52 PMtap-github
.
CRITICAL '2023-01-12T12:40:22.874033+00:00' is not a 'date' cmd_type=elb consumer=True name=target-sqlite
aaronsteers
01/13/2023, 2:53 PMdate
and date-time
fields are different types. Some targets will load them as the same type, but technically they are distinct. Often the source API docs aren't very clear, so it's easy for this to happen.aaronsteers
01/13/2023, 2:53 PMfetched_at
is the culprit here.edgar_ramirez_mondragon
01/13/2023, 2:55 PMaaronsteers
01/13/2023, 2:56 PMaaronsteers
01/13/2023, 2:56 PMaaronsteers
01/13/2023, 2:57 PMaaronsteers
01/13/2023, 6:27 PMtap-github
`v1.2.0`: https://github.com/MeltanoLabs/tap-github/releases/tag/v1.2.0aaronsteers
01/13/2023, 6:28 PMzeger-jan_van_de_weg
01/13/2023, 7:12 PMzeger-jan_van_de_weg
01/13/2023, 7:27 PMaaronsteers
01/13/2023, 9:11 PM