Querying DataPDF version

Multi database support for SQL query

The Hue SQL AI Assistant now supports multi-database querying, allowing you to retrieve data from multiple databases simultaneously. This enhancement simplifies managing large datasets across different systems and enables seamless cross-database queries.

  1. Click Assistant on the Hue SQL editor, then open the AI Assistant Settings.
  2. Select the databases you want to include in your queries. You can choose multiple databases from the list provided and click OK.
  3. Enter your prompt in natural language to generate SQL queries.
    Querying across multiple databases
    Database Name Tables
    CalMart_Sales_DB Customers, Sales, Sales_Items
    CalMart_Products_DB Products, Suppliers, Product_Supplier

    Use Case: Identifying Top-Selling Products and Their Suppliers.

    Objective: Retrieve top-selling products along with their suppliers by combining data from two databases.
    SELECT 
        si.product_id, 
        p.product_name, 
        SUM(si.quantity) AS total_quantity_sold, 
        s.supplier_name
    FROM 
        CalMart_Sales_DB.Sales_Items si
    JOIN 
        CalMart_Products_DB.Products p 
    ON 
        si.product_id = p.product_id
    JOIN 
        CalMart_Products_DB.Product_Supplier ps 
    ON 
        p.product_id = ps.product_id
    JOIN 
        CalMart_Products_DB.Suppliers s 
    ON 
        ps.supplier_id = s.supplier_id
    GROUP BY 
        si.product_id, p.product_name, s.supplier_name
    ORDER BY 
        total_quantity_sold DESC;
    This query retrieves a comprehensive list of top-selling products along with their suppliers by combining data from multiple databases.

We want your opinion

How can we improve this page?

What kind of feedback do you have?