Summary: A description of various methods for obtaining usage information for your data warehouse, including the graphs on the Dashboard and the reports available via the Slack ReportBot.
How many events is Alooma loading into my data warehouse? Can you show me that by date? By table? What's the latency for getting my data into the warehouse?
To answer questions like these, Alooma provides two ways to track usage for your data warehouse: via the graphs on the Dashboard, and through the reports available via the Slack ReportBot.
Click on the Dashboard icon in Alooma to view the Dashboard graphs. Here you can see information about Throughput, Latency, Events over time, and the Incoming and Restream queues.
In general, the graphs are great for spotting trends and getting a good look at what's happening on your system. However, because of the real-time nature of the system, occasionally, a very small number of updates to the data may not be reflected in the graphs.
ReportBot allows you to get reports on your deployments directly from the meta tables if you have an Alooma Slack channel (Enterprise customers).
Currently, ReportBot can provide the following reports for Redshift and Snowflake output, to retrieve information up to and including the current day:
Events Loaded by Date and Table
Events Loaded by Date
Events Loaded by Table
Reports 2 and 3 are just versions of report 1, aggregated by a specific date/table.
Last Batch Loaded at: When was the last time we loaded events for each table?
And for BigQuery, output to retrieve information up to the end of the previous day:
Events Loaded by Date
So, now you're probably wondering how to use ReportBot.
You use ReportBot in your Alooma Slack channel, so first you'll need to invite @ReportBot to your channel (yours looks something like this: #alooma-<CUSTOMERNAME>).
Once you've invited @ReportBot, you can request a report:
@ReportBot report x
Where x is the number of days you want the report to cover (maximum is 365). If x is not specified, the default is the last 7 days. Don't worry, if you get it wrong ReportBot will show you the correct usage:
After you request a report, you'll see a menu with the possible reports available to you. Make your selection and the report is uploaded in .csv format to the channel.
This only works on channels hosted in Alooma's workplace. ReportBot does not yet support Slack's shared-channel functionality.
Here's an example of the .csv file for events loaded over the last 7 days.
date,events_loaded 2017-11-27,3433524 2017-11-28,3665221 2017-11-29,4128162 2017-11-30,1199480 2017-12-01,3096248 2017-12-02,2228221 2017-12-03,2410643
If you have further questions about usage or if you can't find the data you're looking for, we're here to help.