Designed to facilitate Cassandra Query Language (CQL), Graph/Gremlin, and Spark SQL language development, DataStax Studio has all the tools needed for ad hoc queries, visualizing and exploring data sets, profiling performance and comes with a notebook interface that fuels collaboration.
Query profiling for CQL, Gremlin (Graph) and Spark SQL provides diagnostic information and execution plan details that enable you to tune queries for fast performance.
Rich data visualizations and numerous output formats enable you to surface insights and interact with your data, and produce publication-quality graphics.
Through its shareable notebook interface, DataStax Studio enables collaboration via the ability to create tutorial-style notebooks that can be imported and exported with a click of a button.
DataStax Studio enables developers to query, explore, and visualize CQL and DSE Graph data with ease. To bolster developer productivity, we’re thrilled to release DataStax Studio 6, which is loaded with improvements. Let me give you a quick tour of all that’s new in DataStax Studio 6. Simplified Collaboration As developers interact with Studio, they see the high business value of collaboration. One of the most requested features is the ability to export and import Studio notebooks. The Studio import/export feature allows you to export your finely-tuned, purpose-built notebooks, and import ones that have been shared with you. Use cases for sharing notebooks are plentiful, including improving collaboration, backing up notebooks, and distributing tutorials. Fig 1: Notebook Export/Import Track Changes Keeping track of changes within notebooks is critical. The Notebook History feature gives you the opportunity to easily browse the history and revert to previous checkpoints. Using DataStax Studio, you can: Track changes within a notebook Tag and preview notebook revisions Revert to previous checkpoints if necessary Fig 2: Revision History Support for DSE Analytics and Spark SQL As part of our continued journey to enable Studio support of all advanced DSE workloads, Studio 6 supports writing Spark SQL queries, which means you now have a visual and intelligent interface and query builder that helps you write Spark SQL queries and review the results. DataStax Studio also increases productivity by providing: Syntax highlighting to signal potential typos Schema-aware content assist to eliminate context switching between writing queries and checking database object names Code completions and code snippets for writing queries faster Validations to help eliminate errors before query execution Fig 3: Spark SQL Queries Visual Interactive Graphs To provide an interactive graph experience, DataStax Studio allows you to visually explore DSE Graphs without being a Gremlin Ninja. Flexible options support easy expansion of vertex neighborhoods and removal of vertices/edges from view for a seamless DSE Graph Exploration. Fig 4: Interactive Graphs Download DataStax Studio 6 We know you’ll be happy with all the new goodness in Studio 6, so download it today and let us know what you think. If you are upgrading from an earlier version of Studio, read and follow the required steps in upgrade notes.
Whether you are new to CQL, Graph/Gremlin, or Spark SQL or a seasoned veteran, Studio’s syntax validation and content assist ensures that you get the query right the first time and removes the extra hop of referencing external documentation when writing your queries.
Often times a query may take longer to execute than expected. Through tracing and profiling visualizations, DataStax Studio lets you dig into the specifics of a request's execution to identify potential bottlenecks in the execution life cycle.
Graph is all about data relationships and DataStax Studio’s Graph View lets you explore and visualize those connections. The view can also be customized to size vertices and edges by customizable attributes, providing further insight into the characteristics of your graph.
DataStax Studio sports a schema viewer that allows you to dive into the database schema and view visual representations of your database objects.
Developing an application? We have you covered.