Show Table

Column Verbose Name Type Groupable Filterable Is temporal
day DATETIME
rn Linha STRING
trip_headsign Viagem STRING
monitorado Monitorado STRING
project_id None STRING
dayoperacao Dia STRING
dt Horário de Partida STRING
company Operadora STRING
ref Tabela STRING
at Horário de Chegada STRING
Record Count: 10
Metric Verbose Name Type
count None None
Record Count: 1
Table Name Leonardo Bernardinelli-Untitled Query 2-J1JdVInEV
Sql select day ,company ,rn ,trip_headsign ,ref ,dt ,at ,monitorado ,project_id ,cast(substring(day,9,2)||'-'||substring(day,6,2)||'-'||substring(day,1,4) as varchar(10)) as dayoperacao from eficienciaporlinhacomtripitem where monitorado = 'Não'
Enable Filter Select False
Fetch Values Predicate None
Database realtime_db
Schema None
Description None
Owners [Leonardo Bernardinelli]
Main Datetime Column None
Default Endpoint None
Offset 0
Cache Timeout None
SQL Lab View True
Template parameters None
Perm [realtime_db].[Leonardo Bernardinelli-Untitled Query 2-J1JdVInEV](id:229)
Associated Charts [Viagens Não Monitoradas]