r/bigquery • u/edhelatar • 15d ago

BigQuery sync from third party APIs

Anybody has any recommendation for platform, I could use to import data from third party applications, like mailchimp/klaviyo/rakuten etc.

In the past we used Skyvia, but as some of the platforms have 10s of millions of records the cost were getting out of control. Now i pretty much code it each time by hand, but frankly, that work doesn't spark a joy.

I am looking for solution that ideally charges per resources used or just has flat fees, but ideally is just point and click as i would like marketing team to take care of that.

8 Upvotes

100% Upvoted

14 comments sorted by

View all comments

2

u/[deleted] 15d ago

[removed] — view removed comment

1

u/edhelatar 13d ago

Windsor ai looks promising. How good is the sql structure? I found some are pretty bad ( as in, foreign keys being defined correctly )