Likelihood to Recommend When I am working with a large team of developers. Also, when a security policy, you are not allowed to install any app on your laptop. Cloud 9 is well integrated with Cloud commit. So we don't have to spend time in configurations.
Read full review If you can load your data first into your warehouse, dbt is excellent. It does the T(ransformation) part of ELT brilliantly but does not do the E(xtract) or L(oad) part. If you know SQL or your development team knows SQL, it's a framework and extension around that. So, it's easy to learn and easy to hire people with that technical skill (as opposed to specific Informatica,
SnapLogic , etc. experience). dbt uses plain text files and integrates with GitHub. You can easily see the changes made between versions. In GUI-based UIs it was always hard to tell what someone had changed. Each "model" is essentially a "SELECT" statement. You never need to do a "CREATE TABLE" or "CREATE VIEW" - it's all done for you, leaving you to work on the business logic. Instead of saying "FROM specific_db.schema.table" you indicate "FROM ref('my_other_model')". It creates an internal dependency diagram you can view in a DAG. When you deploy, the dependencies work like magic in your various environments. They also have great documentation, an active slack community, training, and support. I like the enhancements they have been making and I believe they are headed in a good direction.
Read full review Pros It provides an extremely intuitive and easy-to-use interface, so adapting to it does not take much time. It contains the most common programming languages. It allows the export of files, either directly to the repository or to the team where you want it. It is housed in the cloud so you can work with it from anywhere. Allows you to share code or work on them with others in real-time. Does not require installation. Read full review user experience makes it easy to work with SQL and version control customer success team and the dbt (data build tool) community help establish best practices thorough and clear documentation Read full review Cons Confusing documentation - AWS's documentation remains quite confusing, and the layout of other services/settings that you have to use with Cloud9 can be a bit of a handful. Sometimes slow - As the size of a project increases, the editor gets increasingly slower, and starts slowing down the browser overall. Long setup process - The setup for Cloud9 can be hard and tough, especially since the documentation is quite hard to understand. Read full review Slow load times of the dbt cloud environment (they're working on it via a new UI though) More out-of-the-box solutions for managing procedures, functions, etc would be nice to have, but honestly, it's pretty easy to figure out how to adapt dbt macros Read full review Usability The interface for Cloud9 needs some improvement. It is simply not as powerful and intelligent as a local text editor would be and thus it lacks the capabilities of fast filling when coding. Otherwise, I think it has a fair interface that they have tried mimicking an IDE.
Read full review Support Rating Customer support is managed by the Cloud support team. I won't be able to comment on details, but it's fast.
Read full review Alternatives Considered [AWS] Cloud9 offers specific features not available in the competition: Code collaboration using the chat features is the highlight which sets it apart. [The] code completion feature makes [it] very similar to the offline IDE like eclipse. It's much easier to use compared to
Codeanywhere . It provides terminal access to EC2 instances and hence other amazon services.
Read full review Most ETL pipeline products have a T layer, but dbt just does it better. The transformation is on steroids compared to the others. Also, just allows much more Adhoc solutions for very specific projects. Those ETL tools are probably better on the T part if you don't need too many transforms - also dbt is pretty much free dependent on how you work it, also extremely scalable.
Read full review Return on Investment We save time since we do not need to configure files or our equipment. We have the most appropriate tools for software development in one place. We can work from anywhere so if that day we could not get to our office or something we can do from home. We can code with a single browser. Read full review Simplified our BI layer for faster load times Increased the quality of data reaching our end users Makes complex transformations manageable Read full review ScreenShots