I have a JSON file and need to put this into an aggregated product table using an ETL what can be recommended?

lookml
etl

(George Halford) #1

I have a JSON file and need to put this into an aggregated product table using an ETL what can be recommended?


(Jake Stein) #2

Hi George,

Stitch, where I’m CEO, could be a good fit for your needs here. We have an API that accepts JSON, and we support loading data into Redshift, BigQuery, PostgreSQL, and Snowflake. It’s free if your data volume is less than 5 million rows of data per month.

I’m not totally sure what you mean by “aggregated product table”, but if there are multiple instances of this JSON file, you can send them all to our API to be automatically loaded. If you need transformation to be done beyond light denesting and data typing, that’s out of scope for us. The best bet will be either to use a different ETL tool, or to use us to load the data and then transform it in LookML or SQL.

You can try Stitch for free here, but let me know if I can answer any questions for you.

Jake