I am trying to create an app that will read a range from a google sheet, convert it to array, and upload the result to an existing table in my database. I have set up a query that reads the gsheet and outputs the results perfectly, but I am struggling to query it in SQL.
When I write this query:
select "First Name" from {{get_gsheet.data}};
It returns the following output which is not correct.
When I inspect {{get_gsheet.data}}, however, it shows the data correctly, as a set of key value pairs corresponding to my headings.
How do I set it up so that I can
Read the Gsheet and convert to array
Inner join a couple of other tables from my db
select columns from the result and insert into another table.
Thanks for the response! Yep I used that approach and I have managed to get it working! I had some incorrect syntax in my query which was causing the error. And renaming the columns in my gsheet db to snake_case format made it easier to query.