Playground: Interactively Explore Production Data

Our Playground is Arkham's interactive SQL editor, designed for the final and most critical phase of the data development lifecycle: validation and exploration. It provides a powerful and intuitive interface for querying the trusted, Production Datasets you've built, enabling you to rapidly validate your work, debug issues, and extract valuable insights.

As an integral part of our Arkham platform, the Playground is the primary environment for ad-hoc analysis, where builders can immediately interact with the high-quality data they have just created.

How It Works: Querying Your Production Datasets

Playground provides a seamless bridge from the Production Tier of your Data Catalog to the underlying query engine. This allows you to instantly query your new datasets without switching contexts or tools.

Key Technical Benefits

  • Direct Integration with Data Catalog: Our Playground is seamlessly integrated with our Data Catalog, allowing you to browse and search for datasets directly within the editor. It intelligently prioritizes Production-tier datasets, ensuring you're querying the right data.
  • Powerful SQL Editor: Our Playground features a modern SQL editor with syntax highlighting, autocompletion, and query formatting. It also supports the use of decorators to reference datasets, making your queries more readable and maintainable.
  • Seamless Exporting: With a single click, you can export the results of any query to a CSV file. This allows you to easily share findings, create reports, or pull data into local tools for further analysis.
  • Performance at Scale: The Playground is built on a robust query execution engine that is designed to handle large datasets and complex queries. This ensures that you can get the answers you need, when you need them, without having to wait for long-running queries to complete.

AI-Assisted Discovery with TARS

In our Playground, TARS can accelerate your data exploration by helping you formulate queries and understand data. This allows builders to get to insights faster and empowers decision-makers to ask complex questions of their data in plain English. For example:

  • "Write a query to count the number of users by country from the @production_users table."
  • "What's the average value of the order_total column in the @quarterly_sales dataset?"
  • "Explain the logic of this complex SQL query."

See how Data Connectors feed the rest of the platform:

  • Data Platform Overview: Understand how the Data Catalog acts as the central hub in the data workflow.
  • Data Catalog: Discover and understand the trusted Production datasets available for querying.
  • Pipeline Builder: Consumes data from the Staging Tier and publishes trusted datasets to the Production Tier.
  • Workbooks: Promote your ad-hoc queries from the Playground into polished, interactive reports.
  • TARS: Your AI co-pilot for intelligent data discovery, schema exploration, and lineage tracing.