This sample contains a docker-compose.yml and Presto configs for running Presto in Docker with Metabase and ScyllaDB.
The following example uses simple schema and data for online merch store in ScyllaDB. Presto is used to query data from ScyllaDB and Metabase is used to visualize the data.
Prerequisites
Procedure
- Run
docker-compose up -d
to start the containers - Wait for about minute for ScyllaDB to start and Metabase to initialize.
- Generate schema and data:
make prepare_data
. - Open Metabase at http://localhost:3000 and complete admin onboarding.
- Add Presto as a data source in Metabase.
Use
presto
as a host,8080
as a port,scylladb
as a catalog name andmerch_store
as schema name. During filling presto connection details fillUsername
with arbitrary string and leave userPassword
empty. - Observe goods, users and transaction insights in Metabase. For example from home screen do:
- Click on "Browse data" button
- Choose created Presto data source
- Select merch_store schema
- Open Transactions table
- On the right top Click green "Summarize" button
- Select Group By "Transaction Date" and Sum by "Total Amount"
- Save "Question"
Cleanup
- Run
docker-compose down --volumes
to stop and remove the containers and created volumes