BigQuery
Integrating Google BigQuery with Structured
Google BigQuery is a powerful data warehouse that allows you to analyze large datasets quickly. Integrating BigQuery with Structured enables the creation of a robust semantic layer, ensuring consistent and accurate business metrics across your organization.
Step 1: Access the Integration
Navigate to Integrations
Go to the “Integrations” section in Structured.
Select Google BigQuery
Find and select “Google BigQuery” from the list of available integrations.
Step 2: Authenticate with Google BigQuery
Click 'Connect to Google BigQuery'
You will be redirected to a Google authentication page.
Sign In with Google
Use your Google account credentials that have access to the BigQuery project you want to integrate.
Grant Permissions
Approve Structured’s access to your BigQuery data. This includes permissions to read and query datasets.
Step 3: Select BigQuery Projects and Datasets
Choose BigQuery Project
After authentication, select the specific BigQuery project you want to pull data from.
Select Datasets and Tables
Choose the datasets and tables you wish to integrate with Structured. You can select multiple datasets to ensure comprehensive data coverage.
Step 4: Configure Data Sync
Define Sync Frequency
Set up how frequently you want Structured to sync data from BigQuery (e.g., hourly, daily).
Apply Filters
Apply any necessary data filters to focus on the most relevant data for your metrics.
Review and Confirm
Review your integration settings and confirm the setup. Structured will begin syncing data from Google BigQuery based on your configurations.
Step 5: Leverage the Semantic Layer
Map Data to Metrics
Use Structured’s interface to map the data from BigQuery to your organization’s standardized metrics. This step ensures that all data used in reports and dashboards are consistent across departments.
Create and Standardize Metrics
Define new metrics or standardize existing ones using the integrated BigQuery data. Structured’s semantic layer allows you to apply consistent business rules and calculations across all metrics.
Monitor and Optimize
Continuously monitor the performance and accuracy of your metrics. Use the semantic layer to adjust and optimize data usage as your business needs evolve.
Access Control and Permissions
Conclusion
Integrating Google BigQuery with Structured allows your organization to fully leverage the power of BigQuery’s data storage and analysis capabilities while ensuring consistency and reliability through Structured’s semantic layer. This integration not only enhances operational efficiency but also supports data-driven decision-making across the organization.