Google Sheets valid key not found in table

💬 Queries and Resources
, ,
2

So this may not necessarily be the best solution but I was able to find a workaround in case anyone else runs into this problem.

The problem is definitely with the column headers. In my case, it is either too long or there is some character in the column that is throwing it off. This was leading to the error on the table of "Without a valid key, this column will not display any data."

Below are the steps I took to solve it.

  1. From the Google sheet query, Action Type was set to Read data from a spreadsheet and I used A1 notation.
    I left Data Types as "Read data as typed values".
    On preview, I could see all data was showing correct.

  2. Created a Query JSON with SQL. Did a query of data but gave each column a new alias.
    For example, if one column was "This is my column header" and another was "This is the second Column Header" I did the following

select w.`This is my column header` as `My Col1`, 
w.`This is the second Column Header` as `My Col2` from {{ mysheet.data }} as w where ...
  1. Used the new query as the data source for the table and it worked fine.
1 Like