Enable dynamic datasets (databases) for BigQuery

[bordway]

Currently, dynamic/parameterized datasets are not supported in BigQuery connections. You can parameterize the service account information, which is great, but it would be helpful to be able to use a parameter to swap the dataset in the BigQuery connection based on who's currently viewing the dashboard.

For reference, parameterized datasets and schemas are supported by other database engines:

• Azure Synapse
• MS SQL
• MySQL
• PostgreSQL
• Redshift
• Snowflake

[KevinC]

It does seem like BQ should be supported like those other DB engines!

[oksanaj]

Introducing this feature would significantly enhance our ability to ensure top-tier security for the data housed in BigQuery (BQ). Remarkably, this feature is already seamlessly integrated into Sisense for Snowflake, underscoring its proven effectiveness. It stands to reason that extending this capability to other leading data warehouse providers is a strategic move. We kindly urge you to consider its incorporation into the roadmap as soon as possible, particularly with the understanding that it holds immense value for consumers of BigQuery, including our organization. Your attention to this enhancement would undoubtedly contribute to the robust security infrastructure we aspire to maintain for our data on the BQ platform with Sisense as our end user data interface .

[DRay]

Hello @bordway,

Thank you for submitting your Idea! 

Have you looked at Dynamic Schema for GBQ? It may address your use case by utilizing User Parameters. 

If that doesn't meet your needs please let me know and I'm happy to investigate further.

Have a great day!