Anaytics, Big Data, Cloud

Improving query performance in Snowflake and its related costs

In the previous blog we understood how to Optimally use Snowflake Warehouse and Tables. So let’s continue the blog series, where we will now focus on improving the performance in Snowflake and its associated costs. As we know, Snowflake tables are micro-partitioned, which significantly improves query performance. However, over time, you may experience slowness in […]

May 15, 2023

Cloud Managed Services

Connecting AWS API Gateway from Non AWS Environment using a private communication channel

 What is API Gateway An API gateway is an API management tool between a client and a collection of backend services. An API gateway acts as a reverse proxy to accept all application programming interface (API) calls, aggregate the services required to fulfill them, and return the appropriate result. Problem Statement How to access a […]

April 28, 2023

AEM, Cloud Managed Services

AEM Replication queue monitoring using AWS CloudWatch

This post will explain the approach to monitor the Replication Queues of Adobe Experience Manager (AEM) using AWS CloudWatch logs. Issue: The AEM content replication appears to be blocked. Editors can create content, but the activated pages on the CQ5 publish instance are not updated. Replication issues will occur with the following scenarios: The publisher […]

April 21, 2023

Cloud Managed Services

Connect AWS API Gateway from another AWS account on a private communication channel

What is API and API Gateway Amazon API Gateway is a service that you can use to create application programming interfaces. Those are essentially the front door to your business logic or your applications on AWS. With the rapid increase in the use of mobile devices and the rise of the Internet of Things (IoT), […]

April 13, 2023

Anaytics, Big Data, Cloud

Optimal use from Snowflake Warehouse and Tables

In the previous blog, we discussed the Best practices to be followed while Data loading into Snowflake from Stages. Continuing the snowflake blog series lets us understand how to use Snowflake Warehouse and Tables optimally. Snowflakes Virtual Warehouses Virtual Warehouses is one of the critical components in Snowflake architecture and deciding the correct configurations for […]

March 30, 2023

Anaytics, Big Data, Cloud

Best practices and hacks for Data Loading in Snowflake from Stages

Continuing our Snowflake blog series, after learning about setting up a  Snowflake account using System-defined Roles, we will explore the best practices for loading data from a file into Snowflake. Let’s begin.. Snowflake supports file-based data ingestion through Internal and External stages.  However, there are various factors to consider when performing data ingestion, including the […]

March 16, 2023

AEM, Cloud Managed Services

Cloud Manager Blue-Green Deployment model in AEM-Adobe Managed Service (AMS)

Adobe Cloud Manager for Adobe Experience Manager (AEM) is a cloud service that allows customers to build, test and deploy Adobe Experience Manager applications hosted by Adobe Managed Services. It enables organizations to self-manage Adobe Experience Manager environments in the cloud, including both AMS and AEMaaCS. AMS introduced the Blue-Green deployment model in Cloud Manager. […]

March 16, 2023

Anaytics, Big Data, Cloud

Snowflake Account setup using System defined roles

This is the first blog in a series that will focus on Snowflake, where we’ll cover best practices for using Snowflake, explore various Snowflake functionalities, discuss how to maximize the benefits of Snowflake, and address the challenges that come with its implementation or migration. In this blog, we’ll start by discussing setting up a Snowflake […]

February 16, 2023

AWS, Cloud, Cloud Managed Services

Becoming an Agile MSP with the ‘Swift Agile Managed Services Framework’

Introduction The role of a backstage team is as important as the actors on the main stage to make a play successful. Similarly, all successful products have complex managed service operations behind the scenes working tirelessly round the clock for their clients. In an always-on ecosystem with rapidly changing customer expectations, Managed Services teams are […]

May 18, 2021