I understood Looker now handles geojson features.
I typed the following query in the SQL runner, which worked well, where I create lines for each journey of a user.
WITH timeline as ( SELECT j.id as journey_id, s.gps_longitude as longitude, s.gps_latitude as latitude FROM journeys as j, syntheses as s, locations as l WHERE l.id = j.location_id AND s.vehicle_id = j.vehicle_id AND b.status = 'ended' AND s.created_at < b.returned_at AND s.created_at > b.from ORDER BY s.created_at ) SELECT journey_id, ST_SetSRID(ST_MakeLine(ST_MakePoint(longitude, latitude)), 4326) as geometry FROM timeline GROUP BY journey_id HAVING ST_NPoints(ST_MakeLine(ST_MakePoint(longitude, latitude))) > 1
When I import this query in my Looker project (as a
lookml) however, it seems I can only handle the
geometry I created as
string and not as a geographical object I could display in a look.
Many thanks for your answer