When creating a Live Model based on Bigquer tables, I seem to be unable to combine table from different BQ projects or even different datasets from the same project. As soon as I choose the BQ dataset ("database" in the Sisense UI) and add a table to the Live Model, I can only select from the same dataset but I missing any option to choose a different BQ dataset or project.
This would force us to make all tables available in the same dataset no matter where they are currently located across our 37 GCP projects. It also put us in a bind with regards to sensitive data that must not be available to everyone in the organisation.
No such restriction appear when building ElastiCubes.
Please sign in to leave a comment.