# Should I use with a data mart for a frontend tool that make request on it ?

We had an internal reporting tools that were used to make analysis on the data and we were running the query directly on it. But if the data scientists are using Redshift at the same time, it could affect the tools response time.

##### Post Metadata
- Posted at: over 6 years ago
- Author title: Freelance React, React Native  - En recherche de missions
- Net upvotes: 3


## Comments
### Comment 1

Yes you can use it.

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: IT Consultant - DB Dev, SQL programmer, ETL, Data Miner, Data Scientist



### Comment 2

Hi Mehdi, You can use the data mart with AWS as to get the data from multiple channels simultaneausly. I would suggest use Dbeaver data mart should be ideal for Redshift.

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Analytics Consultant in (R&A)



### Comment 3

Hi Mehdi 

Can you elaborate your question? 

AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases. 

You can store data and query at very low latency, assuming you Distribute and Sort the data optimally and that the Redshift is multi Node. 

You can use SQLWorkbenchJ to query the data and run ad-hoc queries. Also you can connect Redshift to Numerous Dash boards or Visualization tools like: Tableau / Looker, etc. 

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Sr Data Engineer




## Related Product
[Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews)

## Related Category
[Data Warehouse](https://www.g2.com/categories/data-warehouse)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4