GCP

Spring GCP BigQuery

Reading Time: 3 minutes BigQuery is Google’s fully managed, petabyte scale, low cost analytics data warehouse. It’s Serverless, highly scalable, and cost-effective multicloud data warehouse designed for business agility. BigQuery Benefits Gain insights with real-time and predictive analytics– Query streaming data in real time and get up-to-date information on all your business processes. Predict business outcomes easily with built-in machine learning–without the need to move data. Access data and Continue Reading

BigQuery: Querying nested arrays

Reading Time: 2 minutes In a previous blog, we had seen BigQuery facilitate efficient data warehouse schema design. BigQuery supports the nested & repeated columns. We can use a combination of ARRAY and STRUCT data types to define our schema in BigQuery. It enables to denormalize data efficiently in single table. In this blog, for the same schema of sales data, we will execute a few DML operations on nested array fields. Schema In Continue Reading

BigQuery:  Efficient Data Warehouse Schema Design

Reading Time: 3 minutes Conventional data warehouses support data models based on star schema and snowflake schema. In these models, there are a number of fact tables and dimension tables. In order to minimize redundancy it is recommends to split data into multiple tables in . This is a normalization process. Normalization is the technique of eliminating the redundant data. It minimize the insertion, deletion, and update anomalies. It saves the disk Continue Reading

BigQuery: Rescue to the Conventional Data warehouse Problems

Reading Time: 4 minutes The present and future of every industry sector somehow depends on the ability to use the massive amounts of data. Use the data available to drive better product quality at a lower cost. Make favourable business decisions with data. Primarily, for decades, to store a wide variety of massive data and perform analysis on it, using Data Warehouse solutions. Traditional data warehouses designed on-premise specifically Continue Reading

gcp storage

Choosing the right GCP storage option

Reading Time: 4 minutes Overview GCP storage has a wide range of managed storage and database options in its portfolio. Knowing the characteristics of each and being able to select a suitable solution is vital as an architect during the design process. The choice of the right GCP storage solution is not simple. Making a decision on which storage solution is right for your requirements is a balance of Continue Reading

How to play with VPC Firewall and Subnets using gcloud CLI

Reading Time: 4 minutes Hello Readers! In this blog we will see how we can play with VPC Firewall and subnets using gcloud CLI in a few simple steps. Before starting this we again have some prerequisites you need to follow: You must have a GCP account for this and you must have activated your GCP cloud shell.  Let’s get started! List the VPC : The command for listing Continue Reading

Google Cloud Storage

Reading Time: 2 minutes Overview Cloud storage: Cloud storage is a cloud computing version wherein statistics is stored on far-off servers and accessed through a devoted net or personal community connection. The garage infrastructure is maintained, operated, and managed through a cloud storage carrier provider. what’s Google Cloud garage? Cloud storage is a garage provider for Google Cloud. An object is a static piece of facts that includes a file of any layout. She maintains things in packing containers known as buckets. All buckets are related to a project, and you can bring together your tasks underneath a corporation.when you create a venture, you may create buckets in Cloud garage, upload objects in your buckets, and download objects for your buckets. you can also provide permissions to make your records handy to the principals you specify, or – in certain times together with net web hosting – to be reachable to anyone on the public net.Google Cloud storage is an object garage service provided by Google Cloud. It provides very attractive out-of-the-field functions along Continue Reading

How to create Google Cloud Bucket using Google Cloud Shell

Reading Time: 3 minutes In this blog we will see how to create a Google Cloud Bucket using Google Cloud Shell.Also I will add some object to that bucket using cloud shell.So stay tuned till the end. What Is Object Storage? In object storage, files are simply referenc as objects and organize into buckets—logical namespaces that are able to hold one or more objects. While a bucket can have Continue Reading

app engine gcp

How to Deploy an application to App Engine in GCP

Reading Time: 3 minutes Hello Readers! In this we will see how easily we can deploy an application to App Engine in GCP. In this blog firstly we will create a simple app engine application using cloud shell local environment. Then I will deploy that application to the App Engine. So, before starting firstly we will see what is an App Engine? Basically, App Engine is a PaaS (Platform Continue Reading

Airflow on Google Cloud Composer

Reading Time: 4 minutes If you are wondering how to start working with Apache Airflow for small development or academic purposes here you will learn how to. Well deploying Airflow on GCP Compute Engine (self-managed deployment) could cost less than you think with all the advantages of using its services like BigQuery or Dataflow. Table of Content What is apache airflow cloud composer overview Google cloud composer benefit Composer Continue Reading

GCP – ‘Cloud Run’ in Seconds

Reading Time: 4 minutes As a developer, you might want to quickly deliver great cloud applications like web apps, mobile APIs, and background jobs. But choosing a cloud solution often comes with trade-offs. On the one hand, you can choose to manage your servers. But this can mean provisioning and configuring them yourself, plus worrying about scaling up and down as traffic patterns change. And you might run the Continue Reading