Summary
The user is looking to map three different arrays from an API response into one array for a custom connector. They are specifically working with the Open-Meteo API and want to transform the data to have time, temperature, and precipitation as columns and rows of data.
Question
Hi all, Does anyone know if its possible to map three different arrays into one array for a custom connector?
EX: I am using the Open-Meteo api and it returns {… hourly: { time: [array of times], temperature_2m: [array of temps], precipitation: [array of precipitation]}}. I want to perform some kind of transformation so that the i can get time, temperature, and precipitation as columns and rows of data. Right now, I got it to where it has three columns but one row with an array as the value.
Will I have to just bring it in as arrays and then use DBT to split it?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.