Merge branch 'current' into add-model-contracts-section

taraojo · May 5, 2023 · 9a5edcd · 9a5edcd
2 parents 1751879 + 2d4c941
commit 9a5edcd
Show file tree

Hide file tree

Showing 326 changed files with 1,767 additions and 424 deletions.
diff --git a/website/blog/2021-10-15-october-21-product-update-email.md b/website/blog/2021-10-15-october-21-product-update-email.md
@@ -1,6 +1,6 @@
 ---
 title: "October 2021 dbt Update: Metrics and Hat Tricks 🎩"
-description: "Also flagging that Coalesce is less than 3 weeks away! 😱"
+description: "Stay up-to-date with the latest features in dbt. Read about our October 2021 product update."
 slug: dbt-product-update-2021-october
 authors: [lauren_craigie]
 

diff --git a/website/blog/2021-11-15-november-21-product-email.md b/website/blog/2021-11-15-november-21-product-email.md
@@ -1,6 +1,6 @@
 ---
 title: "November 2021 dbt Update: v1.0, Environment Variables, and a Question About the Size of Waves 🌊"
-description: "Also flagging that Coalesce is less than 3 weeks away! 😱"
+description: "Stay up-to-date with the latest features in dbt. Read about our November 2021 product update."
 slug: dbt-product-update-2021-november
 authors: [lauren_craigie] 
 

