Datarow : Redshift Client Tool

DataRow is gathering all the needs of all software developers, data analysts and data scientists working with Amazon Redshift on a single platform.

Featuring BI and Notebook features, DataRow focuses on performance enhancement, analysis and visualization of data, beyond routine SQL queries.

Centralized Solution
DataRow runs from any browser and saves you the trouble of installing software or keeping it up to date. The entire team accesses your company’s database from a single point and all access is managed by the administrators of this single point.

Easy Collaboration
With DataRow‘s cloud storage features, you can organize your workspace as you wish, and easily share your saved SQL codes, charts, and notebooks with team members and your organization.

3-In-One Hub
Data analyst, data scientist, or database administrator — you’ll find the right tools and features you need for Amazon Redshift, regardless of your role in the organization. You can easily query your Amazon Redshift database, generate graphs & charts using the query results, or create and share documents on a notebook that contain live visualizations.

Depending on your intended use and company policies, you can choose from two versions of DataRowCloud & On-premise

With the Cloud version, you can immediately start using the servers that DataRow will provide you. To start using the cloud version, click the link below:

https://app.us.datarow.com/signup

You can install the DataRow on your AWS server in the On-premise version and manage it yourself. To request an on-premise version, fill out the form using the following link:

https://go.datarow.com/datarow-e…

Both versions of DataRow has the same features:

Store, organize and share SQL queries on the cloud.
Being able to collaborate on queries is an essential part of data analytics teams and often requires 3rd party solutions to be implemented in data projects. DataRow’s hassle-free collaboration tools make it easy to share work with individuals or teams within your organization.

Export as CSV, attach in email, or just click share it via URL.
In case you need to share a result set with a colleague, all you need to do is to click on “Share Data” to create a URL which contains the dataset with ability to be refreshed upon request or periodically.

Git-like versioning experience without the need for git experience
When SQL codes are shared with colleagues, it is necessary to keep track of every change on those queries. DataRow simplifies code versioning so that every member of your analytics team can use it without knowledge of any 3rd party code versioning system.

Search and access your query history and monitor resource usage
DataRow keeps logs of every query run by your users and provides detailed resource usage charts for each query so that you can leverage that information to optimise queries and increase their performance.

Process, analyze your data and create models with your favourite language
DataRow is not only about running SQL queries. It integrates to Apache Zeppelin at the backend so that you can seamlessly create notebooks based on your result sets, run Python, R or any other supported language to further process and analyze your data or create models using popular ML libraries.

1-Click Data Storytelling
You can inject Markdown content into your notebook to create a compelling story based on your data and analysis, and publish all the content as URL to share the results of your work.

Visualize your data with an intuitive user interface
Most of the times, results of your SQL queries might be sufficient to create a compelling visualization without further data processing and modelling. DataRow Charts helps you to create stunning charts and dashboards just with a few clicks.

Export your charts & dashboards to the web
You can easily share your visualizations to your colleagues in DataRow, or to anyone by creating a shareable URL with the static of refreshable data.

Management tool for Amazon Redshift
Every great database should have a great user interface for development and management. DataRow’s built-in Redshift management capabilities make it easy to manage and monitor your clusters.

  • Users and Groups management
  • Table and function design editors
  • Ability to configure documented Redshift cluster settings
  • Cluster resource monitoring
  • Graphic based query execution details
  • Ability to access Redshift system files.

Copy & Unload Manager
COPY and UNLOAD process don’t have to be that complicated. Moving data in / out are one of the most frequently triggered operations in Amazon Redshift.

Instead of on-demand construction of those commands which often requires time-consuming documentation reading, you can build your COPY and UNLOAD configurations using a graphical user interface, store for future use and run on demand or periodically.

ENTERPRISE FEATURES

SAML authentication
If you’re setting up DataRow for a large team, you don’t need to worry about setting up the accounts for your team members.

DataRow easily integrates with Azure AD and Okta, letting your users start using DataRow within minutes.

Roles & Permissions
It’s important to enable data access for every stakeholder while ensuring the integrity of your Amazon Redshift cluster and governing your data.

You can create roles with a list of granularly defined permissions to access DataRow features and functionalities.

Conclusion: If you’re using Amazon Redshift or are planning to migrate from another database, DataRow is for you. There is an agile engineer team behind this powerful product. With almost every week updates and new features, you’ll see your work getting easier every day. DataRow will save you time and cash.

DataRow – Database Management Studio Built for Amazon Redshift

Author: Aditya Bhuyan

I am an IT Professional with close to two decades of experience. I mostly work in open source application development and cloud technologies. I have expertise in Java, Spring and Cloud Foundry.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s