Hello, I am gonna use PostgreSQL as source and Hubspot as destination. Is there any recommendation to implement transforms which performs the following feature?

The following screenshot shows what the data comes from the DB. Each contact has several different types of miners(each miner has own model). So here I want to map the miner models and corresponding count into properties of Hubspot contact.
e.g) There are 2 miner models for the contact(hubspot_contact_id = 12755151 - the first 2 records). miner_model_antiminers19jpro(Hubspot) = 4(miner_count of PostgreSQL), miner_model_whatsminerm32 = 2 etc

Is it possible to implement that feature?

Hey There! 👋 Your message has been received by the RudderStack team. Our standard customer support hours are 9-6 PM EST, but we will forward this request to your Technical Account Manager, and they will get back to you shortly. Please use the thread for any additional comments.

When you ingest data from Postgres to rudderstack, how does your payload look like? Restructuring the payload via transformations should work fine if you don’t change any required format or fields for hubspot destination.

Hi, @quiet-wolf-72320 Thanks for reaching out for me. The ingest data seems like the above screenshot

It should be, did you try?