diff --git a/website/dbt-versions.js b/website/dbt-versions.js
@@ -33,6 +33,10 @@ exports.versionedPages = [
   {
     "page": "docs/collaborate/govern/model-contracts",
     "firstVersion": "1.5",
+  },
+    {
+    "page": "reference/commands/show",
+    "firstVersion": "1.5",
   },
   {
     "page": "docs/collaborate/govern/model-access",

diff --git a/website/docs/community/spotlight/anya-prosvetova.md b/website/docs/community/spotlight/anya-prosvetova.md
@@ -0,0 +1,35 @@
+---
+id: anya-prosvetova
+title: Anya Prosvetova
+description: |
+  I’m a Data Engineer with a background in SaaS, consulting, financial services and the creative industries. I help organisations convert data into value, developing data pipelines and automating processes. I’m also a Tableau Visionary and DataDev Ambassador, and one of the organisers of Data + Women Netherlands community. I became an active member of the dbt Community about a year ago, and it was a great place to learn and ask questions. And it was really inspiring to speak at the first Amsterdam dbt Meetup recently, and meet the local community of fellow Analytics and Data Engineers.
+image: /img/community/spotlight/anya-prosvetova.jpg
+pronouns: she/her
+location: Amsterdam, Netherlands
+jobTitle: Senior Data Engineer
+companyName: Aimpoint Digital
+organization: Tableau Vizionary & DataDev Ambassador
+socialLinks:
+  - name: Twitter
+    link: https://www.twitter.com/anyalitica
+  - name: LinkedIn
+    link: https://uk.linkedin.com/in/annaprosvetova
+  - name: Website
+    link: https://prosvetova.com
+dateCreated: 2023-03-29
+hide_table_of_contents: true
+---
+
+## When did you join the dbt community and in what way has it impacted your career?
+
+A few years back, I became a member of the dbt Community, but it wasn't until about a year ago, when I started using dbt at work, that I began actively engaging with it. Being the only data person in my company, the Community became a valuable resource for me to learn and ask questions. It's an excellent platform to gain insights from others, exchange experiences, and stay up-to-date with the latest product features.
+
+## What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?
+
+What I enjoy about the dbt Community is that its thought leaders are focused on working together to create a culture of mutual support and shared learning. Everyone is welcome to ask a question or share their latest blog without the fear of being judged. I believe that everyone has something valuable to contribute to the community, and I hope to help facilitate this supportive and collaborative environment where we can all learn from each other. 
+
+## What have you learned from community members? What do you hope others can learn from you?
+
+I've learned a lot about best practices for working with dbt and data in general, as well as tips and tricks for specific use cases. I've also gained a better understanding of the diverse range of data challenges that people face in different industries and contexts.
+
+As for what I hope others can learn from me, I aim to share my own experiences and knowledge in a way that is approachable and useful to people at all skill levels and backgrounds.
diff --git a/website/docs/community/spotlight/bruno-de-lima.md b/website/docs/community/spotlight/bruno-de-lima.md
@@ -0,0 +1,53 @@
+---
+id: bruno-de-lima
+title: Bruno de Lima
+description: |
+  I am an Analytics Engineer and aspiring tech writer coming from an academic engineering background.
+
+  I worked at Indicium as an Analytics Engineer for more than a year, having worked with dbt (of course, every day) for transformation; BigQuery, Snowflake, and Databricks as data warehouses; Power BI and Tableau for BI; and Airflow for orchestration.
+
+  I actively participate in the dbt community, having attended two dbt meetups in Brazil organized by Indicium; writing about dbt-related topics in my Medium and LinkedIn profiles; contributing to the code; and frequently checking dbt Slack and Discourse, helping (and being helped by) other dbt practitioners. If you are a community member, you may have seen me around!
+image: /img/community/spotlight/bruno-de-lima.jpg
+pronouns: he/him
+location: Florianópolis, Brazil
+jobTitle: Analytics Engineer
+companyName: Indicium
+organization: ""
+socialLinks:
+  - name: LinkedIn
+    link: https://www.linkedin.com/in/brunoszdl/
+  - name: Medium
+    link: https://medium.com/@bruno.szdl
+dateCreated: 2023-03-28
+hide_table_of_contents: true
+---
+
+## When did you join the dbt community and in what way has it impacted your career?
+
+I was not truly happy with my academic life. My career took a new turn when I enrolled in the Analytics Engineer course by Indicium. That was my first contact with dbt, and I didn't realize how much it would transform my career. After that, I was hired at the company as an Analytics Engineer and worked extensively with dbt from day one. 
+
+It took me some time to become an active member of the dbt community. I started working with dbt at the beginning of 2022 and became more involved towards the end of that year, encouraged by Daniel Avancini. I regret not doing this earlier, because being an active community member has been a game-changer for me, as my knowledge of dbt has grown exponentially just by participating in daily discussions on Slack. I have found #advice-dbt-help and #advice-dbt-for-power-users channels particularly useful, as well as the various database-specific channels. Additionally, the #i-made-this and #i-read-this channels have allowed me to learn about the innovative things that community members are doing.
+
+Inspired by other members, especially Josh Devlin and Owen Prough, I began answering questions on Slack and Discourse. For questions I couldn't answer, I would try engaging in discussions about possible solutions or provide useful links. I also started posting dbt tips on LinkedIn to help practitioners learn about new features or to refresh their memories about existing ones.
+
+By being more involved in the community, I felt more connected and supported. I received help from other members, and now, I could help others, too. I was happy with this arrangement, but more unexpected surprises came my way. My active participation in Slack, discourse, and LinkedIn opened doors to new connections and career opportunities. I had the pleasure of meeting a lot of incredible people and receiving exciting job offers.
+
+Thanks to the dbt community, I went from feeling uncertain about my career prospects to having a solid career and being surrounded by incredible people.
+
+I would like to thank the Indicium folks for opening the first door for me for this career in data, and not just for me but for lots of people in Brazil trying to migrate from different fields who would not have this opportunity otherwise.
+
+## What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?
+
+I identify with Gwen Windflower and Joel Labes, or at least they are the kind of leader I admire. Their strong presence and continuous interaction with all types of dbt enthusiasts make everyone feel welcomed in the community. They uplift those who contribute to the community, whether it's through a LinkedIn post or answering a question, and provide constructive feedback to help them improve. And of course they show a very strong knowledge about dbt and data in general, which is reflected in their contributions.
+
+And that is how I aspire to grow as a leader in the dbt Community. Despite of being an introvert, I like interacting with people, helping solve problems and providing suggestions. Recognizing and acknowledging the achievements of others is also important to me, as it fosters a positive environment where everyone's contributions are valued. And I am continuously learning about dbt to improve my skills, and to become a trustworthy reference for others to rely on.
+
+## What have you learned from community members? What do you hope others can learn from you?
+
+I have learned that regardless of one's level of expertise, each person's voice is valued and respected in the community. I have also learned the importance of helping others and thinking critically, not just answering questions, but assuring that is the right question. By actively engaging with others, sharing knowledge and insights, we can collectively improve our understanding and use of dbt. Moreover, I have discovered that having fun with dbt and fostering a positive, supportive community culture can greatly enhance the learning experience.
+
+I hope the others can learn from me that it doesn’t matter who you are, where are you from and how old you are, you can make a difference in the community. I hope to inspire others to become more involved in the community, and to not be afraid to share their thoughts or ideas, or to post something because they think it is not cool enough. Through this process of mutual learning and support, we can accelerate our professional development and achieve our goals. So don't hold back, take initiative, and be an active contributor to this amazing community!
+
+## Anything else interesting you want to tell us?
+
+I would like to mention my very first contribution to the community, a dbt commands cheatsheet. I made it because I was very new to dbt and wanted a resource where I could quickly check the available commands and what I could do with them. I made it for me, but then I thought it could help other beginners and shared it. I was incredibly surprised when it appeared in a dbt newsletter, and I think that was the starting point for me in the community. At this point, I knew everyone could contribute and felt more comfortable to do more of that.
diff --git a/website/docs/community/spotlight/david-effiong.md b/website/docs/community/spotlight/david-effiong.md
@@ -0,0 +1,37 @@
+---
+id: david-effiong
+title: David Effiong
+description: |
+  I started my career as a data analyst but I currently work as a data engineer in a financial Institution. I have experience working in both large organisations and startups. I have been in the dbt community for about 1 year and 6 months. I found out about dbt while working at a startup where I implemented a modern data stack using BigQuery, Airbyte, Metabase, and dbt. Currently my stack in my large organisation includes Azure tools + dbt. (😁 Of course I had to use dbt!) I have a YouTube channel where I share learnings about data and productivity. The name of my channel is David Data, please check it out. I spoke at the first in-person Lagos dbt meetup about and I am currently an organiser of the Lagos dbt meetup.
+image: /img/community/spotlight/david-effiong.jpg
+pronouns: he/him
+location: Lagos, Nigeria
+jobTitle: Data Engineer
+companyName: Sterling Bank PLC
+organization: Young Data Professionals
+socialLinks:
+  - name: Twitter
+    link: https://www.twitter.com/@david_uforo
+  - name: LinkedIn
+    link: https://www.linkedin.com/in/david-effiong
+  - name: YouTube
+    link: https://www.youtube.com/@daviddata
+dateCreated: 2023-03-26
+hide_table_of_contents: true
+---
+
+## When did you join the dbt community and in what way has it impacted your career?
+
+I joined the dbt community late 2021 when I joined the startup. I was a data team of one with little experience in the domain and dbt community was and has remained impactful to my career. With the help of the community I was able to build a data stack as a team of one because there was always support to answer questions I post on the community. The community is so rich with value from conversations that you can read through threads and learn best practices or diverse approaches to problem solving. The dbt community has also been of great help to me in my current organisation in implementing dbt as part of the stack for data quality assurance purposes. The community is open to support anyone regardless of nationality or skill level and I am happy and grateful to be a part of this community. 
+
+## What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?
+
+I identify with Opeyemi Fabiyi as a community leader. Opeyemi introduced me to dbt as a tool and as a community. Based on this belief in the power of communities, he went on to start Young Data Professionals, pioneered dbt meetups in Lagos, Nigeria, and also spoke at Coalesce 2022. I am looking to grow my leadership in the community by interacting more in community conversations, organizing more dbt meetups this year and also by continuing to share my dbt learning videos on my YouTube Channel.
+
+## What have you learned from community members? What do you hope others can learn from you?
+
+I have learned solutions to technical problems from community members. I have also learned empathy and patience from community members while interacting with others. I hope I can provide technical solutions to other community members and also do it with patience and empathy. I also hope others can learn to be more involved in the community because the community has only grown because of people, and as more people get involved, more impact is made.
+
+## Anything else interesting you want to tell us?
+
+Outside of work, I play the piano and sing in the choir. I also write a faith based blog, [The Writings of David Uforo](https://daviduforo.wordpress.com/). You may want to check out.  
diff --git a/website/docs/community/spotlight/emily-riederer.md b/website/docs/community/spotlight/emily-riederer.md
@@ -0,0 +1,48 @@
+---
+id: emily-riederer
+title: Emily Riederer
+description: |
+  I'm a long-time dbt user and have been an active community member for a few years. 
+
+  Professionally, I've led a variety of data teams at Capital One spanning analytics, modeling, innersource data tools, and data infrastructure. The common denominator of all of these roles has been the overwhelming importance of high quality data processing pipelines. Outside of work, I enjoy doing pro bono projects and applying my same skillset to scrappier environments.
+
+  My work with the dbt community is motivated by a passion for data quality and developer tooling. Some of my recent contributions include maintaining the <code>dbtplyr</code> package, speaking at Coalesce 2021, and <a href="https://docs.getdbt.com/blog/grouping-data-tests" title="writing a dbt Developer Blog post">writing a dbt Developer Blog post</a> about my PR to the <code>dbt-utils</code> test suite.
+image: /img/community/spotlight/emily-riederer.jpg
+pronouns: she/her
+location: Chicago, IL
+jobTitle: Senior Manager - Data Science & Analytics
+companyName: Capital One
+organization: rOpenSci Editorial Board
+socialLinks:
+  - name: Twitter
+    link: https://twitter.com/emilyriederer
+  - name: LinkedIn
+    link: https://linkedin.com/in/emilyriederer
+  - name: Website
+    link: https://emilyriederer.com
+  - name: GitHub
+    link: https://github.com/emilyriederer
+  - name: Mastodon
+    link: https://mastodon.social/@emilyriederer
+dateCreated: 2023-03-22
+hide_table_of_contents: true
+---
+
+## When did you join the dbt community and in what way has it impacted your career?
+
+I have been involved in the dbt community for a few years now. While I enjoy being actively engaged, one of my favorite parts is simply "lurking" on the Slack channels. The data space is moving so fast right now with so many different competing frameworks, tools, and ideas. At the same time, data work tends to be less discussed and publicly shared than analysis methods (e.g. new modeling packages) due to data privacy and IP. I've found no better place to "drink from the firehouse" and benefit from the insights of others questions, challenges, and successes.
+
+## What dbt community leader do you identify with? How are you looking to grow your leadership in the dbt community?
+
+Two community members that really inspire me are Claire Carroll and Joel Labes. I think both showcase excellence in technical best practices, crystal-clear communication of technical concepts in their prolific writing, and a passion for building community and creating on-ramps. That mix of so-called 'hard' and 'soft' skills adds so much to the community and helps empower every member to be their best. I'm always looking to balance the time I spend growing my skills along both dimensions.
+
+## What have you learned from community members? What do you hope others can learn from you?
+
+Given my passion for data quality and the design side of data, I particularly enjoy thinking about data modeling and learning from the community's experience with the variety of classical and novel frameworks for designing resilient, flexible datamarts. 
+
+As a passionate fan of open-source (and the also-thriving #rstats community), I hope to inspire others to create more packages and PRs that expand the developer toolkit. I also particularly enjoy discussing my thoughts on data quality and avoiding data disasters.
+
+## Anything else interesting you want to tell us?
+
+test 
+My passion for open-source tools and open-knowledge extends beyond dbt. I also enjoy serving on the editorial board for rOpenSci to champion the creation of open-source research software, reviewing technical books for CRC Press, doing pro-bono data projects, and sharing my own learnings through conference talks and writing (including on my website, guest blogs, and books including [R Markdown Cookbook](https://bookdown.org/yihui/rmarkdown-cookbook/) and [97 Things Every Data Engineer Should Know](https://www.oreilly.com/library/view/97-things-every/9781492062400/)).