Pipedrive source 0.1.4 normalisation fails

[cnpatric]

Enviroment

• Airbyte version: example is 0.29.17-alpha
• OS Version / Instance: GCP
• Deployment: Docker
• Source Connector and version: Pipedrive 0.1.4
• Destination Connector and version: BigQuery 0.4.0
• Severity: High
• Step where error happened: First full sync during table creation

Current Behavior

Data is pulled from Pipedrive and during table creation in BigQuery the sync fails with a normalisation error and 404 errors.

Expected Behavior

Sync finishes

Logs

LOG

2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 - Completed with 2 errors and 0 warnings:
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 -
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 - 404 GET https://bigquery.googleapis.com/bigquery/v2/projects/craftnote-live/datasets/airbyte_pipedrive/tables/leads_value?prettyPrint=false: Not found: Dataset craftnote-live:airbyte_pipedrive
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 -
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 - Database Error in model persons (models/generated/airbyte_tables/airbyte_pipedrive/persons.sql)
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 - Invalid timestamp: '11:15:00'
2021-09-15 11:09:40 INFO () LineGobbler(voidCall):85 - compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/airbyte_pipedrive/persons.sql

logs-1-0 (1).txt

Steps to Reproduce

unknown

[cnpatric]

The 404 errors disappeared on second attempt but the invalid timestamp still exists

[sherifnada]

fixed in https://github.com/airbytehq/airbyte/pull/6441/files, @cnpatric please upgrade to the latest version and try again