Setting up and using dbt (Data Build Tool) with SQL Server

  • dbt, or Data Build Tool, is a piece of software that allows analysts to write SQL/Python/Jinja code to  faciliate ELT workflows to your data warehouse. Analysts can write code that will serialize into valid SQL code, the code will create views in your data warehouse, and full documentation allows anyone to review object definitions and dependencies.

    I'd like to write either a couple articles or a stairways series on how to set up dbt against a SQL Server environment, how to create views using the jinja templating, how to deploy to the warehouse, how to review the documentation, etc.

     

    https://www.getdbt.com/

     

  • If you're serious, then instead of posting spam, contact the web master for this site.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • I'm not affiliated with dbt in any way and I'm not spamming. dbt is a popular tool used for creating views and other artifacts as a part of ELT workflows, and it has integrations with SQL Server. This was also posted in the seemingly appropriate forum about Requested Articles.

  • Still, if you want to write check out this page: https://www.sqlservercentral.com/contribute.

     

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply