BigQuery - SQL Joins (Photo by Resource Database on Unsplash) SQL joins are used to combine columns from multiple tables to get desired result set. In a typical Relational model we use normalized tables, each table represents an entity (example:...
How to Choose a Data Serialization/Encoding Format? A Practical Guide for Engineers
September 05, 2023 / by Rathish
Data Encoding & Decoding. Image Source: Unsplash In the world of software, we often work with different types of data like lists, tables, and more. These data structures are designed to be fast and efficient when our computer programs use them....
Unlock Advanced Data Visualization: The Complete Guide to Installing and Using Apache Superset on Linux
July 10, 2023 / by Rathish
Data Visualization - Apache Superset Guide. Image Source: Unsplash Note: This article provides a comprehensive guide on deploying and using Apache Superset on a Linux server. It covers the installation and configuration process, as well...
GCP Cloud Pub/Sub Replay: Seeking to timestamp & Seeking to snapshots
March 09, 2023 / by Rathish
Google Cloud Pub/Sub Replay (Pixabay) Let's assume, you have data pipeline deployed on Google Cloud Platform, events are published to Cloud Pub/Sub topic from publisher client, and subscribed by a data processing application, which reads data from...
[Solved] Access is denied - Check credentials and try again - Microsoft Graph - Calendar API
March 02, 2023 / by Rathish
Microsoft Graph (Source: microsoft.com)When sending API request to Microsoft Graph API, it responds with access denied error. You might have followed the documentation and added the correct permission and granted admin consent for the same, but it still...
Streaming Analytics in Google Cloud Platform (GCP) - Building Data Pipeline with Apache Beam
January 18, 2023 / by Rathish
Building Apache Beam Data Pipeline (Source: Pixabay) In introduction article of this series Streaming Analytics in Google Cloud Platform (GCP) - Introduction, we have seen the basics of streaming analytics, its importance and example uses cases,...
Streaming Analytics in Google Cloud Platform (GCP) - Setting Up The Environment
January 13, 2023 / by Rathish
Streaming Analytics in GCP (Source: Pixabay) Hello everyone, in the previous article Streaming Analytics in Google Cloud Platform - Introduction, we have covered what is streaming analytics, what services we are going to use and a quick introduction...
Streaming Analytics in Google Cloud Platform (GCP) - Introduction
January 10, 2023 / by Rathish
Streaming Analytics in Google Cloud Platform (image source - pixabay) From data-to-decision in real-time Welcome to our new series on building a streaming analytics system in the Google Cloud Platform!. Let's begin with a quick introduction....
Installing and configuring Docker Engine and Docker Compose on CentOS
June 03, 2021 / by Rathish
Installing & Configuring Docker Engine & Docker-compose on CentOS. Source: pixabay I have written this post as a quick reference guide for installing and configuring Docker Engine and Docker compose on CentOS servers. Knowing the basics...
Real-time Monitoring and Log Streaming in Google Cloud Platform (GCP)
May 19, 2021 / by Rathish
Monitoring Dashboard with charts - credit pixabay Getting insights into performance, availability and health status of infrastructure and application is very critical for building and managing reliable systems. When we are dealing with clusters...
Understanding MySQL Architecture
May 18, 2021 / by Rathish
The architecture of the world’s
most popular open source database system is very important for the Information
Technology people. There are many reasons for MySQL’s popularity around the
world, but one of the main reasons is its architecture, while...
Face Recognition - Computing Euclidean distance in PostgreSQL
May 17, 2021 / by Rathish
In this article, we are going to discuss about implementing Euclidean distance in PostgreSQL database. Before getting into actual implementation, let me give you a quick background to understand the need for writing this article. I have been working...
Subscribe to:
Posts (Atom)