GOOGLE CLOUD EMEA LIMITED

BigQuery

BigQuery is Google's serverless, highly scalable, enterprise data warehouse designed to make all your data analysts productive at an unmatched price-performance. Because there is no infrastructure to manage, you can focus on analyzing data to find meaningful insights using familiar SQL without the need for a database administrator.

Features

  • Supports a standard SQL dialect which is ANSI:2011 compliant
  • Federated Query and Logical Data Warehousing
  • Provides a flexible, powerful foundation for machine learning and AI
  • Bringing ML to your data with BigQuery ML
  • Automatic backup and easy restore
  • High-speed streaming insertion API provides powerful foundations for real-time analytics
  • Geographic data control
  • Rich monitoring, logging and alerting through Stackdriver Audit Logs
  • Cost control mechanisms to cap your daily costs
  • Data is always encrypted, at rest and in transit

Benefits

  • Serverless data warehousing gives you the resources you need on-demand
  • Pay for storage and compute you use with on-demand pricing
  • Flat-rate pricing enables stable monthly costs for high-volume users
  • Transparently and automatically provides durable, replicated storage and high availability
  • Fine-grained role-based access controls on data through Cloud IAM integration
  • REST API for easy programmatic access and application integration
  • Easy to securely share insights within your organization and beyond
  • Allows organizations to capture and analyze data in real-time
  • Breaks down data silos to analyze all data assets
  • Big Data ecosystem integration

Pricing

£0 to £0 a unit a second

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at ps-frameworks@google.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 13

Service ID

6 0 1 9 2 9 1 0 8 8 1 5 9 8 5

Contact

GOOGLE CLOUD EMEA LIMITED Iain Burgess
Telephone: +447876258053
Email: ps-frameworks@google.com

Service scope

Service constraints
Please refer to https://cloud.google.com/bigquery/docs/ for more information on service constraints.
System requirements
  • For more information on technical requirements, please refer to:
  • https://cloud.google.com/bigquery/docs/

User support

Email or online ticketing support
Yes, at extra cost
Support response times
"The target response times as based on both the customer's support package and case priority. The different support packages on offer are:

Basic Support
Standard Support
Enhanced Support
Premium support

See more details and benefits of Support offerings: https://cloud.google.com/support
See: GCP: https://cloud.google.com/terms/tssg/

Workspace https://workspace.google.com/terms/tssg.html "
User can manage status and priority of support tickets
Yes
Online ticketing support accessibility
WCAG 2.1 AAA
Phone support
No
Web chat support
Yes, at an extra cost
Web chat support availability
9 to 5 (UK time), Monday to Friday
Web chat support accessibility standard
WCAG 2.1 AAA
Web chat accessibility testing
Admin must be signed into the Google Admin Console navigate to contact support link
Onsite support
No
Support levels
"Google offers four Support levels
-Basic (included for free, billing support only)
-Standard & Enhanced Support (available at an additional cost),
-Premium Support: Includes faster target response times and Technical Account Manager consulting services.

An overview of the support packages including cost is available here: https://cloud.google.com/support
Support available to third parties
No

Onboarding and offboarding

Getting started
Documentation, training, worked examples, best practices, and a free usage tier are available to assist users with getting started on Google Cloud Platform.

Getting Started: https://cloud.google.com/getting-started/
Online Documentation: https://cloud.google.com/docs/
Training Sessions: https://cloud.google.com/training/
Google Developers Codelabs provide a guided, tutorial, hands-on coding experience:
https://codelabs.developers.google.com/
Best practices: https://cloud.google.com/docs/enterprise/best-practices-for-enterprise-organizations
Free tier available: https://cloud.google.com/free/
Service documentation
Yes
Documentation formats
HTML
End-of-contract data extraction
Google Cloud Platform allows customers to extract data from the platform using the standard tooling and APIs that are available on the platform.

