# Dremio

{% hint style="info" %}

### **What is Dremio?**

Dremio is a data lake query engine that delivers  fast query speed and a self-service semantic layer operating directly against a data lake storage.
{% endhint %}

### Prerequisite

You must have Glue Catalog integrated with Dremio. Follow instructions [here](https://docs.dremio.com/data-sources/aws-glue-catalog.html) if you haven't integrated.

## Create a new data output

1\. Create a new data output by clicking on **Output** and **New Output**.

![](https://1488427404-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MAbbZ6XL3iXMHb3pjqP%2F-MGUK1fJQxJwm91bi2ra%2F-MGUTT5uIz_dtqxPgQW3%2FScreen%20Shot%202020-09-05%20at%2011.12.59%20AM.png?alt=media\&token=e54576ff-5b09-4f45-ba8d-aba3dc4db17d)

2\. Select **Dremio** as your output.

![](https://1488427404-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MAbbZ6XL3iXMHb3pjqP%2F-MXUzYFnIQyxO4GqXin5%2F-MXUzjcoXPCQQsl3lWLp%2Fimage.png?alt=media\&token=2d5ca6e1-cc35-415a-be73-78359ddad7f2)

3\. Provide a name for the data output. In this case, we will use the name `dremiotest`. Make sure it’s mapped to an existing data source; then click **Next**.

4\. Choose the columns that you want to output to Dremio. By clicking on the plus icon<img src="https://1488427404-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MAbbZ6XL3iXMHb3pjqP%2F-MEeHKG2Luylo94DV_jK%2F-MEeHzldfai6mexRAIfO%2FScreen%20Shot%202020-08-13%20at%205.06.39%20PM.png?alt=media&#x26;token=fc8425de-ec62-4fe1-b7e1-12cf0ae566a8" alt="" data-size="line">next to the field name.&#x20;

Add the following columns:&#x20;

* `aged_70_older`&#x20;
* `continent`&#x20;
* `date`&#x20;
* `new_cases`
* `population`&#x20;

![](https://www.upsolver.com/wp-content/uploads/2020/07/Screen-Shot-2020-07-07-at-13.21.59.png)

{% hint style="info" %}
There are many powerful capabilities available such as **aggregations**, **filters**, **calculations**, **lookup tables for joining**, and more. These features will be covered on a later guide.&#x20;
{% endhint %}

5\. Click **Preview** to check that the output data is as expected, then click **Run**.

![](https://1488427404-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MAbbZ6XL3iXMHb3pjqP%2F-MGUTWKzAw-G9z4OvOZd%2F-MGUUQFgIUurGiTgaRfe%2FScreen%20Shot%202020-09-05%20at%2011.16.29%20AM.png?alt=media\&token=95cb39bc-ee7a-47d1-944d-1a270011c4d9)

6\. Make sure an existing Dremio database is available for the output. If not, create a new database.&#x20;

7\. If you have not configured a glue catalog connection, create a glue catalog connection by clicking on **Create your first Glue Data Catalog Connection**

![](https://1488427404-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MAbbZ6XL3iXMHb3pjqP%2F-MXV-Pv6GMWROarQMH88%2F-MXV-kZjVhgVdI5yfaoz%2Fimage.png?alt=media\&token=96353a2a-a97a-448f-b0f0-2d7a70a31463)

8\. Fill out the Dremio database and table information for output then click **Next**.

9\. Choose the time period for the data that you want to load then click **Deploy**.
