Configuring AWS Glue settings

Open AWS Glue services.

Create a database.

• Name the database and click 'Create database'.

A database with the desired name is created.

Open IAM services and select 'Role'.

Select the desired roles.

Select the trusted entity, choose the use case as 'glue', and select 'Next'.

In Permissions, set the default execution role for the Glue function, and click 'Next'.

Name, review and create:

• Name the role.

• Add description (if needed/as required).

• Click 'Create role'.

Click 'ETL jobs'.

Create a script by clicking the 'Script editor' tab.

Select 'Spark' from the options under Engine (from the drop-down).

Enable 'Upload script' and click 'Choose file'.

Locate the script file on your device, select and open.

View or edit your script code (if required)

Add the basic properties under the 'Job details' tab.

Option 1 - To add data to the database based on time