Google will enable Customer to delete Customer Data during the Term in a manner consistent with the functionality of the Services where applicable/ available. If Customer uses the Services to delete any Customer Data during the Term and that Customer Data cannot be recovered by Customer, this use will constitute an instruction to Google to delete the relevant Customer Data from Google’s systems in accordance with applicable law. Google will comply with this instruction as soon as reasonably practicable and within a maximum period of 180 days, unless EU or EU Member State law requires storage.

During the Term, Google will, in a manner consistent with the functionality of the Services, enable Customer to access, rectify and restrict processing of Customer Data, including via the deletion functionality provided by Google.

https://cloud.google.com/terms/data-processing-terms
End-of-contract process
Google will enable Customer to delete Customer Data during the Term in a manner consistent with the functionality of the Services. If Customer uses the Services to delete any Customer Data during the Term and that Customer Data cannot be recovered by Customer, this use will constitute an Instruction to Google to delete the relevant Customer Data from Google’s systems in accordance with applicable law. Google will comply with this Instruction as soon as reasonably practicable and within a maximum period of 180 days, unless European Law requires storage.

Using the service

Web browser interface
Yes
Using the web interface
Manage and get insights into everything that powers your cloud application -- including web applications, data analysis, virtual machines, datastore, databases, networking and developer services. Google Cloud Console helps you deploy, scale and diagnose production issues in a simple web based interface. Search to quickly find resources and connect to instances via SSH in the browser. Handle devops workflows on the go with powerful native iOS and Android applications. Master the most complex development tasks with Google Cloud Shell, your admin machine in the cloud.
Web interface accessibility standard
None or don’t know
How the web interface is accessible
Part of Google's mission is to make products and services universally accessible to users, including 1 billion people in the world who have a disability. This page outlines Google Cloud's accessibility resources. https://cloud.google.com/docs/accessibility https://www.google.co.uk/accessibility/"
We are working towards making our products and services more accessible for assistive technology users.
Web interface accessibility testing
It is in our pipeline to test and deliver our products and services to become more accessible for assistive technology users
API
Yes
What users can and can't do using the API
You can automate your workflows in your language by accessing the Google Cloud Platform products from your code. Cloud APIs provide similar functionality to Cloud SDK and Cloud Console, and allow you to automate your workflows by using your favorite language.
https://cloud.google.com/apis/
API automation tools
  • Ansible
  • Chef
  • OpenStack
  • SaltStack
  • Terraform
  • Puppet
  • Other
Other API automation tools
  • Jenkins
  • Packer
  • Kubernetes
  • Spinnaker
  • Google Cloud Deployment Manager
  • Pivotal
  • Openshift
  • Drone
API documentation
Yes
API documentation formats
HTML
Command line interface
Yes
Command line interface compatibility
  • Linux or Unix
  • Windows
  • MacOS
  • Other
Using the command line interface
The CLI can be used to access products and services on GCP from the command-line. You can run these tools interactively or in your automated scripts.
https://cloud.google.com/sdk/

Scaling

Scaling available
Yes
Scaling type
  • Automatic
  • Manual
Independence of resources
GCP runs on top of Google's infrastructure which serves many users across many products and services, the integrity and scale of those services ensures that user demand is handled appropriately.
Customer data is logically segregated by domain to allow data to be produced for a single tenant only.
The authorization to provision additional processing capacity is obtained through budget approvals and
managed through internal SLAs as part of an effective resource economy.

For all of our policies and compliance reports, please download directly from our compliance manager - https://cloud.google.com/security/compliance/compliance-reports-manager#/
Usage notifications
Yes
Usage reporting
  • API
  • Email
  • SMS
  • Other

Analytics

Infrastructure or application metrics
Yes
Metrics types
  • CPU
  • Disk
  • HTTP request and response status
  • Memory
  • Network
  • Number of active instances
  • Other
Other metrics
See documentation for further metrics https://cloud.google.com/products/management/
Reporting types
  • API access
  • Real-time dashboards
  • Regular reports

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Other security clearance
Government security clearance
None

Asset protection

Knowledge of data storage and processing locations
Yes
Data storage and processing locations
  • United Kingdom
  • European Economic Area (EEA)
  • Other locations
