Google BigQuery

  • Cloud Databases

Connect DashboardFox to Google BigQuery for seamless access to your data warehouse, enabling real-time reporting and interactive dashboards from your large datasets.

About

Google BigQuery is a fully-managed, serverless data warehouse designed for fast SQL queries and real-time analytics on large datasets. It allows organizations to store and analyze massive amounts of data quickly and efficiently, leveraging Google’s powerful infrastructure. When integrated with DashboardFox via the Google BigQuery ODBC driver, users can access real-time data to create detailed reports and interactive dashboards. This integration enables businesses to derive valuable insights from their data without the need for extensive data movement.

Supported Versions

Google BigQuery operates as a continuously updated service, so it doesn’t have traditional versioning.

Integration Capabilities

  • Live query read-only access to your data source
  • Support for standard SQL queries
  • Compatibility with Views
  • Dynamic Data Source Connection Strings

Requirements

  • Google BigQuery ODBC driver installed and configured
  • Network/Firewall access to the Google BigQuery project
  • User ID with read-only access permissions

Integration FAQs

  • How do I get started with this integration?

    If you have admin privileges, navigate to Settings > Integration and select Create a New App for the data source you want to use.

  • What types of data can I access through this integration?

    DashboardFox generates SQL queries dynamically using the official database driver, ODBC driver, or API endpoint. Through this integration, you can access a variety of structured data from your data source, such as tables, views, and results from stored procedures in MSSQL and MySQL.

  • How do I refresh the data in DashboardFox after making changes in my database?

    DashboardFox performs live queries against your data source, ensuring that every time a report or dashboard is executed, it retrieves the most up-to-date data available. This means you always have access to the latest information without needing to manually refresh anything.

  • Can DashboardFox cause any damage or harm to my data source?

    DashboardFox performs read-only queries against the connected data source, meaning it cannot write or modify any data. However, if queries are designed to pull excessive amounts of data, they can consume significant resources, potentially leading to timeouts or increased load that may affect overall performance.

Better Business Intelligence
Starts Here

No pushy sales calls or hidden fees – just flexible demo options and
transparent pricing.

Contact Us DashboardFox Mascot