> For the complete documentation index, see [llms.txt](https://docs.exploratory.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.exploratory.io/data_import/database-data/aurora.md).

# Amazon Aurora

You can quickly import data from your Amazon Aurora Database into Exploratory.

## 1. AWS Security Group Setup

Make sure you added your client PC's IP address to your DB Security Group associated with the Aurora database instance.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN8VdKzRdaPgEHSxA%2Faws-security-group.png?generation=1586795464432102\&alt=media)

## 2. Create a Connection to use

Create a connection following [this instruction](https://docs.exploratory.io/data_import/database-data/connection).

* Whether the connection is SSL or not is automatically detected.

## 3. Open Aurora Import dialog

Click '+' button next to 'Data Frames' and select 'Import Database Data'.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN-qBMezITjny_pQQ%2Fimport-database.png?generation=1586795453631702\&alt=media)

Click Amazon Aurora.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNAntBMX2oV0PByXc%2Faurora.png?generation=1586795473065141\&alt=media)

## 4. Preview and Import

1. Select connection from left box in the dialog.
2. Write a query in the input field.
3. Click "Preview" button. Then you will see the preview of the data.
4. Click "Save" button to import.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oNAnv0G4vPoa5cuTy%2Faurora-import.png?generation=1586795473284603\&alt=media)

## 4. Using Parameters in SQL

First, click Parameter link on the SQL Data Import Dialog.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN2yAtTsqxNt3r0_M%2Fadd_parameter.png?generation=1586795457457840\&alt=media)

Second, define a parameter and click Save button.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN2yC4K_GmMFFjzoo%2Fdefine_parameter.png?generation=1586795457181349\&alt=media)

Finally, you can use @{} to surround a variable name inside the query like below.

```
select *
from airline_2016_01
where carrier = @{carrier}
```

If you type @ then it suggests parameters like below.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN2yEXevqQptAWUEl%2Finsert_param_in_query.png?generation=1586795457117048\&alt=media)

Here's a [blog post](https://exploratory.io/note/kanaugust/An-Introduction-to-Parameter-in-Exploratory-WCO4Vgn7HJ) for more detail.

## 5. Number of rows

From performance point of view, we no longer show actual number of rows which can be only fetched by executing whole query again.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN66xWkcCxqo19jUZ%2Fsql_number_of_rows.png?generation=1586795460160662\&alt=media)

If you still want to show the actual number of query for your query, you can do so by setting System Configuration.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN66zCHttnANqtQHx%2Fnum_of_rows_config_menu.png?generation=1586795459932943\&alt=media)

Then set "Yes" For "Show Actual Number of Rows on SQL Data Import Dialog"

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN670aVGCuTHA4oG4%2Fnum_of_rows_config.png?generation=1586795460286823\&alt=media)

This will show you Actual Number of Rows like below.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN6725Fzzj5A208wn%2Factual_num_of_rows.png?generation=1586795460230058\&alt=media)