User control over data storage and processing locations
Yes
Datacentre security standards
Supplier-defined controls
Penetration testing frequency
At least once a year
Penetration testing approach
Another external penetration testing organisation
Protecting data at rest
  • Physical access control, complying with CSA CCM v3.0
  • Physical access control, complying with SSAE-16 / ISAE 3402
  • Physical access control, complying with another standard
  • Encryption of all physical media
  • Scale, obfuscating techniques, or data storage sharding
  • Other
Other data at rest protection approach
Google Cloud Platform encrypts customer content stored at rest, without any action required from the customer, using one or more encryption mechanisms.

Data for storage is split into chunks, and each chunk is encrypted with a unique data encryption key. These data encryption keys are stored with the data, encrypted with (""wrapped"" by) key encryption keys that are exclusively stored and used inside Google’s central Key Management Service. Google’s Key Management Service is redundant and globally distributed.

Data stored in Google Cloud Platform is encrypted at the storage level using either AES256 or AES128.

https://cloud.google.com/security/encryption-at-rest/default-encryption/
Data sanitisation process
Yes
Data sanitisation type
  • Explicit overwriting of storage before reallocation
  • Deleted data can’t be directly accessed
  • Hardware containing data is completely destroyed
Equipment disposal approach
In-house destruction process

Backup and recovery

Backup and recovery
Yes
Backup controls
This varies between services, users can control what backups are performed via the web interface, CLI or APIs in accordance with the shared responsibility model.
Datacentre setup
Multiple datacentres with disaster recovery
Scheduling backups
Users schedule backups through a web interface
Backup recovery
Users can recover backups themselves, for example through a web interface

Data-in-transit protection

Data protection between buyer and supplier networks
  • Private network or public sector network
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Bonded fibre optic connections
  • Legacy SSL and TLS (under version 1.2)
Data protection within supplier network
  • TLS (version 1.2 or above)
  • Other
Other protection within supplier network
The Google Cloud infrastructure provides secure deployment of services, secure storage of data with end user privacy safeguards, secure communications between services, secure and private communication with customers over the Internet, and safe operation by administrators.

Google Cloud infrastructure doesn’t rely on any single technology to make it secure. The security of the infrastructure is designed in progressive layers starting from the physical security of data centers, continuing on to the security of the hardware and software that underlie the infrastructure, and finally, the technical constraints and processes in place to support the operational security.

Availability and resilience

Guaranteed availability
Please refer to the link below:
https://cloud.google.com/terms/sla
Approach to resilience
Google operates a global network of data centers to reduce risks from geographical disruptions. The link below includes the locations of our data centers: http://www.google.com/about/datacenters/inside/locations/

Google does not depend on failover to other providers and builds redundancy and failover into its own global infrastructure.

Google performs annual testing of its business continuity plans to simulate disaster scenarios that
simulate catastrophic events that may disrupt Google operations.

For all of our policies and compliance reports, please download directly from our compliance manager - https://cloud.google.com/security/compliance/compliance-reports-manager#/
Outage reporting
Google maintains a dashboard with service availability and service issues here: https://status.cloud.google.com/

Identity and authentication

User authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google apps)
  • Dedicated link (for example VPN)
Access restrictions in management interfaces and support channels
Google Cloud Identity & Access Management (IAM) lets administrators authorize who can take action on specific resources, giving you full control and visibility to manage cloud resources centrally. IAM access policies are defined at the project level using granular controls of users and groups or using ACLs.

Support services are only provided to authorized customer administrators whose identities have been verified in several ways. Googler access is monitored and audited by our dedicated security, privacy, and internal audit teams.

https://cloud.google.com/iam/
https://services.google.com/fh/files/misc/google_security_wp.pdf
https://services.google.com/fh/files/misc/sep_2021_caiq_self_assessment.pdf
Access restriction testing frequency
At least once a year
Management access authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google Apps)
  • Dedicated link (for example VPN)
