​
Overview

Turntable has three components:

  1. Vinyl - a python framework for building and managing analytics infrastructure.
  2. Midi AI (coming soon) - an AI data analyst assistant that works with Vinyl to help you with basic analysis tasks and surface insights in record time.
  3. Turntable Cloud - managed CPU and GPU compute to help you run intensive data workloads and sub second queries.

​
Our Philosophy

We believe that analytics infrastructure should:

  • Be declarative and code-backed
  • Embeddable in the latest BI tools and data products
  • Leverage AI to help surface insights and automate repetitive tasks
  • Be scalable, cost-effective, and use the latest query engines for sub second queries

​
Who is Turntable for?

  • Data scientists

  • Developers with data tasks

  • Technical co-founders

  • Analytics Engineers who know Python or want to learn it

​
What makes Vinyl unique?

FeatureDescription
Only PythonVinyl is built for Python developers and data scientists. It’s as pythonic as possible, and can integrate with your existing Python codebase. No SQL or Jinja templates required.
Cross-dialectVinyl supports multiple SQL dialects under the hood and can be used with many data warehouses with the same code. You can use DuckDB at first and switch to Snowflake or BigQuery as you scale, or even preview your data locally.
FederatedVinyl can be used to query multiple data sources at once, including data warehouses, data lakes, local files, and even existing DBT projects. Importing data sources is dramatically easier than with existing data modeling frameworks.
Built for metricsVinyl includes powerful abstractions for time series operations. Metrics are deeply integrated into the framework and have syntax that closely mirrors basic aggregation. No need to learn javascript or specialized Jinja syntax.
Column-awareVinyl objects carry far more context than just the data they represent, including schema and column lineage information. Users simply annotate their sources, and Vinyl can automatically infer join columns, cascade down documentation, mask PII, and more.
End-to-endVinyl provides a single framework for data analysis, data transformation, and semantic modeling. You can use Vinyl for almost any data task without relying on another tool or framework.
Available anywhereVinyl allows you to publish your models and queries to any BI tool – even in your product – using a simple postgres or REST API.
Built for AIVinyl is designed to work with AI. At first, you will be able to use AI transforms seamlessly in your pipeline. In the near future, MIDI will be able to automate analytics tasks. The features described above are good for humans, but also are designed to enable dramatically better AI experiences than today’s Text-to-SQL bots.

​
Who might not be a good fit for Turntable?

  • Companies with very large datasets for whom incremental materialization is necessary

  • Companies were data practitioners can’t use Python and would not want to learn it.

Vinyl stands on the shoulders on several awesome projects and, we couldn’t have built it without them. Here are our most important dependencies and inspirations.

SourceTypeFoundedRelation to Vinyl
IbisDependency2015Core dependency in Vinyl. Under the hood, Vinyl code compiles to Ibis code.
DuckDBDependency2019Default DB engine in Vinyl. Used for all file and many data lake connections.
SQLglotDependency2021Core dependency of Ibis. Ibis code compiles to SQLglot code, which in turn compiles to SQL.
dplyrInspiration2014Original pipelined query framework, from the R ecosystem. Inspired Ibis, PRQL, and many others that came after. One of our founders learned dplyr before SQL, and never forgot how ergonomic it was in comparison.
PRQLInspiration2022Innovative pipelined query language. Orthogonality of its syntax directly inspired Vinyl’s. Its docs also serve as a model for Vinyl’s.
SQLModelInspiration2021SQLModel’s relational model and field class directly inspired Vinyl’s equivalents.
Quickstart