# Configuring AWS Glue settings

#### Open AWS Glue services.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FcgAPZnU0gai4YMa41K9J%2Fimage.png?alt=media&#x26;token=86158a08-923c-4c78-8015-d43c0fae0a32" alt=""><figcaption></figcaption></figure>

#### Create a database.

* Name the database and click 'Create database'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FYkVhH3917b4nc7cDwcjQ%2Fimage.png?alt=media&#x26;token=68cd9360-cbf1-43d7-9f26-4f2e2ad8418f" alt=""><figcaption></figcaption></figure>

#### A database with the desired name is created.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2Fwp12I3lJMQ5Tf6cYEjwo%2Fimage.png?alt=media&#x26;token=86936dd6-ce84-4575-891e-9dfe02327290" alt=""><figcaption></figcaption></figure>

#### Open IAM services and select 'Role'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F9bjuTS2bT4aV5MFUZYOa%2Fimage.png?alt=media&#x26;token=f73aaaa8-f89c-49b7-9f35-a8adb272191a" alt=""><figcaption></figcaption></figure>

#### Select the desired roles.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FCICpOIz78bciM631mh1k%2Fimage.png?alt=media&#x26;token=09d0d37c-225f-47a1-b5d2-bf4f59760780" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FhoaNgQ4axH5Fhe0KEnqj%2Fimage.png?alt=media&#x26;token=09a547c4-1c5a-4c86-a79f-6d455fd6d828" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2Fuw5qvChz95iqGufPGI9T%2Fimage.png?alt=media&#x26;token=12459cf8-9eb3-4df3-b155-d3ece962714c" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FJURvANFn71nxOKM49Gk3%2Fimage.png?alt=media&#x26;token=5720ddfe-cbde-40e1-935e-1a387e52fde6" alt=""><figcaption></figcaption></figure>

#### Name, review and create:

* Name the role.
* Add description (if needed/as required).
* Click 'Create role'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F7TbU67pAiJVLkAPAamvi%2Fimage.png?alt=media&#x26;token=d1b74179-575a-4444-875d-1f579b6c10d6" alt=""><figcaption></figcaption></figure>

#### Click 'ETL jobs'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FfqphthkZ7R2VdDAalqRK%2Fimage.png?alt=media&#x26;token=1ee4b81c-9f0a-4b21-a4ae-d5be47604322" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F3vIUgoaeJ3OnrU2IKO85%2Fimage.png?alt=media&#x26;token=623fcffa-44b0-4304-a436-014a93b36564" alt=""><figcaption></figcaption></figure>

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

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

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FBCXEFKu1fZJY91aAapKi%2Fimage.png?alt=media&#x26;token=5cf7d34a-3870-4dff-9a6e-8d83401938ae" alt=""><figcaption></figcaption></figure>

#### Locate the [<mark style="color:blue;">script file</mark>](https://itltdgithub.s3.ap-south-1.amazonaws.com/glue_script_v2.py) on your device, select and open.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FHFmasc9q8fm5NfBenlFR%2Fimage.png?alt=media&#x26;token=65334bb9-fda6-45ef-a732-82eeba8adf5d" alt=""><figcaption></figcaption></figure>

#### View or edit your script code (if required)

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FKv6DJoxetSIfoACgSUhm%2Fimage.png?alt=media&#x26;token=ed358345-babe-4f50-a100-03b1bdc0138c" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2Fm2F4a6SfhPlsXBwUc1h9%2Fimage.png?alt=media&#x26;token=fa548454-c234-4ff3-875d-f4f64e041eba" alt=""><figcaption></figcaption></figure>

#### [<mark style="color:blue;">Option 1 - To add data to the database based on time</mark>](https://app.gitbook.com/o/HhTfJJOHHF3lfqYUgSrl/s/TCRfbN5hBLeUzIaKHbJ7/~/changes/407/rexgen-air-cloud-usage-guides/cloud-usage-guides-for-rexgen-air-device/setting-grafana-dashboard-with-parquet/configuring-aws-glue-settings/option-1-to-add-data-to-the-database-based-on-time)