I’m looking to extract a simple CURRENT_TIMESTAMP as a field in my LookML. For a MS SQL Azure DB.
However, I keep getting the error: ’ The Microsoft Azure SQL Database database encountered an error while running this query.
Each GROUP BY expression must contain at least one column that is not an outer reference.’
My example LookML:
dimension_group: current_time_test {
type: time
timeframes: [time, date, week, month]
sql: CURRENT_TIMESTAMP ;;
}