Donnie Roberson

By now you’ve probably heard that DataStax Enterprise (DSE) is now 2x faster. If not, check out <a href="https://www.datastax.com/2018/04/datastax-enterprise-6-the-distributed-cloud-database-designed-for-hybrid-cloud">Robin Schumacher’s DSE 6 blog</a> for a wealth of details on all the new features DSE 6 brings to the table.

But DSE isn’t the only thing that’s 2x faster. By taking advantage of the new Advanced Performance features as well as DSE Analytics AlwaysOn SQL, now anyone can visualize their data 2x faster compared to previous DSE versions when using the Spark SQL connection in Tableau.

To explain….

Our brains process visual information very efficiently.

Here’s a little test. Which of the following is easier to analyze? <img alt="" src="https://www.datastax.com/sites/default/files/content/blog/fig.-1-Tableau-blog-700x104.jpg" />

<img alt="Our brains process visual information very efficiently. Here’s a little test. Which of the following is easier to analyze? The visual graph right?" src="https://www.datastax.com/sites/default/files/content/blog/fig.-2-Tableau-blog-700x452.jpg" title="Visualize Your Data 2x Faster With Tableau - example 1" /> The visual graph right? (If you prefer the tabular format, this blog isn’t for you. Everyone else, keep reading.)

If we can feed Tableau data twice as fast, we greatly improve our ability to visualize even the most complex data sets quickly and efficiently and thus are truly offering <a href="https://www.datastax.com/wp-content/uploads/resources/reports/ESG-Solution-Spotlight.pdf">contextual insights in real-time.</a>

<h2>The Journey to 2x</h2>

Users have always been able to use the Simba Spark ODBC driver to create a connection with Tableau. But in the past, SQL access in DSE used different services. &nbsp;

For example, in DSE 5.1, SQL access was handled by the Spark SQL Thriftserver. There are a variety of reasons that make the Spark SQL Thriftserver a less desirable ODBC/JDBC service, among them being that the fact that the Spark SQL Thrift Server is not highly available and requires the administrator to manually start and monitor its state. In light of this, we designed AlwaysOn SQL to address the shortcomings of the other approaches and offer a production-ready, enterprise-grade ODBC/JDBC service in DSE 6.

We also worked with <a href="https://magnitude.com/">Magnitude</a> (previously Simba), who provides our ODBC/JDBC drivers, to enhance the ODBC/JDBC driver to allow Spark SQL to seamlessly use the AlwaysOn SQL REST API.

To learn more about AlwaysOn SQL and its history, check out <a href="https://www.datastax.com/2018/05/introducing-alwayson-sql-for-dse-analytics">Brian Hess's AlwaysOn SQL blog</a>. If you have questions, leave a comment or reach out to us at <a href="mailto:techpartner@datastax.com">techpartner@datastax.com</a>.

<h2>This leaves one thing left to do!</h2>

Take this for a test drive and see the difference for yourself. Check out this <a href="https://academy.datastax.com/content/visualizing-your-data-tableau-using-dse-6-docker-images">tutorial</a>, which offers simple, step-by-step instructions on how to create a simple Tableau workbook with data stored in DSE.&nbsp;

Visualize Your Data 2x Faster With Tableau

Donnie Roberson

Discover more

Share

Share

The Journey to 2x

This leaves one thing left to do!

More Technology

Knowledge Graphs for RAG without a GraphDB

How Winweb Built its AI Assistant with DataStax Astra DB and LangChain

Vercel + Astra DB: Get Data into Your GenAI Apps Fast

Simplifying Agent Development with Astra DB Connector for Vertex AI Search

One-stop Data API for Production GenAI