> For the complete documentation index, see [llms.txt](https://fluid-ai.gitbook.io/fluid-ai-frontier/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://fluid-ai.gitbook.io/fluid-ai-frontier/processing-and-pipelines/individual-pipelines/fetch-data-from-db.md).

# Fetch Data from DB

{% embed url="<https://youtu.be/XPGJfP9ifoU>" %}
Quick tutorial on Fetcher
{% endembed %}

### Steps to follow&#x20;

1. From the `Processing & Pipelines` module select `Build Pipelines` section.
2. Click the `Fetch Data from DB` button, a popup appears.
3. Frontier allows two option to store the fetched data from database :
   1. `Add a new file` allows user to create a new file when the file doesn't exist in frontier system.
   2. `Modify a pre existing file` allows user to update the old file from the new updated file on the database.
4. Frontier allows two options to fetch data from the database :&#x20;
   1. `Normal Fetch Operation` allows user to write normal select queries from the database.
   2. `Query in Fetch Operation` allows user to combine two or more tables to join them and extract into frontier system. The source key and the file name that has the common key should be given.
5. After the query is written, the `Preview Data button` can be used to check if the connection works and will the data get reflected in the Frontier.
6. Click `Save` button to save the pipeline, or `Save & Execute` button to execute the pipeline right away.

### Walkthrough

{% embed url="<https://www.loom.com/share/d08ddc37c590447aa3c54c0506cd29ee>" %}