Google BigQuery Metrics

Foji is a versatile data integration platform that allows you to connect and process data from various sources, including Google BigQuery. This documentation will guide you through the process of configuring Google BigQuery Metrics as a data source in Foji. The Google BigQuery Metrics configuration enables you to retrieve and analyze performance and usage metrics from your BigQuery datasets. To configure the data source, you will need to provide the following fields: Name, Connection, Projection ID, Scan Interval, and Query.

Step 1: Accessing Data Source Configuration

1. Log in to your Foji account and navigate to the data sources section.
2. Click on the "Add Data Source" button or select the option to create a new data source.

Step 2: Naming the Data Source

1. In the "Name" field, enter a unique name for your Google BigQuery Metrics data source. Choose a descriptive name that helps you identify the purpose or characteristics of this data source.

Step 3: Configuring Google BigQuery Metrics Connection

1. Connection: Select or configure the connection to your Google BigQuery project. Ensure that the connection is established and authenticated before proceeding.

Step 4: Configuring BigQuery Metrics Specifics

1. Projection ID: Enter the ID of the BigQuery table or view that contains the metrics you want to retrieve. This ID identifies the specific dataset and table or view within your BigQuery project.
2. Scan Interval: Specify the interval at which Foji should scan for new metrics data. Choose a suitable scan interval that aligns with your data update frequency and requirements.
3. Query: Optionally, provide a custom SQL query to retrieve specific metrics or perform aggregations on the metrics data. Use standard SQL syntax to construct the query. Note that the query is optional, and you can leave it blank to retrieve all available metrics.

Step 5: Saving and Using the Data Source

1. After providing the necessary configuration details, click on the "Save" or "Create" button to save the Google BigQuery Metrics data source configuration.
2. You can now use this data source in your Foji workflows to access and process the BigQuery metrics data. Utilize Foji's data transformation capabilities to analyze and visualize the metrics or integrate them into your data pipelines.
3. contact the Foji support team for more information on utilizing the Google BigQuery Metrics data source within your workflows.

Conclusion

By following the steps outlined in this documentation, you can configure Google BigQuery Metrics as a data source in Foji. This allows you to retrieve and analyze performance and usage metrics from your BigQuery datasets, providing valuable insights for your data integration and processing tasks using the Foji platform.