We heard you and we’re thrilled to announce an enhancement to the Civis Analytics Platform experience: the introduction of a dedicated dbt (data build tool) job type. Data practitioners who love dbt can now integrate dbt jobs seamlessly with their existing Civis workflows.
Historically, analytics engineers have managed and orchestrated dozens of separate individual SQL scripts, which are often difficult to point to different schemas and run in different environments. Development is done against production data, resulting in errors and delayed deliverables to stakeholders. Without a standard way to write data tests, errors can go unnoticed.
dbt solves these problems for analytics engineers, by consolidating these functions into a single data build tool pipeline. dbt is an open-source, SQL-based transformation tool, which allows for collaborative development and deployment of analytics code. It follows top software engineering practices like modular design, portability, consistent testing, and robust documentation. Its use has become industry standard for data teams, including many Civis customers and our own in-house data engineers.
We’re excited to bring this capability into existing Civis Platform workflows
Our new dbt capability continues to expand Civis Analytics as the all-in-one enterprise data warehousing solution. By bringing the power of dbt into Platform, our users can now seamlessly orchestrate all stages of ELT pipelines, combining imports, dbt pipelines, and enhancement scripts, all in a single platform.
dbt is run securely in the user’s own Civis environment, without requiring additional subscription services. Users can implement trusted industry standards on how to build and manage their data by using dbt pipelines all through the Civis Analytics Platform.
The dbt job type provides the following benefits:
To leverage the new dbt job type, simply navigate to the Code section in the Top Navigation on Platform and select dbt. From there, users can connect dbt with their existing database credentials and configure the desired commands to execute. The streamlined interface guides users through each step, ensuring a smooth setup and execution process. For more information utilize the documentation.
Civis Analytics is committed to supporting tools which data scientists love and ensuring that our Platform remains at the forefront of data science technology. Our new dbt job type is designed to provide users with greater flexibility, efficiency, and control over data transformation tasks. We’re excited to see how this new dbt job type will transform your data workflows, making our user’s analytics engineering more powerful and efficient. With Civis Analytics, data transformation is always in good hands!
If you’re excited about sharing more of the data that is driving your work with your stakeholders, we invite you to reach out to our team of experts. Let us guide you through the process, answer any questions you may have, and help you create and share your services.