Devices users manage the service through
  • Dedicated device on a segregated network (providers own provision)
  • Dedicated device on a government network (for example PSN)
  • Dedicated device over multiple services or networks
  • Any device but through a bastion host (a bastion host is a server that provides access to a private network from an external network such as the internet)
  • Directly from any device which may also be used for normal business (for example web browsing or viewing external email)

Audit information for users

Access to user activity audit information
Users have access to real-time audit information
How long user audit data is stored for
User-defined
Access to supplier activity audit information
Users have access to real-time audit information
How long supplier audit data is stored for
User-defined
How long system logs are stored for
User-defined

Standards and certifications

ISO/IEC 27001 certification
No
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Cyber essentials
Yes
Cyber essentials plus
No
Other security certifications
No

Security governance

Named board-level person responsible for service security
Yes
Security governance certified
Yes
Security governance standards
Other
Other security governance standards
Full list of standards: https://cloud.google.com/security/compliance

SSAE16 / ISAE 3402 Type II: SOC 1, SOC 2, SOC 3 public audit report
ISO 27001, 27017, 27018
PCI DSS v3.1
CSA STAR
UK NCSC Cloud Security Principles
BSI C5
NIST 800-53, 800-171
HIPAA
IRAP
GDPR
Independent Security Evaluators Audit (ISE)
Cyber Essentials
Information security policies and processes
Google's cloud services are designed to deliver better security than many traditional on-premises solutions. Google makes security, and protection of data it's primary design criteria, which is the cornerstone of it's overall security governance and compliance audits. Google’s third party audit approach is designed to be comprehensive to provide assurances of Google’s information security capabilities. Customers may use these third party audits to assess how Google’s products can meet their compliance and data-processing needs.
https://cloud.google.com/security/overview/whitepaper
https://cloud.google.com/security/compliance

Operational security

Configuration and change management standard
Supplier-defined controls
Configuration and change management approach
In Google production environments, software updates are manually vetted to ensure the stability of the system. Changes are then tested and cautiously rolled out to systems. The details vary somewhat depending on the service being considered, but all development work is separated from the operation systems, testing occurs in a multi-staged fashion in both environments and in dedicated test settings. We can share, under NDA, the SOC2 audit report (based on standards from the International Auditing and Assurance Standards Board), which describes the change management process. Additionally, changes to code go through a process of code review involving additional engineer(s).
Vulnerability management type
Supplier-defined controls
Vulnerability management approach
Google administrates a vulnerability management process that actively scans for security threats using a combination of commercially available and purpose-built in-house tools, intensive-automated and manual penetration efforts, quality assurance processes, software security reviews and external audits. The vulnerability management team is responsible for tracking and following up on vulnerabilities. Once a vulnerability requiring remediation has been identified, it is logged, prioritized according to severity, and assigned an owner. The vulnerability management team tracks and follows up frequently until remediated. Google also maintains relationships with members of the security research community to track issues in Google services and open-source tools.

https://cloud.google.com/security/overview/whitepaper#vulnerability_management
Protective monitoring type
Supplier-defined controls
Protective monitoring approach
At many points across our global network, internal traffic is inspected for suspicious behavior, such as the presence of traffic that might indicate botnet connections. This analysis is performed using a combination of open-source and commercial tools for traffic capture and parsing. A proprietary correlation system built on top of Google technology also supports this analysis. Network analysis is supplemented by examining system logs to identify unusual behavior, such as attempted access of customer data. Google security engineers place standing search alerts on public data repositories to look for security incidents that might affect the company’s infrastructure.

https://cloud.google.com/security/overview/whitepaper#monitoring
Incident management type
Supplier-defined controls
Incident management approach
We have a rigorous incident management process for security events that may affect the confidentiality, integrity, or availability of systems or data. This process specifies courses of action, procedures for notification, escalation, mitigation, and documentation. Google’s security incident management program is structured around the NIST guidance on handling incidents (NIST SP 800–61). Key staff are trained in forensics and handling evidence in preparation for an event, including the use of third-party and proprietary tools. Testing of incident response plans is performed for key areas, such as systems that store sensitive customer information.

https://cloud.google.com/security/overview/whitepaper#incident_management

Secure development

