dbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.
$0
per month per seat
Sublime Text
Score8.8 out of 10
N/A
Sublime Text is a highly customizable text editing solution featuring advanced API, Goto functions, and other features, from Sublime HQ in Sydney.
The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
My CMS has a small window in which I can edit custom HTML/CSS. It can be expanded some, but not as much as I would like. It also displays all code as dark text on a white background. On a page where I am doing extensive custom coding, it is helpful to see it in a larger window and in a color-coded display so that I don't have to strain my eyes as hard. Especially when I'm trying to scan for specific elements and target issues and so that I don't have to scroll endlessly in a tiny window.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
This is a programmers tool. As such a lot of the features and benefits are lost on a non-technical user. To get the most out of the tool you need to have a basic crash course in how it works and what it can do. The documentation and community are good, but it takes a bit of time to get up to speed.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Never had to use their customer support before. There is ample documentation online so it's straightforward to find a solution to any problem you might encounter. For example, I needed to convert a string of HTML code to a properly formatted HTML file to "modify." Easy to do when there are so many users of the product who have needed to do that same thing before.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We've used both Notepad++ and Atom; both are great but nothing really beats the Sublime Text UI; super intuitive and friendly and does everything you need without overwhelming you with stuff you don't. Other options are free, but for our organization, it was well worth the small license cost for the persistent use of a great product.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Sublime Text has helped me to focus on specific tasks, cutting out the clutter that many other IDEs have. As such, it has helped me be a more productive employee because I don't get dazed by hundreds of buttons. I can focus on just the code.
Sublime Text is so affordable that it's a no-brainer to have an extra tool in your toolset.
The Search features of Sublime Text are so useful that it has saved me a great amount of time compared to using Find & Replace menus in Xcode, Android Studio, or Eclipse.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
