INTRODUCTION Consider, a situation or a use case in which you are an Analysts working in a renowned airlines company and your job is to create reports and analyze the passengers of your airlines and what are their viewing habit's. To create these customer analytical reports the first and foremost requirement…

INTRODUCTION — Streaming data is widely used in various domains and has variety of applications in our day to day software and businesses. One of the major challenges that we face while handling the streaming data is regarding its Volume & Velocity. When we look at Volume it is majorly defined in…

INTRODUCTION Amazon Redshift is an enterprise wide secured, fully managed & scalable Data Warehouse solution that AWS provides AMAOZN REDSHIFT FEATUERS Columnar Data storage MPP (Massive Parallel Processing) Concurrency scaling Materialized Views Automatic Caching Data Encryption — at Rest & in-transit PRE-REQUESITES Please make sure that you have following pre-requisites full…

Introduction Salesforce provides an efficient way of managing sales, marketing and commerce data for any product or a business to provide greater insights using on integrated platform. But when this data has to be analyzed using statistical tools and Machine learning models to get trends and patterns then its becomes necessary…

Overview Amazon Redshift can use custom functions defined in AWS Lambda as part of SQL queries. You can write scalar Lambda UDFs in any programming languages supported by Lambda, such as Java, Go, PowerShell, Node.js, C#, Python, and Ruby. Lambda UDFs are defined and managed in Lambda, and you can control…

Overview Federated queries in Amazon Redshift, enables you to query and analyze data across operational databases, data warehouses, and data lakes. With the Federated Query feature, you can integrate queries from Amazon Redshift on live data in external databases. …

Overview AWS Athena workgroups can be used to separate users, teams, applications, or workloads and to set limits on amount of data each query or the entire workgroup can process, and to track their respective costs. Because workgroups act as resources, you can use resource-level identity-based policies to control access to…

Introduction The query editor v2 is a separate web-based SQL client application that you can use to author and run queries on the Amazon Redshift data warehouse. You can also visualize your results in charts and collaborate by sharing your queries with others on your team. …

AWS Lambda is a serverless, event-driven compute service that lets you run code for virtually any type of application or backend service without provisioning or managing servers. You can trigger Lambda from over 200 AWS services and software as a service (SaaS) applications, and only pay for what you use. …