Approach to secure software development best practice
Supplier-defined process

Separation between users

Virtualisation technology used to keep applications and users sharing the same infrastructure apart
Yes
Who implements virtualisation
Supplier
Virtualisation technologies used
KVM hypervisor
How shared infrastructure is kept separate
We have a variety of isolation and sandboxing techniques for protecting a service from other services running on the same machine. These techniques include normal Linux user separation, language and kernel-based sandboxes, and hardware virtualization. In general, we use more layers of isolation for riskier workloads; example, when running complex file format converters on user-supplied data or when running user supplied code for products like Google App Engine or Google Compute Engine. As an extra security boundary, we enable very sensitive services, such as the cluster orchestration service and some key management services, to run exclusively on dedicated machines.

Energy efficiency

Energy-efficient datacentres
No

Social Value

Fighting climate change

Fighting climate change

Google's commitment to achieving socially responsible goals.
We can demonstrate our reciprocal commitment through a broad set of sustainability
principles and activities. These principles focus on a people-centric framework that is robust,
integrated, diverse, and designed with unique locations, scalability, and longevity in mind.
Sustainability principles are embedded across our operations, infrastructure, people, and
products. Google’s five key sustainability commitments include:
● Data centres: Design and operate industry-leading carbon-neutral data centres
● Renewable energy: Google is the largest corporate purchaser of renewable energy,
our operations utilise 100% carbon-free energy
● Technology and tools: Design efficient and renewable consumer electronics and
empower users with sustainable technologies
● Supply chain: Build better and more sustainable devices and services by engaging
the entire supply chain
● Sustainable workplaces: Create end-to-end sustainable workplaces through ethical
labour practices and the careful selection and use of materials to operate facilities
Covid-19 recovery

Covid-19 recovery

Supporting global and local communities during the COVID crisis: During the
COVID-19 pandemic, over half of Britons used Google Search to keep up to date with the
latest Government advice. In response to the devastating effects of Coronavirus on lives and
communities, Google announced a $800+ million commitment to support small- and
medium-sized businesses (SMBs), health organisations, governments and health workers
on the frontline of the global pandemic. Details on the commitment and actions demonstrate
Google’s dedication to supporting communities, organisations, and people in need.
Tackling economic inequality

Tackling economic inequality

UK Digital Skills Training: In partnership with the Department for Work and Pensions
(DWP) we launched U.K.-wide Google Career Certificates. To support the need to learn new
skills, we’re distributing 9,500 Google Career Certificate scholarships in the UK through
government partnerships with the DWP (9,000) and Camden Council (500). Google are also
providing grant funding to The Prince’s Trust and INCO Academy via Google.org to ensure
that an additional 1,500 young people from underrepresented and disadvantaged
communities across the U.K. can take advantage of the training opportunity.
UK Living Wage Initiative: The Living Wage Foundation is an initiative that annually
calculates a minimum hourly living wage for the UK, and in London specifically. Google UK
worked with the Living Wage Foundation to certify the steps it takes to ensure Google UK
employees, suppliers, and vendors receive the correct living wage. Google UK is proud to
have earned accreditation as a Living Wage employer for the fourth year in a row. Google’s
accreditation is seen here and other accredited organisations can be viewed and searched
for here.
Equal opportunity

Equal opportunity

The UK Government requires organisations with 250 or more employees to publish and report specific figures about their binary gender pay gap. T

https://static.googleusercontent.com/media/diversity.google/en//static/pdf/Google_UK_2020_21_Binary_Gender_Pay_Gap_Report.pdf
Wellbeing

Wellbeing

Google provides access to workshops that can be incorporated into your own Diversity, Equity and Inclusion (DEI) initiatives such as the #IAmRemarkable workshops to empower women and underrepresented groups to speak openly about their accomplishments and inclusive Leadership Series to create belonging on your team through inclusive communication skills

Pricing

Price
£0 to £0 a unit a second
Discount for educational organisations
No
Free trial available
No

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at ps-frameworks@google.com. Tell them what format you need. It will help if you say what assistive technology you use.