> ## Documentation Index
> Fetch the complete documentation index at: https://docs.exploratory.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Aurora Data Import

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://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/import/images/aws-security-group.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=182b16b7106b5d85b3f3ffd5c251435a)

## 2. Create a Connection to use

Create a connection following [this instruction](https://docs.exploratory.io/en/import/connection.html.md).

* 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://mintcdn.com/exploratory-inc/w_BKR9NcFwjvyQXp/en/import/images/import-database.png?fit=max\&auto=format\&n=w_BKR9NcFwjvyQXp\&q=85\&s=49072dc21685823884ca5dd29d8595cf)

Click Amazon Aurora.

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/import/images/aurora.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=95580e14cb43cf343806b53b97810f64)

## 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://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/import/images/aurora-import.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=541c4d476ce6769ad83d16eb648b6939)

## 4. Using Parameters in SQL

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

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/import/images/add_parameter.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=36e0536377b7020f271cfe3ade161c80)

Second, define a parameter and click Save button.

![](https://mintcdn.com/exploratory-inc/w_BKR9NcFwjvyQXp/en/import/images/define_parameter.png?fit=max\&auto=format\&n=w_BKR9NcFwjvyQXp\&q=85\&s=1fc9d0b8803efcc782f5575d9b94ebd0)

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://mintcdn.com/exploratory-inc/7Kn_H2bJDKm3Jv90/en/import/images/insert_param_in_query.png?fit=max\&auto=format\&n=7Kn_H2bJDKm3Jv90\&q=85\&s=01377085ff3712dd98c42cb6f8044cf0)

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://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/import/images/sql_number_of_rows.png?fit=max\&auto=format\&n=t8wulpy3B474-b7T\&q=85\&s=93b2478a659616e383ff2704fdaa8125)

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

![](https://mintcdn.com/exploratory-inc/7Kn_H2bJDKm3Jv90/en/import/images/num_of_rows_config_menu.png?fit=max\&auto=format\&n=7Kn_H2bJDKm3Jv90\&q=85\&s=af6d606401cd4a424960d5d725c26e72)

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

![](https://mintcdn.com/exploratory-inc/7Kn_H2bJDKm3Jv90/en/import/images/num_of_rows_config.png?fit=max\&auto=format\&n=7Kn_H2bJDKm3Jv90\&q=85\&s=41dd4780173eef007b2edf1607357bcf)

This will show you Actual Number of Rows like below.

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/import/images/actual_num_of_rows.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=8d6aa5cd6a05dc5e1d7805865d47445c)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.