ruchi khanujaWorking 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…1 min read·Jun 9, 2021----
ruchi khanujaKey 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…3 min read·May 31, 2021----
ruchi khanujaTop 10 things to know about RedshiftRedshift has a Columnar storage.In columnar storage data is stored by columns and not by rows.2 min read·May 26, 2021----
ruchi khanujaMake 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…2 min read·May 23, 2021----
ruchi khanuja7 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…2 min read·May 23, 2021----
ruchi khanujaMy 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…2 min read·May 23, 2021--1--1
ruchi khanujaMonitoring 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…2 min read·May 21, 2021----
ruchi khanujaQuery data on S3 using AWS Athena Partitioned tablesHere are few steps to help you query raw data on S3 using AWS Athena:2 min read·May 21, 2021----
ruchi khanujaETL 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…2 min read·May 21, 2021----