finn_frotscher
10/01/2021, 8:58 AMtap hubspot
and target bigquery
boggdan_barrientos
10/01/2021, 2:57 PMtap hubspot
and target bigquery
but seems that use a start_date to pulls data based on that date.
https://github.com/singer-io/tap-hubspot
{
"redirect_uri": "<https://api.hubspot.com/>",
"client_id": 123456789000,
"client_secret": "my_secret",
"refresh_token": "my_token",
"start_date": "2017-01-01T00:00:00Z",
"disable_collection": false
}
edgar_ramirez_mondragon
10/01/2021, 3:30 PMtap-hubspot
seems to support incremental replication
Incrementally pulls data based on the input statethe default
target-bigquery
(adswerve) supports truncate
and append
. pipelinewise-target-bigquery on the other hand supports upserting, which imo is a better approach than either truncate or append. You'll have to add the latter as a custom plugin though.