Synq+dbt

Reliability for business-critical dbt deployments

Complement your dbt deployment with reliability tools that help you run dbt in business critical workflows at any scale. Up and running in 30 minutes.

Detect Strategy

dbt Tests, Contracts and Synq Monitors designed to work together

Synq monitoring complements dbt Tests and Contracts helping you build one holistic testing strategy.

  • Detect data issues that you can’t express as tests
    Apply self-learning monitors to verify thresholds that evolve and change together with your business.
  • Deploy monitors to specific dbt assets
    Use your existing metadata, tags or folder structure to precisely deploy monitors.
  • Build alerting around dbt Groups
    Reuse your dbt Groups or owner metadata to route alerts to the right teams.

Native support for all dbt concepts

Built with analytics engineering mindset, all dbt entities are first class citizens in Synq.

Models

Understand schema, materialization and any data for all dbt models. Including ephemeral models or models with multiple versions.

Tests

All dbt tests are neatly organised to their relevant column.

Metrics

Connect models, metrics and downstream BI tools into one lineage.

Groups

Turn dbt Groups into Synq data products and get instant view of their dependencies.

Contracts

Get unified view of data contracts, tests, monitors for every single model.

Exposures

Capture any external dependencies as exposures that automatically appear in the lineage.

New experience connecting column-lineage and code into a single workflow

Column-level lineage is not enough. To manage scaled dbt deployments with models having hundreds or thousands lines of code, Synq helps practitioners understand how exactly their code works.

customer_segmentation
orders AS (
  SELECT
    order_id,
    customer_id,
    order_date
  FROM orders
),

order_items AS (
  SELECT
    order_id,
    product_id,
    quantity,
    unit_price
  FROM order_items
),

order_items_total AS (
  SELECT
    order_id,
    SUM(quantity * unit_price) AS total
  FROM order_items
  GROUP BY order_id
),

SELECT
  customer_id,
  SUM(total) AS value,
  NTILE(4) OVER (ORDER BY value) AS value_quartile
FROM orders
JOIN order_items_total USING (order_id)
GROUP BY customer_id
orders
...

SELECT
  order_id,
  customer_id,
  order_date
FROM fivetran.orders
  
order_items
...

SELECT
  order_id,
  product_id,
  quantity,
  unit_price
FROM fivetran.order_items
  

Synq lineage understands how data flows through layers of CTEs and subqueries and where in code the logic exactly is, accelerating planning, refactoring and debugging workflows.

Detect Strategy

Workflows for dbt that scale across the company

Operationalize cross-team ownership model and assign data responsibility across teams and domains. Leverage your dbt metadata to route alerts, deploy monitors or define data products.

  • Track dependencies of your critical data use cases
    Synq data products can leverage exposures, groups to bring clarity into proritisation of issues at scale.
  • Map team dependencies
    Understand flow of data not just between tables and models, but also domains and teams.
  • Decentralise ownership
    Effectively route alerts to relevant teams across data, engineering and business operations.

Manage dbt errors like a software pro

Hooking your dbt or monitors straight into pager systems is no longer viable. Synq facilitates a workflow – from issue detection, to impact assessment, to resolution, and post-incident analysis.

diagram

A fully integrated data reliability platform

Our integrations make it easy to work with all the platforms and applications you want to use. We’re proud to be a fully integrated platform for data quality.

Explore integrations

FAQs

How does Synq work?

Synq is the data reliability platform for teams that own business-critical data. Synq delivers precise anomaly detection, a robust ownership model, incident management and issue resolution for teams that power business-critical use cases.

Is Synq a SaaS-based solution or on-prem?

Synq is a cloud tool (run on Google Cloud) that can be accessed directly through your web browser from anywhere.

How long does it take to get up and running on Synq?

Less than 30 minutes! New Synq customers often can’t quite believe this when they hear it. But the way Synq is architected means you can start using the platform and improving your data reliability in the time it takes to make and drink a cup of coffee.

How does Synq pricing work?

We have three pricing tiers to suit businesses at different stages of their data-reliability journey.

Do you provide platform training or support?

Yes. We’re data experts that love collaborating with and helping data teams. Our support team is here to handle urgent issues. And we offer a consultative service to help you get the most out of the Synq platform. We approach each case looking at business problems, not just tool problems. We help our clients to understand what’s really business-critical, how well it’s working, and how to ensure that any critical impact is prioritized.

Can someone give me a demonstration?

Yes, you can request a demo here (with an actual data expert, not a salesperson). Or if you’re in a rush to find out how Synq works, you can check out our YouTube channel.

How do I get started?

Quickly and easily. After you’ve been assigned a Synq workspace, just follow these steps for the optimal setup.

How often do you update the platform?

Synq continuously innovates and ships quickly so our customers can manage their business-critical data more easily and efficiently. From column-core lineage, to prioritized incident management, to automated alerts that link between incidents and critical data products – where we lead, the market follows.

How secure is Synq?

Absolutely. Synq adheres to SOC2 and GDPR regulations. Our design and operations prioritise security, ensuring the safeguarding of individual systems and information through cryptographic controls. We are hosted on Google Cloud (GCP/Europe) and encryption is applied by default to all data in transit and at rest. (for what its worth, we've been successfully onboarded by a major bank, and we all know how strict they are!)

What is Synq’s data-retention policy?

Customer data is retained for as long as the account is in active status. Data enters an “expired” state when the account is voluntarily closed. Expired account data will be retained for 28 calendar days. After this period, the account and related data will be removed. Check out our data policy here.

How do you get started with the Synq developer API?

The Synq API is available for developers to manage certain functionalities using custom workflows. Synq exposes its API as gRPC services. This means that the API is as easy to use as calling functions from your code.