Invalid Identifier

[jhoffstein]

I'm loading data by connecting to Snowflake through an OBDC connector.  Certain columns that load fine in the Snowflake web portal won't load into Power BI desktop, throwing this error:

DataSource.Error: ODBC: ERROR [42000] SQL compilation error: error line 8 at position 0
invalid identifier 'EVENT_UUID'
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=(mydsn);warehouse=(mywarehouse)
OdbcErrors=Table

This error occurs for 6 of my 50+ columns, and I can't find any rhyme or reason for it.  If I remove those columns from my SQL query the rest of the table loads fine.

How can I resolve this issue so I can load my entire table?

[jhoffstein · Accepted solution]

My apologies - I was doing this late last night and in my tired state was referencing the wrong table.. no wonder I wasn't getting all the columns I expected!

Mods, please feel free to delete this post.