bordway
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Enable dynamic datasets (databases) for BigQuery
Hey DRay, I looked into using the Dynamic Schema for BQ and User Parameters, but when I tested it, it didn't actually swap the dataset being used by the Live Model based on the user that's logged in. I'm not sure what it's supposed to be swapping, but it wasn't swapping datasets2.2KViews0likes0CommentsEnable dynamic datasets (databases) for BigQuery
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 Snowflake2.6KViews9likes8Comments