A data engineer needs to extract raw sales data from an Amazon S3 bucket, transform the data into a columnar format for efficient querying, and load it into Amazon Redshift for analytics. The ETL process needs to be fully automated and run daily. Which combination of AWS Glue features should the engineer use to accomplish this task? (Choose TWO.)