Dimensions on Google BigQuery

Version 1.0

Welcome to the documentation for the Dimensions on Google BigQuery implementation. The Dimensions on BigQuery data set enables users to perform large scale analysis and analytics of data available from the Dimensions database in combination with their own data or data from other sources.

The Dimensions dataset can be found here https://console.cloud.google.com/bigquery?p=dimensions-ai&page=project

This documentation provides details on configuring your Google BigQuery environment, information regarding the data available from our BigQuery data sets and some example queries to get you started.

Note

The Dimensions on Google BigQuery data set is subscription-only and as such, your Dimensions account needs to be activated for this service and is subject to restrictions on use. Please send an email to supportbigquery@dimensions.ai if you have any questions.

Tip

You can try out Dimensions on Google BigQuery using our sandbox environment, which is built around an open collection of COVID-19 documents. Make sure to check out also the Dimensions BigQuery Lab, a free resource containing more query examples and Jupyter notebooks.

Contents:

• Getting Started
• Google Cloud Platform Setup
  • Billing Accounts
  • Projects
  • BigQuery
• Sandbox Environment
  • Getting started
  • Sample queries
• Example Queries and Results
  • Simple Query
  • Retrieving Records
• Data Source Tables
  • Publications
  • Grants
  • Patents
  • Clinical Trials
  • Policy Documents
  • Datasets
  • Reports
  • Source Titles
  • Researchers
  • Organizations (GRID)
  • Organization Groups
  • Update frequency
  • Table partitions
  • Cross type links overview
• Notebooks & Programmatic Access
  • Notebooks
  • Unattended Programmatic Access
• Creating & Configuring Service Accounts
  • 1. Setup Google BigQuery access
  • 2. IAM and Accounts - Service Accounts
  • 3. Create the Service Account
  • 4. Assign Roles to the Service Account
  • 5. Create a Key for the Service Account
  • 6. Request Dimensions dataset access
  • ODBC/JDBC Access using Service Accounts
• Performance and Costs
  • Strategies for cost reduction
• Tutorials
  • Accessing Dimensions on GBQ using Tableau
  • Accessing Dimensions on GBQ using PowerBI
  • Building a COVID-19 Dashboard using Google Data Studio
  • Basic Topic Clustering using TensorFlow and BigQuery ML
• Reasonable Use
• Release Notes and Deprecations
  • Versions History
  • Deprecations History
• Frequently Asked Questions
  • 1. Access & Support
  • 2. Schema
  • 3. Snapshots