How to see log of query made by Glue pyspark script against JDBC DB

Please try enabling the continuous logging feature for the glue job and see whether the required logs are visible or not. With the help of this feature, it is possible to view the real time logs in your Cloud watch console. Within these logs you can find executor logs, driver logs and spark job progress bar. I hope that these documentations might be of some help:

1. https://docs.aws.amazon.com/glue/latest/dg/monitor-continuous-logging.html
2. https://docs.aws.amazon.com/glue/latest/dg/monitor-profile-glue-job-cloudwatch-metrics.html