If you are an Enterprise customer, contract us to securely acquire your access information and credentials. You will receive:
Your results output location
You will need a SQL client that support JDBC drivers. Our favorite is DataGrip because it supports a wide range of databases out of the box. But any client that succeeds with this setup guide will work!
Download the Athena JDBC driver here: https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
Follow these instructions from JetBrains. If you are using DataGrip, this will be even easier for you. If you are not, you should be able to map their instructions to your SQL client.
Set the exact driver mentioned (
In the advanced set up, set
S3OutputLocationas the one given in your credentials. It should be in the format
Analytics are provided by AWS Athena, which is a database based on PrestoDB. You can find usage and syntax documentation online. It has a SQL interface, so if you know SQL, much of it should familiar. If you plugging data into a business intelligence / data analysis tool, it should work fine too.
Every table name must be globally unique, so each table name is prepended with the organization. For example the runs table, will be firstresonance_io_runs for the firstresonance organization. Also in order to optimize queries the tables have flattened relationships so that users do not have to run time consuming joins to calculate needed properties. Below is a list of the currently available analytics tables.
Count of runs grouped by status:
SELECT status,count(id)FROM firstresonance_io.firstresonance_io_runsGROUP BY status;
Time statistics on the execution of a particular step in runs.
selectavg(date_diff('second', start_time, end_time)) as avg_seconds,stddev(date_diff('second', start_time, end_time)) as std_dev_seconds,updated_by_emailfrom firstresonance_io.firstresonance_io_run_stepswhere end_time is not nulland started_by_id = updated_by_idand origin_step_id = 1group by started_by_id, updated_by_emailorder by avg_seconds
Cumulative issue count and percentage grouped by part number:
selectcumulative_sum / max(cumulative_sum)over (order by count) * 100 as percentage,count, part_number, cumulative_sumfrom (selectcast(count(i.id) as double) as count,cast(sum(count(i.id))over (order by count(i.id) desc, r.part_part_number asc)as double) as cumulative_sum,r.part_part_number as part_numberfrom firstresonance_io.firstresonance_io_issues ijoin firstresonance_io.firstresonance_io_runs ron r.id = i.run_step_run_idwhere r.part_part_number is not nullgroup by r.part_part_number)order by count desc
In progress. Have more queries? Share them with us. We'd love to showcase your work.