Redshift Aginity Workbench - ERROR: 42703: column "XXX" does not exist in table_y

Question

I've been using MySQL Workbench for a while and now I need to work on Aginity - I'm trying to run a simple script:

select min(date)
from table_y 
where column_header = "XXX"

Yet I get this error:

ERROR: 42703: column "XXX" does not exist in table_y

Does the Where command works differently in Aginity than in MySQL Workbench? How do I solve for this error?

Answer 1

So "=" and "IN" are different sql commands.

I think the problem with your original query is that you are using double quotes instead of single.

Try this:

select min(date)
from table_y 
where column_header = 'XXX'