Links

DBT

DBT Documentation

dbt (data build tool) – Explore Packages

Installation | docs.getdbt.com

Projects | docs.getdbt.com

Configuring incremental models | docs.getdbt.com

Using Jinja | docs.getdbt.com

Using custom schemas | docs.getdbt.com

DBT Issues

2 Critical Fixes For Installing dbt 0.19.0 – DEV Community

Can’t install DBT in Windows · Issue #59 · innoverio/vscode-dbt-power-user · GitHub

DBT Articles

Why the Fishtown SQL style guide uses so many CTEs – Modeling – dbt Discourse

How to track data changes with dbt snapshots

Feature: Command to auto-generate schema.yml files · Issue #1082 · fishtown-analytics/dbt · GitHub

Build Your Data Analytics Like An Engineer With DBT | Data Engineering Podcast

Python

Home | Codewars

The Hitchhiker’s Guide to Python! — The Hitchhiker’s Guide to Python

PostgreSQL

Beekeeper Studio Download | Beekeeper Studio

Data Tools

https://www.querybook.org

Why Data Scientists Should Use an ORM Like SQLAlchemy

SQLAlchemy – The Database Toolkit for Python

Search

Handling Data Denormalization Issues in Elasticsearch | Qbox HES

Handling Relationships Using Nested Objects in Elasticsearch | Qbox HES

Getting Started | Apache Solr Reference Guide 8.9

Solr vs Elasticsearch: Performance Differences & More [2021] – Sematext

NoSql

NoSQL Data Modeling Techniques – Highly Scalable Blog

Terraform

Build Infrastructure | Terraform – HashiCorp Learn

DataBricks

Avoiding unnecessary costs with Azure Databricks using a local Spark environment | Medium

GCP

GCP

https://www.gstatic.com/ipranges/cloud.json

Power BI

Doing Power BI the Right Way: 4. Power Query in Dataflows or Power BI Desktop | Paul Turley’s SQL Server BI Blog

Dataflows in Power BI – BI Polar (ssbipolar.com)

Understanding Dataflows in Power BI.docx (live.com)

Google Analytics

Comparing versions of Google Analytics : Link

Describing the new version Google Analytics 4 : Link

Extract Data from Google Big Query using ADF : Link to MS Docs

Integrating Clickstream data from Google Analytics : Link to SAP CX Works Article

Extracting data from GA : How to unnest / extract nested JSON data in BigQuery (holistics.io)