GCP: BigQuery Applications
Source - [Link]
Google Cloud Platform : Cloud Training
Business Need GCP Data Solution
Compute Storage, Disk Storage Persistent Disk, SSD
Storing Media, Blob Storage Cloud Storage
Document Database NOSQL DataStore
Fast Scanning NOSQL BigTable
SQL Interface at file Data BigQuery
Analytics/ Datawarehouse BigQuery
Transactional RDBMS Cloud SQL, Cloud Spanner
Google Cloud Platform : Cloud Training
➤ BigQuery features for businesses
➤ Serverless Insight : BigQuery has a serverless architecture, which allows user
to scale your analytics automatically.
➤ Real-time analytics : BigQuery machine learning offers real-time analytics. This
has a high-speed streaming insertion API.
➤ With real-time analytics, you can input your latest business data and analyze
it immediately.
➤ Logical data warehousing : User can process external data sources through
BigQuery. It’s a great way to help you to input all your data and process it
without every duplicating your data.
➤ Data transfer services : Service allow user to transfer your data from external
sources automatically. Great tool to merge data from multiple tools at one place.
➤ Can transfer data from Google Marketing Platform, Google Ads, YouTube,
Partner SaaS applications to BigQuery, Teradata, Amazon S3
Google Cloud Platform : Cloud Training
➤ BigQuery features for businesses
➤ High Availability : User can have multiple locations of
storage and high availability for those locations.
➤ Geoexpansion : BigQuery machine learning gives you the
option to control your geographic data. It only applies to the
US, Asia, and Europe.
➤ Automatic Backup and Easy Restore : Data is money, user
don’t want to lose it while trying to process it. With
BigQuery, information is automatically replicated and stored.
Google Cloud Platform : Cloud Training
➤ BigQuery : Benefits of Use
➤ Fast SetUp : User can set up a data warehouse in seconds. As soon as
your data warehouse is set up, you can start to query your data
immediately.
➤ Easy to Use : Building your own data center is not only expensive but
time-consuming and challenging to scale. BigQuery makes the process
simple. You load your data into the tool and only pay for what you use.
➤ Automatic Scale : BigQuery separates storing and computing data.
This process enables elastic scaling, which helps you scale at a higher
performance rate. It works seamlessly for real-time analytics and
appropriately scales your data.
➤ Data Protection : BigQuery protects your data and maintains strong
security over it.
Google Cloud Platform : Cloud Training
➤ BigQuery : Benefits of Use
➤ Affordable : BigQuery’s pricing works with your business. You
only pay for the resources you use.
➤ BigQuery charged separately for storage and streaming inserts.
For Storage:
$0.02 per GB, per month
$0.01 per Gb, per month for long-term storage
For Streaming Inserts:
$0.01 per 200MB
➤ Google also offers two subscription plans:
Pay-as-you-go: $5 per TB per month
Will see you in Next Lecture…
See you in next lecture …
