Snowflake Zero-Copy Cloning: Accelerate the performance of cloning process.In the real world scenario, where the ETL/ELT production database is getting synchronized from source at an interval of 15 mins & we need…May 11May 11
Published inDev GeniusSnowflake Performance Tuning: Efficiently Query External Stage(AWS S3) Data using Partitioned…In this Cloud Era, most of the company is storing the raw data in the Data Lake captured from the multiple sources. Then this data can be…Aug 7, 2023Aug 7, 2023
Data Pipeline — Replicate data from MySQL to Snowflake with AWS Kinesis, Binlog Streamer Python…In this post we will see how to replicate the data automatically from MySQL (OLTP) database to Snowflake (OLAP) Cloud Data-Warehouse…Jul 26, 2023Jul 26, 2023
Snowflake — Replicate CDC log files (JSON Format) from Data Lake (AWS S3) to Snowflake Tables.Now a days many companies are moving their Data Warehousing & Business Intelligence(BI) solution into the cloud computing-based…Jul 26, 2023Jul 26, 2023
Published inPython’s GurusRead File Data from S3 using Python AWS LambdaIn this post we will see how to automatically trigger the AWS Lambda function which will read the files uploaded into S3 bucket and display…Jul 9, 20234Jul 9, 20234
Snowflake & AWS Secure Integration Framework via Integration ObjectsSnowflake, as we all know is a data warehouse built for the cloud. It allows the users to read/write the data from/to cloud storage. So it…Jul 9, 2023Jul 9, 2023