Any information on if/when the Mailchimp connector will support more endpoints, like getting who is subscribed, unsubscribed? Currently the endpoint doesn’t provide it and I also run into issues with the automatic transformation to Postgres (but I’ll document that issue somewhere else).

I know there is some planned work to add more streams, like the members stream. I have the code locally for the members stream, so I may push it soon.

Ah the

members

endpoint would be perfect! Hope to see that soon!

Cool! Regarding the issues you are facing with normalization failing, maybe it's the same as https://github.com/airbytehq/airbyte/issues/8825 This should have been solved if you upgrade the Mailchimp connector to the latest version: 0.2.12

@Ari Bajo (Airbyte) I did see that GH issue and bumped the connector but normalization still fails for me when I add the

lists

and

campaigns

to the streams - but they’re not much use to me anyway so I just removed them…

@Matthew Brandt I finally managed to make our Mailchimp to BigQuery sync work back again on Airbyte Cloud with Mailchimp version 0.2.12. I had to

Refresh source schema

in the connection settings. Note that this will reset your data in the destination. Otherwise Airbyte saves the catalog.json file in the DB and that's the one that is fed to workers when you run a sync. The catalog.json file may be still referencing the old schema in 0.2.11.

@Ari Bajo (Airbyte) oh I will need to look at that again and try! I do believe I tried that but it’s worth a shot again to be sure. Thank you! Seeing as BQ is loosely like Postgres this stands a good chance of working…

Cool! Thanks for letting me know @Matthew Brandt! Have a great weekend octavia loves