Not possible add variable into connection sql tab. We have many same tables in different Oracle user schemas and we need transform all these tables with one connection and dynamics variables.
Example:
alter session set current_schema = ${dyn_user_schema}
or
alter session set current_schema = %%dyn_user_schema%%


Reference: http://forums.pentaho.org/showthread.php?t=54038

Thanks.