Logo

EXPLORE YOUR QUERY DEPENDENCIES:
UNVEILING DATA RELATIONSHIPS!

Keep losing track of all your joined SQL queries?
Discover how our solution simplifies dependency management.
Paste your query and try!

Logo


TERMS OF USE

By using Query Dependencies, you are agreeing to the following conditions:

  • The queries you upload are processed on our server, running on Windows Azure, to generate the png file.
  • Your uploaded queries and the generated png are solely used for the purpose of providing the dependencies. We do not store or retain your data.

By using our service, you acknowledge and agree to these terms. If you do not agree with these terms, please refrain from using Query Dependencies.

HOW DOES IT WORK?

After pasting your SQL query, the query is transformed into a png. This PNG image depicts a visual representation of the query's dependencies, presenting them as a path.
Check out the example below, where the query is converted into an image.

WITH CustomerOrderCounts AS (
    SELECT 
        c.customer_id,
        c.country_id,
        COUNT(*) AS total_orders
    FROM 
        customers c
    JOIN 
        orders o ON c.customer_id = o.customer_id
    GROUP BY 
        c.customer_id, c.country_id
)

SELECT 
    co.country_name,
    coc.customer_id,
    coc.total_orders
FROM 
    (
    SELECT 
        c.customer_id,
        c.country_id,
        coc.total_orders
    FROM 
        customers c
    JOIN 
        CustomerOrderCounts coc ON c.customer_id = coc.customer_id
    ) coc
JOIN 
    countries co ON coc.country_id = co.country_id;
Logo

CCNTACT US

Use the form below to send us your feedback or contact us for any inquiries: