hero.badge

    hero.title

    hero.subtitle

    hero.cta.primaryhero.cta.secondary
    sqlFirst.badge

    sqlFirst.title

    sqlFirst.subtitle

    sqlFirst.features.postgres.title

    sqlFirst.features.postgres.description

    sqlFirst.features.noLimits.title

    sqlFirst.features.noLimits.description

    sqlFirst.features.schema.title

    sqlFirst.features.schema.description

    sqlFirst.howItWorks.title

    sqlFirst.howItWorks.description

    fleet_analytics.sql
    SELECT
    v.vehicle_id,
    v.license_plate,
    COUNT(t.trip_id) AS total_trips,
    SUM(t.distance_km) AS total_distance
    FROM bronze.vehicles v
    JOIN silver.trips t
    ON t.vehicle_id = v.id
    WHERE t.start_time > NOW() - INTERVAL '30 days'
    GROUP BY 1, 2
    ORDER BY total_distance DESC;
    explorer.badge

    explorer.title

    explorer.subtitle

    explorer.features.realtime.title

    explorer.features.realtime.description

    • •explorer.features.realtime.feature1
    • •explorer.features.realtime.feature2
    • •explorer.features.realtime.feature3

    explorer.features.historical.title

    explorer.features.historical.description

    • •explorer.features.historical.feature1
    • •explorer.features.historical.feature2
    • •explorer.features.historical.feature3

    explorer.features.custom.title

    explorer.features.custom.description

    • •explorer.features.custom.feature1
    • •explorer.features.custom.feature2
    • •explorer.features.custom.feature3
    explorer.cta
    biTools.badge

    biTools.title

    biTools.subtitle

    biTools.tools.powerbi.title

    biTools.tools.powerbi.description

    biTools.tools.powerbi.badge

    biTools.tools.superset.title

    biTools.tools.superset.description

    biTools.tools.superset.badge

    biTools.tools.python.title

    biTools.tools.python.description

    biTools.tools.python.badge

    biTools.tools.tableau.title

    biTools.tools.tableau.description

    biTools.tools.tableau.badge
    biTools.docsLink
    mlAi.pipeline.step1.title

    mlAi.pipeline.step1.description

    mlAi.pipeline.step2.title

    mlAi.pipeline.step2.description

    mlAi.pipeline.step3.title

    mlAi.pipeline.step3.description

    mlAi.badge

    mlAi.title

    mlAi.subtitle

    mlAi.useCases.predictive.title

    mlAi.useCases.predictive.description

    mlAi.useCases.optimization.title

    mlAi.useCases.optimization.description

    mlAi.useCases.scoring.title

    mlAi.useCases.scoring.description

    recipes.badge

    recipes.title

    recipes.subtitle

    recipes.examples.geofence.title

    recipes.examples.geofence.description

    recipes.examples.geofence.badge

    recipes.examples.fuel.title

    recipes.examples.fuel.description

    recipes.examples.fuel.badge

    recipes.examples.ecodriving.title

    recipes.examples.ecodriving.description

    recipes.examples.ecodriving.badge

    recipes.examples.support.title

    recipes.examples.support.description

    recipes.examples.support.badge
    recipes.cta
    future.badge

    future.title

    future.subtitle

    future.features.geospatial.title

    future.features.geospatial.description

    future.features.temporal.title

    future.features.temporal.description

    future.features.goldMarts.title

    future.features.goldMarts.description

    cta.title

    cta.subtitle

    cta.primaryView Use Casescta.secondary
    cta.links.useCasescta.links.docs

    Related Pages

    IoT Query Overview
    Core features and capabilities
    Architecture & Governance
    Technical architecture and data layers
    Use Cases
    Real-world solutions and applications
    Developer Docs
    SQL recipes and API documentation