federated mysql query with a reserved word column name fails to run in Redhsift

59 Views Asked by At

I have a remote connection into a mysql database from Redshift. Mysql table has a column year_month which is a reserved word in mysql and since this table is already populated and applications are using it, column name cannot be changed.

I tried backtick, double quotes - both are failing.

select id, `year_month` from updoc_mysql.apsetup;

0

There are 0 best solutions below