ComenzarEmpieza gratis

Lightning charger load

The machine learning team is interested in predicting the energy consumed in a charger's next session, with the goal of routing power to the chargers who might be taxed in the future. To train a model, they'd like you to prepare a dataset that includes information about the user, vehicle model, charging station, and energy consumed that "looks" forward to the next charge. Time to show them what you've got!

Este ejercicio forma parte del curso

Window Functions in Snowflake

Ver curso

Instrucciones del ejercicio

  • Retrieve the time_of_day, charging_rate, and energy_consumed for each record from the ELECTRIC_VEHICLES.charging table.
  • Use a window function to "look ahead" and retrieve the energy consumed in the next charging session; return 0 if not found.
  • Segment the records by charging_station_id and use the charging_start_time to create a sequence of records, in ascending order.

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

SELECT
    user_id,
    charging_station_id,
    charging_start_time,
    
    -- Retrieve the time_of_day, charging_rate and energy_consumed fields
	___,
    ___,
    ___,
	
    -- "Look ahead" to the energy consumed in the next session
    ___ OVER(
      
      	-- Segment the records by charging station and sequence
      	-- records by the start time of the charge
        ___
        ___
      
    ) AS next_session_energy_consumed

FROM ELECTRIC_VEHICLES.charging;
Editar y ejecutar código