> 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.

![](/files/-M4oN8VdKzRdaPgEHSxA)

## 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'.

![](/files/-M4oN-qBMezITjny_pQQ)

Click Amazon Aurora.

![](/files/-M4oNAntBMX2oV0PByXc)

## 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.

![](/files/-M4oNAnv0G4vPoa5cuTy)

## 4. Using Parameters in SQL

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

![](/files/-M4oN2yAtTsqxNt3r0_M)

Second, define a parameter and click Save button.

![](/files/-M4oN2yC4K_GmMFFjzoo)

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.

![](/files/-M4oN2yEXevqQptAWUEl)

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.

![](/files/-M4oN66xWkcCxqo19jUZ)

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

![](/files/-M4oN66zCHttnANqtQHx)

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

![](/files/-M4oN670aVGCuTHA4oG4)

This will show you Actual Number of Rows like below.

![](/files/-M4oN6725Fzzj5A208wn)