LinkedIn
Twitter
Hi, I would like to choose specific start_date and end_date by a filter as where condition.
SQL I used - {CALENDAR.START}, and {CALENDAR.END} are selected by users format is like ‘2020-01-01’
FROM `prod.cv*`
WHERE _TABLE_SUFFIX BETWEEN FORMAT_TIMESTAMP("%Y%m%d", TIMESTAMP_ADD(TIMESTAMP({CALENDAR.START}), INTERVAL -7 DAY)) AND FORMAT_TIMESTAMP('%Y%m%d', TIMESTAMP_ADD(TIMESTAMP({CALENDAR.END}), INTERVAL +1 DAY))
How could I transfer this to looker?
I would like to use the filter like this
and this view, don’t want to use select * since the table is too huge to get all the columns
view: cv {
sql_table_name: focal-elf-631.prod.cv* ;;
