Tutorial

Explore popular use cases to accelerate your development

dbt · dbt Cloud · dbt models · ad-hoc query · datapilot

Simplify Ad Hoc Analysis in dbt with Data Visualization

Discover how to streamline ad hoc analysis with DBT and Python, solving common challenges like working with raw data, unnesting JSON arrays, and creating clear visualizations. This video shows you how to transform complex datasets into actionable insights quickly and efficiently, making data analysis more intuitive and impactful. Perfect for tackling real-world problems and improving your workflow!

Watch →

dbt · dbt Cloud · dbt models · dbt tests · VSCode · datapilot

Use dbt Cloud in VSCode with the Power User Extension

This video show steps to enable development for dbt Cloud projects in VSCode with the help of Power User extension.

Watch →

dbt · dbt models · query explanation · datapilot · dbt tests

SQL Query / dbt Model explanation

Query explanation is invaluable to understanding a complex piece of dbt or SQL code (especially written by others!). You can ask follow-up questions in the chat window, like - "Explain this function with some sample data" as well.

Watch →

dbt · dbt models · datapilot · dbt tests

Update dbt Models using DataPilot

Many times, you need to add additional columns or change transformation in your dbt Model. Just ask for the changes in natural language, and DataPilot can generate the dbt model update code in VSCode itself.

Watch →

query translation · dbt · dbt models · datapilot

Query translation demo

Do you want to translate SQL queries from one dialect (SQL Server) to another (Snowflake)? Look no further; this video will show you how to do it easily. There are 15 different SQL dialects supported, and the DataPilot provides a translation explanation.

Watch →

dbt · dbt tests · dbt models · datapilot

Generate and edit dbt tests

Generate code for your dbt tests, and edit and delete those tests quickly in VSCode UI without touching the YAML files in the dbt project.

Watch →

column lineage · dbt · dbt models

dbt Column Lineage

Use dbt Column Lineage to understand the impact of your changes and troubleshoot dbt Models.

Watch →

defer to prod · datapilot · dbt · dbt models · VSCode

defer to prod in dbt with VSCode

Deferring to prod functionality in dbt saves data teams a lot of time and money. The Power User extension makes it easy to use this functionality in local and SaaS modes.

Watch →

dbt · dbt models · dbt documentation · datapilot

dbt Documentation Generation

Generate descriptions for your dbt models and columns in different languages and as per personas.

Watch →

dbt documentation · dbt · dbt models · collaboration · datapilot

Collaborate on dbt documentation and code via IDE and UI

Collab functionality enables you to discuss code and documentation easily with the stakeholders via VSCode and UI. Many stakeholders are not comfortable using IDE directly; this functionality enables them also to have a discussion with technical users.

Watch →

dbt · dbt models · CI/CD · datapilot

Check dbt best practices in IDE, Git, CI/CD

Project governance functionality lets you swiftly scan all dbt projects against dbt best practices and organizational guidelines in IDE, Git, CI/CD. You can also create different check configurations based on projects, environments, and teams.

Watch →

column lineage · dbt models · datapilot · dbt documentation

DataPilot - View dbt Documentation and Column Lineage with transformations in SaaS UI

Now, you can view all your dbt documentation and column lineage with transformation info in DataPilot SaaS UI.

Watch →

GET STARTED

Ready to Get Started?

You are only few clicks away from experiencing your own autopilot for data. What are you waiting for??

Get Started for Free