# Setting a Grafana Dashboard using the Athena plugin

#### &#x20;Visit [<mark style="color:blue;">**Grafana.com**</mark>](https://grafana.com/), click 'data sources' and then click 'Add new data source'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2Fc5LvZHJFs41Ev1xYhAHh%2Fimage.png?alt=media&#x26;token=0d0c90a6-c49c-446f-9ed3-06197c0fbc22" alt=""><figcaption></figcaption></figure>

#### Get plugin >> Amazon Athena >> Install Plugin

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FcpLa4RcdiubJDmEbe1eO%2Fimage.png?alt=media&#x26;token=69a74806-804c-4f91-b264-80981494fdac" alt=""><figcaption></figcaption></figure>

#### 'Amazon Athena' plugin is added,

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FSiL1WJ70CnFtX4ONF0Vt%2Fimage.png?alt=media&#x26;token=8583db5d-19b4-4a22-9e0e-75ba9c695a01" alt=""><figcaption></figcaption></figure>

#### Return to AWS IAM settings, select the 'Users tab', and click 'Create User. '

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F6YJxD3T3x8ZTKPYvtfjx%2Fimage.png?alt=media&#x26;token=55ae53de-b698-4ba2-9569-dddc091c2a05" alt=""><figcaption></figcaption></figure>

#### Specify the user details and click 'Next'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FwSBQKtZ6E7sWE38BPdQx%2Fimage.png?alt=media&#x26;token=7f10fdc5-9bc0-438d-b537-892557c3d1e0" alt=""><figcaption></figcaption></figure>

#### To set permissions, select 'Attach policies directly'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FsdXyqmH7F5ysl9zGKbDS%2Fimage.png?alt=media&#x26;token=0ccfdd10-c132-45c8-8d71-fcbc21b1411d" alt=""><figcaption></figcaption></figure>

#### Select from the existing policies.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FOifY0vS1I2m5k5kmPHdY%2Fimage.png?alt=media&#x26;token=1c8e4906-35e4-41f2-8be0-d7fab5c016b0" alt=""><figcaption></figcaption></figure>

#### Click 'Create user'

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FqgpuD7vXre4vixxZHqob%2Fimage.png?alt=media&#x26;token=09265a50-7974-4277-901b-82fa4b94a134" alt=""><figcaption></figcaption></figure>

#### Create the Access Key.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FjVFWUBEcHvegwUCHUJlF%2Fimage.png?alt=media&#x26;token=80aca26a-9d76-4da7-b96a-fc686ab73673" alt=""><figcaption></figcaption></figure>

#### Select 'Others' and click 'Next.'

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FVTqzeKsSHB1Pb6Cj7fOf%2Fimage.png?alt=media&#x26;token=7e07504b-495b-4741-aef8-1fc6c9431846" alt=""><figcaption></figcaption></figure>

#### Set Description tags if required, and click 'Create access key'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FX0m6McIUVvex39hSLz1M%2Fimage.png?alt=media&#x26;token=5b6a8cf5-a964-417a-a42b-c28726bffc2e" alt=""><figcaption></figcaption></figure>

#### Once the Access key is created, copy and save both the access and the secret access key, or download them as a .csv file and click 'Done'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FPKl18X8OkP4l58xzn894%2Fimage.png?alt=media&#x26;token=3f2e5ae5-2efc-4867-8ab2-af1a8cc91182" alt=""><figcaption></figcaption></figure>

#### Now go back to Grafana to specify the Athena dashboard's settings and click 'Save and test.' Ensure that the output location is a folder in the S3 bucket.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FfV1223wePfMksMCqIX8Z%2Fimage.png?alt=media&#x26;token=500e1d47-8f7e-43b4-a85e-fae0c45ac5b0" alt=""><figcaption></figcaption></figure>

#### Once the data source is tested, this message is displayed.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FfedR4sCl5Y5fSn5WpuCL%2Fimage.png?alt=media&#x26;token=a21758c8-7e2f-42c0-8fe4-f215203b614f" alt=""><figcaption></figcaption></figure>

#### Click 'Dashboards', click 'New' and then click 'New dashboard'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F0WA25QOMx2iUELbfm9HZ%2Fimage.png?alt=media&#x26;token=df47e826-55cc-49d8-807c-639025cefae6" alt=""><figcaption></figcaption></figure>

#### Click 'Add visualization'.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FT9Pq7Hh6Q7YFN6rH5535%2Fimage.png?alt=media&#x26;token=2d533d0f-7c86-4737-a09c-58545076a77d" alt=""><figcaption></figcaption></figure>

#### Select the data source.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FBUcALVf7nDwYAG7EvyrP%2Fimage.png?alt=media&#x26;token=8ff471af-7541-45de-ab0d-dfb82ee645e5" alt=""><figcaption></figcaption></figure>

#### This opens the basic dashboard screen.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2F21DqjqneIYZZWUpsy9bj%2Fimage.png?alt=media&#x26;token=b0904af1-13cf-4b36-83da-c5f47b5bc88a" alt=""><figcaption></figcaption></figure>

#### Add your query and then click 'Run query'.

For example

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FnyEWoyeSpn0sBIAcUfRG%2Fimage.png?alt=media&#x26;token=4e6ec4b5-4d5b-42bf-817a-957078cffcb2" alt=""><figcaption></figcaption></figure>

#### Editable Format

```python
SELECT
    $__timeGroup(time, $__interval) as Time,
    AVG("$__column") as Alt
FROM
    "$__table"
WHERE
    $__timeFilter(time)
GROUP BY
    $__timeGroup(time, $__interval)
ORDER BY
    Time ASC

```

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FJyrsXUQZygLKcjTzzG2X%2Fimage.png?alt=media&#x26;token=21ba444c-3d48-4b30-b28b-fbbb4b513f1b" alt=""><figcaption></figcaption></figure>

#### The Dashboard is created.

<figure><img src="https://1612018018-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTCRfbN5hBLeUzIaKHbJ7%2Fuploads%2FxHDQeGvnIzCWA6tTmfn1%2Fimage.png?alt=media&#x26;token=309e5e6a-ffa1-4d4a-b09d-06d45c548489" alt=""><figcaption></figcaption></figure>