Passing Dynamic Values in Google Big Query

Published:

When working with Google BigQuery in Bold BI, it’s essential to understand how to dynamically configure connection strings for efficient data management and reporting. This article will guide you through the process of setting up dynamic connection strings for connection-level values and queries using custom attributes for connection string, schema and query-level values.

Dynamic Connection Strings in Bold BI

In the context of data analytics and business intelligence, the ability to adapt to changing data sources and structures is crucial. Bold BI, a comprehensive business intelligence tool, offers the capability to connect to various data sources dynamically. Since version 7.6, Bold BI has implemented support for dynamic connection strings for Google BigQuery.

Passing Dynamic values for Connection Strings

Dynamic connection strings allow you to modify the connection details to BigQuery without altering the dashboard or report configurations. This is particularly useful when you need to switch between different databases or environments.

To set up a dynamic connection string in Bold BI for BigQuery:

First, create a custom attribute for Google BigQuery Connection with the below syntax.

  {
       "ServiceId" = "",
       "Service" = "",
       "Provider" = "",
       "Database" = "",
       "IsServiceAccount" = "",
       "ClientID" = "",
       "Type" = "",
       "ClientEmail" = "",
       "PrivateKey" = ""
    }

In BiqQuery data source, add this custom attribute in the dynamic connection string. dialog and connect it.

You can also use External API option to pass the dynamic connection string to the data source

Passing Dynamic values for Schema and Query-Level Values

Bold BI provides a feature known as custom attributes that allows users to pass dynamic values within Google Big Query. This feature is particularly useful for customizing queries based on specific requirements without the need to hardcode values. Here’s how you can leverage custom attributes in Bold BI:

Utilizing Custom Attributes

Custom attributes can be a powerful way to pass dynamic values into BigQuery. They can be used in various parts of the query, including:

Schema names
Table names
Column names
Alias names

By using custom attributes, you can construct queries that adapt to different datasets or user requirements without hardcoding the specific details into the query itself.

Connecting in Bold BI:

To use custom attributes with Google Big Query in Bold BI, follow these steps:

Navigate to the data source configuration page in Bold BI.
Select Google Big Query as your data source.
Construct your query in the code view mode or drag and drop the table, inserting custom attributes where dynamic values are needed.

Additional References

Was this article useful?

Dislike

Written by Gayathri Ravichandran

Updated

Comments (0)