Turntable for dbt Core™

Turntable is a powerful extension for working with dbt Core™ in Visual Studio Code. Turntable comes packaged with a powerful set of tools to help you and your team better develop, debug, and review data pipelines.

Table of Contents

• Supported Databases
• Features
  • Column-level lineage
  • In-line Docs YAML editing
  • AI Generated Documentation
  • Model Validation
  • Query Preview
  • Intellisense Autocomplete
  • dbt command menu
• Getting Started
• Is Turntable Free? (spoiler: yes)
• Disclaimer

Supported Databases

Turntable for dbt-core™️ currently only works with the following databases:

• Snowflake
• BigQuery
• Databricks
• Redshift
• Postgres

Features

Column-level lineage

Quickly view column-level lineage alongside a given model, including details on how the columns are connected (joins, filters, etc.).

In-line Docs YAML editing

Read and edit your dbt model docs side-by-side as you develop

AI Generated Documentation

Use our AI copilot to write a first draft of table and column descriptions for you.

Model Validation

Check for database errors and problems before you run your model (press Command ⌘ + Shift ⇧ + Enter on Mac or CTRL + Shift ⇧ + Enter on Windows).

Query Preview

Quickly see a preview of the result set for your model as you develop (press Command ⌘ + Enter on Mac or CTRL + Enter on Windows).

Intellisense Autocomplete

Autocomplete your refs, sources and macros as you develop. Navigate between models with Command ⌘ + click (CTRL + click on Windows) and hover over refs and sources to see their column details and documentation.

dbt command menu

Run dbt commands from the Command Palette. In model files, you'll find a "DBT" button in the top right corner. Clicking on this button will open a menu with the common dbt commands that you can run for that model. You can also enter custom commands in the Command Palette.

The DBT Command Menu is accessible via the following keyboard shortcuts:

For Mac: Option ⌥ + D For Windows: Alt + D For Linux: Alt + D

Getting Started

Install Turntable by clicking Install in the Extensions side bar in VS Code, by searching for Turntable.

1. Open your dbt project with Visual Studio Code.
2. Install the Turntable extension from the Visual Studio Marketplace.
3. You will be prompted to log in to Turntable. Once you do, you'll be able to use the extension.
4. The extension will conduct a health check to make sure that your Python and dbt-core environments are set up correctly. If this is your first time using Turntable you'll be prompted to go through a quick installation flow. You can always go back to this setup flow by running the command Turntable for dbt Core: Settings in your command pallete.

See our FAQ for more details or to troubleshoot set-up.

Is Turntable Free?

Yes, the extension is free to use on all repos.

Disclaimer

dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Turntable is not a product or service of or endorsed by dbt Labs, Inc.