BigQuery

welcome to this step by step guide on connecting bigquery to kensu hub by establishing this connection, you will be able to retrieve comprehensive information, including schemas and metrics of the tables utilized in your data processing jobs, which are processed by the kensu collectors prerequisites before you begin configuring the bigquery connection, ensure you have the following a google cloud service account (for instance a json keyfile) with specific roles granted the necessary read permissions to access concerned datasets in the bigquery project the minimum roles needed are bigquery data viewer bigquery job user step by step follow the steps below to seamlessly integrate bigquery with kensu hub and unlock advanced data insights 1\ navigate to your kensu hub url https //xxxxx hub kensuapp com/ https //demo hub kensuapp com/kensu hub components plugin/#/connections 2\ upon accessing kensu hub, locate the data source connections panel on the dashboard here, you'll see a list of supported data sources find and click on bigquery configure to begin the process of creating a new connection 3\ inside the bigquery connection area, you'll find a section titled dependencies click on the configure button here to set up the prerequisites necessary for establishing a connection 4\ look for the + icon clicking on this icon will open a form where you can enter the details for your new bigquery connection 5\ now, you'll need to fill out the form with specific information about your google cloud account here's what you'll need conn id a unique id for your connection keyfile json the credentials json to connect the service account project id your google cloud project containing the elementary dataset 6\ after double checking the information you've entered, click on the submit button to finalize the connection kensu hub will process your details and establish a connection to your snowflake data source