Working with JSON in SnowflakeLoading JSON data into snowflake by running copy command.Here the column type of the table where JSON data will be loaded is of VARIANT…Jun 9, 2021Jun 9, 2021
Key Factors while migrating from ‘Redshift’ to ‘Snowflake’Are you planning to migrate from ‘Redshift’ to ‘Snowflake’? In this post I will not focus on ‘WHY’ one should decide to migrate from…May 31, 2021May 31, 2021
Top 10 things to know about RedshiftRedshift has a Columnar storage.In columnar storage data is stored by columns and not by rows.May 26, 2021May 26, 2021
Make Batch Loads easy and fast with Snowflake’s SWAP CommandBatch loading of data in ETL is usually done overnight so Business can use the processed data early in the day.Often for any correction in…May 23, 2021May 23, 2021
7 simple steps for ingestion of streaming data into SnowflakeI have been working with Data Ingestion, both with near real time and batch loading. Today, I am sharing here one such method for loading…May 23, 2021May 23, 2021
My Take on Kafka vs. KinesisI spent some time working with Apache #Kafka and also did a small poc on #Kinesis. Often I am asked which one to prefer.Well it totally…May 23, 20211May 23, 20211
Monitoring of DMS Tasks on SlackI have been working with AWS Database Migration service for a long time.It gets challenging to monitor the replication tasks running in AWS…May 21, 2021May 21, 2021
Query data on S3 using AWS Athena Partitioned tablesHere are few steps to help you query raw data on S3 using AWS Athena:May 21, 2021May 21, 2021
ETL with AWS GlueAre you trying to setup ETL using AWS Glue?AWS Glue is ETL service provided by AWS.It is serverless, so you just pay for the resources used…May 21, 2021May 21, 2021
