We are pleased to share that DataRow is now an Amazon Web Services (AWS) company. We're proud to have created an innovative tool that facilitates data exploration and visualization for data analysts in Amazon Redshift, providing users with an easy to use interface to create tables, load data, author queries, perform visual analysis, and collaborate with others to share SQL code, analysis, and results. Together with AWS, we look forward to taking our tool to the next level for customers.

Meaningful Execution Plans

DataRow’s approach to the EXPLAIN command completely changes, speeds up and simplifies the way we work. With automatic syntax application and visual outputs, you can get the most from your data.

The Old Way

explain select eventid, eventname, event.venueid, venuename from event, venue where event.venueid = venue.venueid;
QUERY PLAN ------------------------------------------------------ XN Hash Join DS_DIST_OUTER (cost=2.52..58653620.93 rows=8712 width=43) Hash Cond: ("outer".venueid = "inner".venueid) -> XN Seq Scan on event (cost=0.00..87.98 rows=8798 width=23) -> XN Hash (cost=2.02..2.02 rows=202 width=22) -> XN Seq Scan on venue (cost=0.00..2.02 rows=202 width=22) (5 rows)

The DataRow Way

Auto EXPLAIN Command

Just a button click performs the EXPLAIN Command; DataRow executes the query to perform the EXPLAIN Command and makes it ready for you.

EXPLAIN Graph

With the visual output of the DataRow’s EXPLAIN Graph, you can interpret your Query Plan at a glance. The graphical output created with the Cost, Rows, and Width metrics will make your work very comfortable.

EXPLAIN Steps

You can see the Steps of the EXPLAIN Command, and the Query Plan created.

DataRow provides you with a more understandable explanation of each step. You can instantly see the easy description of each step.

Get Started

Whether you’re looking for a Private Cloud or Enterprise solution, DataRow has the resources and expertise to help you achieve more with your Amazon Redshift.

Go to Support