Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts. However, there are limitations to what can be done with the Structure Query Language (SQL). That is where dbt Python models can be used to perform complex tasks. A dbt Python model is a function that reads […]
2026-06-03
2,685 reads
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
2026-05-27
1,237 reads
2026-05-06 (first published: 2025-04-16)
1,744 reads
Learn more about dbt in this next article on Data Engineering in Fabric.
2026-04-08
5,078 reads
In this next installment, we look at using dbt to seed a Fabric Warehouse.
2026-03-25
3,516 reads
The next installment of the Fabric Modern Data Platform looks at Spark pools for executing code.
2026-03-11
1,818 reads
This article will use the incremental data load pattern to load data in our raw zone tables.
2026-03-07 (first published: 2025-12-10)
1,270 reads
In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.
2026-02-25
2,358 reads
This next articles gives you a few quick ways to access data in remote storage.
2026-02-11
1,993 reads
This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics
2026-01-28
1,784 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers