BiqQuery views should be dynamically created

[thdk]

There should not be any manual step when deploying to a new environment.

Therefor it should be possible to create the big query views (timesheets_view and projects_view), that have been created using the bigquery UI, from code.

Documentation: https://cloud.google.com/bigquery/docs/views

"Call the tables.insert method with a table resource that contains a view property."

[thdk]

with ranked as (
SELECT r.Id, r.time Time, r.project p1, r.userid, r.task t1, r.modified, r.description Description, r.date Date, r.deleted, r.client, r.divisionId, row_number() over (partition by r.id order by r.modified desc) rank
FROM `PROJECT.timesheets.registrations` r 
where r.date < current_timestamp() 
)

select r.Time, p.name Project, r.Description, r.date Date, u.name User, t.name Task, c.name Client, st.subteam Subteam, st.scrumteam Scrumteam, st.email Email, r.divisionId division from ranked r
left outer join `PROJECT.timesheets.projects_view` p
on r.p1 = p.id
left outer join `PROJECT.timesheets.users_view` u
on r.userid = u.id
left outer join `PROJECT.timesheets.tasks` t
on r.t1 = t.__key__.name
left outer join `PROJECT.timesheets.SubteamUser` st
on st.id = u.id
left outer join `PROJECT.timesheets.clients` c
on c.__key__.name = r.client
where r.rank = 1 
and (r.divisionId is null or r.divisionId = "")
and r.time is not null 
and (r.deleted is null or r.deleted = false)