Skip to content

Commit 10d2e7b

Browse files
emmyoopemmyoop
authored
Merge branch 'current' into er/update-versionless-version-docs
2 parents cc0622e + 6bc8e2f commit 10d2e7b

38 files changed

+67253
-87
lines changed

‎website/dbt-versions.js

Lines changed: 2 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -15,7 +15,7 @@
1515
*/
1616
exports.versions = [
1717
{
18-
version: "1.9.1",
18+
version: "1.10",
1919
customDisplay: "Cloud (Versionless)",
2020
},
2121
{
@@ -74,12 +74,5 @@ exports.versionedPages = [
7474
* @property {string} firstVersion The first version the category is visible in the sidebar
7575
*/
7676
exports.versionedCategories = [
77-
{
78-
category: "Model governance",
79-
firstVersion: "1.5",
80-
},
81-
{
82-
category: "Build your metrics",
83-
firstVersion: "1.6",
84-
},
77+
8578
];

‎website/docs/community/spotlight/fabiyi-opeyemi.md

Lines changed: 2 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,7 @@
22
id: fabiyi-opeyemi
33
title: Opeyemi Fabiyi
44
description: |
5-
I'm an Analytics Engineer with Data Culture, a Data Consulting firm where I use dbt regularly to help clients build quality-tested data assets. I've also got a background in financial services and supply chain. I'm passionate about helping organizations to become data-driven and I majorly use dbt for data modeling, while the other aspect of the stack is largely dependent on the client infrastructure I'm working for, so I often say I'm tool-agnostic. 😀
6-
7-
I'm the founder of Nigeria's Young Data Professional Community. I'm also the organizer of the <a href="https://www.meetup.com/lagos-dbt-meetup/" title="Lagos dbt Meetup" rel="noopener noreferrer" target="_blank">Lagos dbt Meetup</a> which I started, and one of the organizers of the DataFest Africa Conference. I became an active member of the dbt Community in 2021 & <a href="https://coalesce.getdbt.com/blog/how-to-leverage-dbt-community-as-the-first-and-only-data-hire-to-survive" title="spoke at Coalesce 2022" rel="noopener noreferrer" target="_blank">spoke at Coalesce 2022</a>.
5+
I’m an Analytics Engineer with Data Culture, a Data Consulting firm where I use dbt regularly to help clients build quality-tested data assets. Before Data Culture, I worked at Cowrywise, one of the leading Fintech companies in Nigeria, where I was a solo data team member, and that was my first introduction to dbt and Analytics Engineering. Before that, I was doing Data Science and Analytics at Deloitte Nigeria. It’s been an exciting journey since I started using dbt and joining the community.Outside of work, I’m very passionate about Community building and Data Advocacy. I founded one of Nigeria’s most vibrant Data communities, “The Young Data Professional Community.” I’m also the Founder of the <a target="_blank" rel="noopener noreferrer" href="https://www.meetup.com/lagos-dbt-meetup/">Lagos dbt Meetup</a> and one of the organizers of the Largest Data Conference in Africa, <a target="_blank" rel="noopener noreferrer" href="https://www.datacommunityafrica.org/datafestafrica/">DataFest Africa Conference</a>. I became an active member of the dbt community in 2021 & <a target="_blank" rel="noopener noreferrer" href="https://coalesce.getdbt.com/on-demand/how-to-leverage-dbt-community-as-the-first-and-only-data-hire-to-survive">spoke at Coalesce 2022</a>. So when I’m not actively working I’m involved in one community activity or the other.
86
image: /img/community/spotlight/fabiyi-opeyemi.jpg
97
pronouns: he/him
108
location: Lagos, Nigeria
@@ -40,4 +38,4 @@ I've learned how to show empathy as a data professional and be a great engineer
4038

4139
## Anything else interesting you want to tell us?
4240

43-
Maybe, I will consider DevRel as a career sometime because of my innate passion and love for community and people. Several folks tell me I'm a strong DevRel talent and a valuable asset for any product-led company. If you need someone to bounce ideas off of or discuss😃 your community engagement efforts, please feel free to reach out.
41+
Maybe I will consider DevRel as a career sometime because of my innate passion and love for community and people. Several folks tell me I’m a strong DevRel talent and a valuable asset for any product-led company. If you need someone to bounce ideas off of or discuss your community engagement efforts, please feel free to reach out. On a side note, it was really exciting for me to attend Coalesce 2024 in Vegas in person, which allowed me not only to learn but, most importantly, to meet amazing persons I’ve only interacted with online, like Bruno, Kuberjain, Dakota and many more; shout-out to <a target="_blank" rel="noopener noreferrer" href="https://www.zenlytic.com/">Zenlytic</a> and <a target="_blank" rel="noopener noreferrer" href="https://www.lightdash.com/">Lightdash</a> for making that possible and, most importantly, a huge shout-out to the dbt Lab community team: Amada, Natasha and everyone on the community team for their constant supports to helping out with making the dbt Lagos (Nigeria) meetup a success.

‎website/docs/community/spotlight/jenna-jordan.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -21,7 +21,7 @@ communityAwardYear: 2024
2121

2222
## When did you join the dbt community and in what way has it impacted your career?
2323

24-
My dbt learning journey kicked off with the CoRise (now Uplimit) course <a href="https://uplimit.com/course/analytics-engineering-with-dbt/" rel="noopener noreferrer" target="_blank">Analytics Engineering with dbt</a>, with Emily Hawkins and Jake Hannan, in February 2022 – less than a month after starting as a data engineer with the City of Boston Analytics Team. About a year later, I spearheaded the adoption of dbt at the City and got to build the project and associated architecture from scratch – which is probably the best learning experience you could ask for! I saw the value dbt could bring to improving data management processes at the City, and I knew there were other cities and local governments that could benefit from dbt as well, which motivated me to find my fellow co-speakers Ian Rose and Laurie Merrell to give a talk at Coalesce 2023 called <a href="https://www.youtube.com/watch?v=6aX7tAfMmIM&" rel="noopener noreferrer" target="_blank">"From Coast to Coast: Implementing dbt in the public sector".</a> As a part of our goal to identify and cultivate a community of dbt practitioners in the public (and adjacent) sectors, we also started the dbt Community Slack channel <a href="https://getdbt.slack.com/archives/C05MNU6QB5L/" rel="noopener noreferrer" target="_blank">#industry-public-sector</a>. That experience allowed me to continue to grow my career and find my current role - as well as connect with so many amazing data folks!
24+
My dbt learning journey kicked off with the CoRise (now Uplimit) course <a href="https://uplimit.com/course/analytics-engineering-with-dbt/" rel="noopener noreferrer" target="_blank">Analytics Engineering with dbt</a>, with Emily Hawkins and Jake Hannan, in February 2022 – less than a month after starting as a data engineer with the City of Boston Analytics Team. About a year later, I spearheaded the adoption of dbt at the City and got to build the project and associated architecture from scratch – which is probably the best learning experience you could ask for! I saw the value dbt could bring to improving data management processes at the City, and I knew there were other cities and local governments that could benefit from dbt as well, which motivated me to find my fellow co-speakers Ian Rose and Laurie Merrell to give a talk at Coalesce 2023 called <a href="https://www.youtube.com/watch?v=6aX7tAfMmIM&" rel="noopener noreferrer" target="_blank">"From Coast to Coast: Implementing dbt in the public sector."</a> As a part of our goal to identify and cultivate a community of dbt practitioners in the public (and adjacent) sectors, we also started the dbt Community Slack channel <a href="https://getdbt.slack.com/archives/C05MNU6QB5L/" rel="noopener noreferrer" target="_blank">#industry-public-sector</a>. That experience allowed me to continue to grow my career and find my current role - as well as connect with so many amazing data folks!
2525

2626
## What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?
2727

‎website/docs/community/spotlight/meagan-palmer.md

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,8 +3,11 @@ id: meagan-palmer
33
title: Meagan Palmer
44
description: |
55
I first started using dbt in 2016 or 2017 (I can't remember exactly). Since then, I have moved into data and analytics consulting and have dipped in and out of the dbt Community.
6+
67
Late last year, I started leading dbt Cloud training courses and spending more time in the <a href="https://www.getdbt.com/community/join-the-community/" rel="noopener noreferrer" target="_blank">dbt Slack</a>.
8+
79
In consulting, I get to use a range of stacks. I've used dbt with Redshift, Snowflake, and Databricks in production settings with a range of loaders & reporting tools, and I've been enjoying using DuckDB for some home experimentation.
10+
811
To share some of the experiences, I regularly post to LinkedIn and have recently started <a href="https://www.linkedin.com/newsletters/analytics-engineering-today-7210968984693690370/" rel="noopener noreferrer" target="_blank">Analytics Engineering Today</a>, a twice monthly newsletter about dbt in practice.
912
image: /img/community/spotlight/Meagan-Palmer.png
1013
pronouns: she/her

‎website/docs/community/spotlight/mike-stanley.md

Lines changed: 14 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,10 +2,10 @@
22
id: mike-stanley
33
title: Mike Stanley
44
description: |
5-
Mike has been very helpful in dbt Slack, answering questions in channels like #advice-for-dbt-power-users, #advice-dbt-help, #db-bigquery and more. From October 2023 to October 2024, Mike responded to others’ posts 2,355 times. Mike is a truly humble community member who needs no credit or awards, and doesn't even have a profile picture in Slack.​
5+
I've split my time between financial services and the video games industry. Back when I wrote code every day, I worked in marketing analytics and marketing technology. I've been in the dbt community for about two years. I haven't authored any extensions to dbt's adapters yet but I've given feedback on proposed changes!
66
image: /img/community/spotlight/mike-stanley.jpg
77
pronouns: he/him
8-
location: Gloucester, England, United Kingdom
8+
location: London, United Kingdom
99
jobTitle: Manager, Data
1010
companyName: Freetrade
1111
socialLinks:
@@ -16,3 +16,15 @@ hide_table_of_contents: true
1616
communityAward: true
1717
communityAwardYear: 2024
1818
---
19+
20+
## When did you join the dbt community and in what way has it impacted your career?
21+
22+
I've led data teams for almost ten years now and it can be a challenge to stay current on new technology when you're spending a lot of time on leadership and management. I joined the dbt Community to learn how to get more from it, how to solve problems and use more advanced features, and to learn best practices. I find that answering questions is the way I learn best, so I started helping people!
23+
24+
## Which dbt Community leader do you identify with? How are you looking to grow your leadership in the dbt community?
25+
26+
I hope that we can all continue to level up our dbt skills and leave the data environments that we work in better than we found them.
27+
28+
## What have you learned from community members? What do you hope others can learn from you?
29+
30+
Everything! People share so much about their best practices and when and how to deviate from them, interesting extensions to dbt that they've worked on, common bugs and problems, and how to think in a "dbtish" way. I couldn't have learned any of that without the community!

‎website/docs/community/spotlight/original-dbt-athena-maintainers.md

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,9 +3,11 @@ id: original-dbt-athena-maintainers
33
title: The Original dbt-athena Maintainers
44
description: |
55
The original dbt-athena Maintainers is a group of 5 people—Jérémy Guiselin, Mattia, Jesse Dobbelaere, Serhii Dimchenko, and Nicola Corda—who met via dbt Slack in the #db-athena channel, with the aim to make make <a target="_blank" rel="noopener noreferrer" href="https://docs.getdbt.com/docs/core/connect-data-platform/athena-setup">dbt-athena</a> a production-ready adapter.
6+
67
In the first periods, Winter 2022 and Spring 2023, we focused on contributing directly to the adapter, adding relevant features like Iceberg and Lake Formation support, and stabilizing some internal behaviour.
8+
79
On a second iteration our role was triaging, providing community support and bug fixing. We encouraged community members to make their first contributions, and helped them to merge their PRs.
8-
image: /img/community/spotlight/dbt-athena-groupheadshot.png
10+
image: /img/community/spotlight/dbt-athena-groupheadshot.jpg
911
location: Europe
1012
jobTitle: A group of data-engineers
1113
companyName: Mix of companies

‎website/docs/docs/build/dimensions.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -67,7 +67,7 @@ semantic_models:
6767
type: categorical
6868
```
6969
70-
Dimensions are bound to the primary entity of the semantic model they are defined in. For example the dimensoin `type` is defined in a model that has `transaction` as a primary entity. `type` is scoped to the `transaction` entity, and to reference this dimension you would use the fully qualified dimension name i.e `transaction__type`.
70+
Dimensions are bound to the primary entity of the semantic model they are defined in. For example the dimension `type` is defined in a model that has `transaction` as a primary entity. `type` is scoped to the `transaction` entity, and to reference this dimension you would use the fully qualified dimension name i.e `transaction__type`.
7171

7272
MetricFlow requires that all semantic models have a primary entity. This is to guarantee unique dimension names. If your data source doesn't have a primary entity, you need to assign the entity a name using the `primary_entity` key. It doesn't necessarily have to map to a column in that table and assigning the name doesn't affect query generation. We recommend making these "virtual primary entities" unique across your semantic model. An example of defining a primary entity for a data source that doesn't have a primary entity column is below:
7373

‎website/docs/docs/build/incremental-microbatch.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@ id: "incremental-microbatch"
88

99
:::info Microbatch
1010

11-
The `microbatch` strategy is available in beta for [dbt Cloud Versionless](/docs/dbt-versions/upgrade-dbt-version-in-cloud#versionless) and dbt Core v1.9. We have been developing it behind a flag to prevent unintended interactions with existing custom incremental strategies. To enable this feature, set the environment variable `DBT_EXPERIMENTAL_MICROBATCH` to `True` in your dbt Cloud environments or wherever you're running dbt Core.
11+
The `microbatch` strategy is available in beta for [dbt Cloud Versionless](/docs/dbt-versions/upgrade-dbt-version-in-cloud#versionless) and dbt Core v1.9. We have been developing it behind a flag to prevent unintended interactions with existing custom incremental strategies. To enable this feature, [set the environment variable](/docs/build/environment-variables#setting-and-overriding-environment-variables) `DBT_EXPERIMENTAL_MICROBATCH` to `True` in your dbt Cloud environments or wherever you're running dbt Core.
1212

1313
Read and participate in the discussion: [dbt-core#10672](https://github.com/dbt-labs/dbt-core/discussions/10672)
1414

‎website/docs/docs/build/incremental-models.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -212,11 +212,11 @@ Currently, `on_schema_change` only tracks top-level column changes. It does not
212212

213213
### Default behavior
214214

215-
This is the behavior if `on_schema_change: ignore`, which is set by default, and on older versions of dbt.
215+
This is the behavior of `on_schema_change: ignore`, which is set by default.
216216

217217
If you add a column to your incremental model, and execute a `dbt run`, this column will _not_ appear in your target table.
218218

219-
Similarly, if you remove a column from your incremental model, and execute a `dbt run`, this column will _not_ be removed from your target table.
219+
If you remove a column from your incremental model and execute a `dbt run`, `dbt run` will fail.
220220

221221
Instead, whenever the logic of your incremental changes, execute a full-refresh run of both your incremental model and any downstream models.
222222

‎website/docs/docs/build/measures.md

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -200,7 +200,7 @@ Parameters under the `non_additive_dimension` will specify dimensions that the m
200200

201201
```yaml
202202
semantic_models:
203-
- name: subscription_id
203+
- name: subscriptions
204204
description: A subscription table with one row per date for each active user and their subscription plans.
205205
model: ref('your_schema.subscription_table')
206206
defaults:
@@ -209,7 +209,7 @@ semantic_models:
209209
entities:
210210
- name: user_id
211211
type: foreign
212-
primary_entity: subscription_table
212+
primary_entity: subscription
213213
214214
dimensions:
215215
- name: subscription_date
@@ -224,21 +224,21 @@ semantic_models:
224224
expr: user_id
225225
agg: count_distinct
226226
non_additive_dimension:
227-
name: metric_time
227+
name: subscription_date
228228
window_choice: max
229229
- name: mrr
230230
description: Aggregate by summing all users' active subscription plans
231231
expr: subscription_value
232232
agg: sum
233233
non_additive_dimension:
234-
name: metric_time
234+
name: subscription_date
235235
window_choice: max
236236
- name: user_mrr
237237
description: Group by user_id to achieve each user's MRR
238238
expr: subscription_value
239239
agg: sum
240240
non_additive_dimension:
241-
name: metric_time
241+
name: subscription_date
242242
window_choice: max
243243
window_groupings:
244244
- user_id
@@ -255,15 +255,15 @@ We can query the semi-additive metrics using the following syntax:
255255
For dbt Cloud:
256256

257257
```bash
258-
dbt sl query --metrics mrr_by_end_of_month --group-by metric_time__month --order metric_time__month
259-
dbt sl query --metrics mrr_by_end_of_month --group-by metric_time__week --order metric_time__week
258+
dbt sl query --metrics mrr_by_end_of_month --group-by subscription__subscription_date__month --order subscription__subscription_date__month
259+
dbt sl query --metrics mrr_by_end_of_month --group-by subscription__subscription_date__week --order subscription__subscription_date__week
260260
```
261261

262262
For dbt Core:
263263

264264
```bash
265-
mf query --metrics mrr_by_end_of_month --group-by metric_time__month --order metric_time__month
266-
mf query --metrics mrr_by_end_of_month --group-by metric_time__week --order metric_time__week
265+
mf query --metrics mrr_by_end_of_month --group-by subscription__subscription_date__month --order subscription__subscription_date__month
266+
mf query --metrics mrr_by_end_of_month --group-by subscription__subscription_date__week --order subscription__subscription_date__week
267267
```
268268

269269
import SetUpPages from '/snippets/_metrics-dependencies.md';

‎website/docs/docs/build/metricflow-commands.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -259,7 +259,7 @@ Create a new query with MetricFlow and execute it against your data platform. Th
259259
260260
```bash
261261
dbt sl query --metrics <metric_name> --group-by <dimension_name> # In dbt Cloud
262-
dbt sl query --saved-query <name> # In dbt Cloud CLI
262+
dbt sl query --saved-query <name> # In dbt Cloud
263263

264264
mf query --metrics <metric_name> --group-by <dimension_name> # In dbt Core
265265

‎website/docs/docs/build/metricflow-time-spine.md

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -150,7 +150,7 @@ final as (
150150
151151
select * from final
152152
where date_day > dateadd(year, -4, current_timestamp())
153-
and date_hour < dateadd(day, 30, current_timestamp())
153+
and date_day < dateadd(day, 30, current_timestamp())
154154
```
155155

156156
### Daily (BigQuery)
@@ -180,7 +180,7 @@ select *
180180
from final
181181
-- filter the time spine to a specific range
182182
where date_day > dateadd(year, -4, current_timestamp())
183-
and date_hour < dateadd(day, 30, current_timestamp())
183+
and date_day < dateadd(day, 30, current_timestamp())
184184
```
185185

186186
</File>
@@ -265,7 +265,7 @@ final as (
265265
266266
select * from final
267267
where date_day > dateadd(year, -4, current_timestamp())
268-
and date_hour < dateadd(day, 30, current_timestamp())
268+
and date_day < dateadd(day, 30, current_timestamp())
269269
```
270270

271271
</File>
@@ -296,7 +296,7 @@ select *
296296
from final
297297
-- filter the time spine to a specific range
298298
where date_day > dateadd(year, -4, current_timestamp())
299-
and date_hour < dateadd(day, 30, current_timestamp())
299+
and date_day < dateadd(day, 30, current_timestamp())
300300
```
301301

302302
</File>

‎website/docs/docs/cloud/manage-access/about-access.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -79,7 +79,7 @@ Refer to [role-based access control](#role-based-access-control) for more inform
7979

8080
## Grant access
8181

82-
dbt Cloud users have both a license (individually or by group) and permissions (by group only) that determine what actions they can take. Licenses are account-wide, and permissions provide more granular access or restrictions to specific features.
82+
dbt Cloud users have both a license (assigned to an individual user or by group membership) and permissions (by group membership only) that determine what actions they can take. Licenses are account-wide, and permissions provide more granular access or restrictions to specific features.
8383

8484
### Licenses
8585

0 commit comments

Comments
 (0)