BigQuery (beta)
Use BigQuery as a data source for your Softr app or dashboard.
Softr's BigQuery connection lets you unlock the power of your data warehouse like never before. Build custom dashboards, reports, and even full-fledged apps, all tailored to your business's specific needs.
Prerequisites
- An active Softr account
- A Google Cloud Platform project with BigQuery enabled
- A dataset within your BigQuery project
- At least read-only access permissions for Softr to access your BigQuery dataset
Connecting Softr to BigQuery
- Navigate to your data sources from your Softr dashboard.
- Select "BigQuery" and initiate OAuth Flow:
- Click "Connect data source"
- Choose "BigQuery" and follow the on-screen prompts to authenticate with Google using OAuth.
- Grant Softr the necessary read-only permissions to your BigQuery datasets.
Building Apps and Dashboards
- Select your data source
- When creating a new dashboard or app block, select "BigQuery" as your data source.
- Select the specific dataset and table you'd like to visualize.
- Customize your visualization
- Softr offers a wide range of charts and block types.
- Build dashboards with multiple visualization blocks tailored to different needs.
- Advanced: Write custom queries (optional)
- For more complex data analysis, use Softr's built-in query editor to write SQL queries directly against your BigQuery data.
- Connect the results of your queries to dynamic blocks to display custom visualizations or tables.
- Control access
- Use Softr's built-in user management and permissions to determine who can see which dashboards and data.
Key use cases
Tailored reporting
Empower users with intuitive dashboards tailored to their specific roles. This enables them to track key metrics like user activity, application performance, and payment trends directly within the Softr workspace. For example, your team can easily build a comprehensive users and applications dashboard without complex analytics software.
External data sharing
Securely provide strategic insights to partners and vendors. For example think of yourself as an ecommerce platform that can now extract product performance data from your BigQuery warehouse and offer partners valuable dashboards highlighting how their products are performing.
Important notes
- The current integration offers read-only access to BigQuery.
- Consider BigQuery's pricing structure, as costs are based on data volume analyzed.
- BigQuery excels at analyzing massive datasets and powering complex reports. It's not a replacement for core SQL database (like PostgreSQL, MySQL) or structured database products like Airtable or SmartSuite.
Last updated on April 15, 2024