Ask your Redshift data about the business instead of writing SQL.
Give Adea a user that can only read and ask about orders, sessions or margin. Each answer comes with the query behind it.
You can connect Amazon Redshift today.
What Adea reads from Amazon Redshift
- Schemas and tables the user can read
- Fact and dimension tables as your team has modelled them
- Totals and trends, read with plain SELECT queries
- Late-binding views, where your team uses them
What you can ask
You ask
Which regions grew fastest in Q3?
Adea answers
The Nordics grew 18 percent to €1.42 million. Germany added the most in absolute terms, €310,000, while Spain was flat.
You ask
How many orders shipped late in September?
Adea answers
412 of 9,860, 4.2 percent. 261 of the late ones came from the north warehouse.
Questions about Amazon Redshift
How does Adea connect to Redshift?
You create a user with read rights only and give Adea the details. Adea checks that it cannot write, and connects from fixed addresses you can allow in the cluster's security group.
Can Adea change my cluster or data?
No. It only reads.
Will every answer show where it came from?
Yes. Adea shows the query, so your analyst can check it.
