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

Question

MC

Freelance React, React Native - En recherche de missions

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

Asked over 5 years ago

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.

Data Warehouse Software

Comment

3 comments

3

Looks like you’re not logged in.

Users need to be logged in to answer questions

Log In

SenthilNathan P. · Answer 1 · 2022-03-27T16:58:29-05:00

SP

SenthilNathan P.

IT Consultant - DB Dev, SQL programmer, ETL, Data Miner, Data Scientist

0

Answered almost 3 years ago

Yes you can use it.

delete edit

Looks like you’re not logged in.

Users need to be logged in to write comments

Log In

Reply

Akshaya B. · Answer 2 · 2019-12-05T11:36:28-06:00

AB

Akshaya B.

Analytics Consultant in (R&A)

0

Answered about 5 years ago

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.

delete edit

Looks like you’re not logged in.

Users need to be logged in to write comments

Log In

Reply

Narayan M. · Answer 3 · 2019-12-02T13:11:14-06:00

NM

Narayan M.

Sr Data Engineer

0

Answered about 5 years ago

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.

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

About Amazon Redshift