Hi @ROBERT_J_ESTEVES ,
Please look at the details in the below post and then compare the scenario at your end.
Could you paste a screenshot which shows how a model looks like ? ( eg : screenshot of the model I have in the above link including the query mode capability ) .
@Sanjeeb2022 : what was the issue with custom sql ?
Athena : custom sql from the same Athena datasource which is joined with another Athena dataset which is also in direct query mode.
Kind regards,
Koushik