The JetBrains Blog

Blog

Skip to content
  • Blogs by Topic
  • Search
  • Language
    • English
    • Русский
    • 简体中文
Burger menu icon
    • IDEs

      • AppCode
      • CLion
      • DataGrip
      • DataSpell
      • Fleet
      • GoLand
      • IntelliJ IDEA
      • PhpStorm
      • PyCharm
      • Rider
      • RubyMine
      • WebStorm
    • Plugins & Services

      • Big Data Tools
      • Code With Me
      • Quality Assurance
      • JetBrains Platform
      • Rust
      • Scala
      • Toolbox App
      • Writerside
    • Team Tools

      • Datalore
      • Space
      • TeamCity
      • Upsource
      • YouTrack
      • Hub
      • Qodana
    • .NET & Visual Studio

      • .NET Tools
      • ReSharper C++
    • Languages & Frameworks

      • Kotlin
      • Ktor
      • MPS
    • Education & Research

      • JetBrains Academy
      • Research
    • Company

      • Company Blog
      • Security
Big-data-tools logo

The Big Data Tools Blog

A data engineering plugin

Follow
  • Follow Big Data Tools:
  • Twitter
  • RSS
Get Plugin
Follow
  • Follow Big Data Tools:
  • Twitter
  • RSS
  • All
  • Releases
  • Big Data Tools
  • Data Engineering Annotated
Get Plugin

sql

dbt® deeper concepts: materialization

In the first part of this blog series, I described basic dbt® concepts such as installation, creation of views, and describing models. I could have stopped there, but indeed, there are some drawbacks to only using views to build the whole transformation layer in our database. Sometimes we don't really need to use a view and a view may run slowly even in databases oriented toward analytical workflows. I’ll start by giving an overview of ephemeral views. Ephemeral views In some cases, we don't really want to have an entity for a dbt® model, rather we want this model to be inlined in oth

Pasha Finkelshteyn Pasha Finkelshteyn

How I started out with dbt®

For some time now, I’ve noticed that dbt® is gaining popularity. I’ve seen more questions and more success stories, so a couple of days ago I decided to try it out. But what exactly is dbt anyway? Here is the first phrase you can find in its documentation: “dbt (data build tool) enables analytics engineers to transform data in their warehouses by simply writing select statements. dbt handles turn these select statements into tables and views.” It sounds interesting, but maybe that’s not entirely clear. Here’s my interpretation: dbt is a half-declarative tool for describing transformati

Pasha Finkelshteyn Pasha Finkelshteyn
  • Privacy & Security
  • Terms of Use
  • Legal
  • Genuine tools
Language
  • English
  • Русский
  • 简体中文
  • Twitter
  • Facebook
  • Linkedin
  • Instagram
  • Youtube
  • RSS
Copyright © 2000–2022 JetBrains s.r.o.