Using Bookmarks is recommended way when using Glue, however nothing stops you from passing a parameter to glue script [https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-crawler-pyspark-extensions-get-resolved-options.html] and then generaly the query dynamically based on that parameter if you want.
The other question is why you wanted to use Glue and not Redshift federated query instead which might be an easier option?
One option is to use DMS to incrementally load Redshift using MySQL as a source. Here's a whitepaper on the topic: https://docs.aws.amazon.com/whitepapers/latest/optimizing-dms-with-amazon-redshift/optimizing-dms-with-amazon-redshift.html
Glue incremental loadasked 2 months ago
Incremental archive from DynamoDB, Glue Bookmarking?Accepted Answerasked 4 years ago
AWS Glue load data from S3 to Redshiftasked 6 months ago
ETL using AWS Glueasked 5 months ago
Incremental Data Capture from DynamoDB to S3Accepted Answerasked 2 years ago
How to move data from Redshift to Open Search using AWS Glue ?asked 2 months ago
Transferring data from AWS Kinesis data streams to AWS Redshift using AWS Glueasked 5 months ago
Redshift data warehouse and Glue ETL design recommendationsAccepted Answerasked 2 years ago
Need inputs on Glue to move data from Aurora MySQL to Redshiftasked 6 months ago
What is the best practice to load data to redshift with aws glue ?asked 3 years ago