We are working with the hubspot tap, and it genera...
# plugins-generalm
marc_garcia_sastre
11/04/2021, 4:43 PMWe are working with the hubspot tap, and it generates a lot of columns which are not needed and mean a lot of noise is there a way to specify in the schema or the catalog to skip those columns? thanks
e
edgar_ramirez_mondragon
11/04/2021, 4:56 PMHi @marc_garcia_sastre! Yes, you'd use
selectm
marc_garcia_sastre
11/04/2021, 5:00 PMone question, the selection means that the field wont be created on the database? Because we have a lot of the fields currently not selected but they are created in the database though
marc_garcia_sastre
11/04/2021, 5:22 PMseems to be that there is a reported issue about this on the hubspot tap. https://github.com/singer-io/tap-hubspot/issues/119 This is the official extractor recommended on the meltano page
j
juan_sebastian_suarez_valencia
11/05/2021, 7:20 AMHello @marc_garcia_sastre
I also face the same problem. I had to build my own tap from scratch for Hubspot. A real pain in the a***
m
marc_garcia_sastre
11/05/2021, 8:28 AMHi Juan, its that tap public? We have forked the tap too, but would like to know if there is a way to deal with all the noise caused by all the nullish created columns. Do you know something about that? thanks
j
juan_sebastian_suarez_valencia
11/05/2021, 3:57 PMHello @marc_garcia_sastre
It’s not public but I can share it with you if you want
m
marc_garcia_sastre
11/08/2021, 9:08 AMSure, let's see if we can work out something together, thanks a lot