dbt connects to and runs SQL against your database, warehouse, platform, or query engine. It works by using a dedicated adapter for each technology. All the adapters listed below are open source and free to use, just like dbt.

1. Dbt Slack App
2. Slack Community
3. Dbt Slack Download
4. Dbt Slack Integration
5. Dbt Discourse

Include the following in your packages.yml file: packages: - package: fivetran/salesforce version: 0.3.1. Run dbt deps to install the package. For more information on using packages in your dbt project, check out the dbt Documentation. The dbt community extends far beyond what happens in dbt Slack. We hold regular Meetups in New York, San Francisco, and London; with new cities being added. This community grew out of Fishtown Analytics’ values. Here are some ways these values apply. Our package runs inside the dbt environment, so you can use dbt to run other parts of the Data Vault pipeline, combined with the dbtvault package for the Data Vault specific steps. Tip Sign up for early-bird announcements or join our Slack ¶. Dbt is designed for ease of use in data engineering: for when you need to develop a data pipeline. It is a single command-line utility that can run on your desktop or a VM in your network, it is developed in Python, and it is free to download and use.

Fishtown Supported#

In addition to maintaining dbt-core, Fishtown Analytics maintains a set of adapters for some of the most common databases, warehouses, and platforms. (✅ indicates 'full support.')

Adapters distributed with 'core' are ready to use when you install dbt. For 'plugin' adapters, check each page for specific installation instructions.

Vendor Supported#

These adapter plugins are built and maintained by the same people who build and maintain the complementary data technology.

Community Supported#

These adapter plugins are contributed and maintained by members of the community 🌱

Community-supported plugins are works in progress, and all users are encouraged to contribute by testing and writing code. If you're interested in contributing:

• Join the dedicated channel in dbt Slack (e.g. #db-sqlserver, #db-athena)
• Check out the open issues in the plugin's source repository

Dbt Slack App

Note that, while no community plugins are currently supported in dbt Cloud, we expect this to change in 2021.

Creating a new adapter#

dbt can be extended to any SQL-speaking database, warehouse, data lake, query engine, or analytical platform by means of an adapter plugin. These plugins can be built as separate Python modules, and dbt will discover them if they are installed on your system. If you see something missing from the lists above, and you're interested in developing an integration, read more about building a new adapter.

We are all community members; yes: that includes Fishtown Analytics! It isnot “our” community, it is “the” community. This very intentional word choicereminds us of our relationship to this group of humans.

In the dbt community, you are not a “vendor” or a “partner”– you are an individualhuman who is a member of the community. It’s important to think of yourparticipation in this context. Sure, we all have something to sell, but you don’twant to be the person who promotes MLM products on Facebook. We are communitymembers first.

Here are some quick do’s and don’ts to share with every single person on your team who joins the dbt Slack community:

On day 1…

🙌 Do this

1. Identify yourself as a partner in your name (e.g. “Alice (DataCo)”) and Slack bio.
2. Update your profile picture to a current photo.
3. Introduce yourself in #introductions

👎 Not this

Do not jump in and start posting in a bunch of channels on your first day

Get acquainted with the rules

🙌 Do this

Familiarize yourself with the Rules of the Road for the dbt Slack community.

👎 Not this

Do not do 1:1 outbound via the dbt community at all. Only initiate DMs if you’ve received active confirmation in a public channel that a DM would be welcome.

🙌 Do this

If a discussion is taking place where you feel your product or services would help out, you can join in the discussion - you’ll likely have something constructive to add. In doing so, make sure you identify yourself and your business interests in the thread. You can let community members know that you are open to a DM if someone wants to get more information about your product.

👎 Not this

Do not initiate a DM conversation after participating in a relevant thread in a public channel, or post links to book a sales call on that thread.

Be you

🙌 Do this

Be yourself when posting, speak in your own voice.

👎 Not this

Avoid using your company’s marketing or support voice.

Be helpful

🙌 Do this

Be a generally helpful community member — if there’s a discussion you can add value to, we welcome it! (Being a dbt user yourself will make this easier)

👎 Not This

Do not feel like your participation should be limited only to discussions related to your product/services.

Be balanced

🙌 Do this

Feel free to post links to resources, and product updates in appropriate channels (usually that will be #random);keep in mind the “balance of value” you personally are creating.

👎 Not this

Slack Community

Post “drive by” links without sharing context or your own personal thoughts about what you’re posting.

Understanding dbt community values

The dbt community extends far beyond what happens in dbt Slack. We hold regular Meetups in New York, San Francisco, and London;with new cities being added. This community grew out of Fishtown Analytics’ values.Here are some ways these values apply…

Profits are exhaust

This is our most foundational company value, and has played a huge part in guidinghow we think about the dbt community. An orientation towards profit kills communities.By putting the community first, however, we’ve found that profits and growth havefollowed, we think it will work the same for you :)

Create more value than you capture.

The more value you create for the community, the more “asks” you can make. How are you creating value today?

Ideas:

• contribute to dbt
• write dbt packages
• write other public content (blog posts, case studies, etc.)
• respond to questions on slack / discourse
• host events
• promote / respond to content written by community members

Dbt Slack Download

Optimize for the long term.

One of our guiding questions has been: “What does the community need from us?”The community does need to know how dbt works well with your technology. It doesnot need followup emails from sales reps. What other creative ways can you engage?Over the long term, the organic growth we see in the dbt community will create massiveupside for partners that work with the community, not against it.

Build non-transactional relationships. Say thank you. Send swag. Take someone outfor lunch the next time you’re nearby. We’re years away from seeing mass adoptionof the modern data stack, let’s play the long game.

Contribute to the knowledge loop.

• Default to open-source-licensed, long-lived content
• Think of content that you create more as “paying it forwards” as opposed to “generating leads”. Build your brand as a community member as a company who “gets it” and leads will come.

Users are our best advocates.

• Rather than thinking of the dbt community as a marketing channel to reach new people, think of it as a way to more deeply engage with your existing users. Your existing users will then turn around and advocate on your behalf to draw in new community members who are interested in what you’re doing.
• Start small, build an avid fan-base, and watch things grow!

Be you.

Dbt Slack Integration

This one isn’t a Fishtown value, but it’s a good one to guide community interactions:

Dbt Discourse

• Some developer communities allow and even encourage anonymity — we prefer it when people identify themselves clearly. It helps to build empathy, and form relationships.
• We consider our community members as individuals, rather than agents of their company. This is demonstrated when someone adds their own opinion / writes in their own voice, rather than speaking as a representative of their company (as is often the case for support agents).
• On an even more basic level: Be respectful to others. Be empathetic when someone asks for help by trying to understand where they are coming from.