Hi Guys, I am writing this blog to understand how we can start the PySpark, how we can execute actions/transformations on pyspark data-frames. Interesting thing is we can do it using Jupyter Notebook -a framework available inside python, we can install that using pip manager command — pip install notebook…

Benefits of Cloud: 1. Trade capital expense for variable expenses 2. Benefits from massive economy of scale 3. Increase speed and agility — react quickly as you need evolve changes. 4. Stop spending money on running and maintaining data centers 5. Go global in minutes. 6. While deploying applications on…

Hi, This is about a strategy which I planned to automate the data flow from on-prem server to snowflake data warehouse, it can work for you if you have a similar kind of environment. So, let's practice it with some sample data. 😊 First, prepare some data from the snowflake…

Hi, I am sharing an experience about loading a huge file in snowflake Datawarehouse, so my file is in CSV format the best one for snowflakes with higher upload speed. My file size was 22.8 …

SNOWPRO STUDY GUIDE OVERVIEW This is a self-learning study guide which highlights concepts that may be covered on Snowflake’s SnowPro Core Certification exams. This study guide does not guarantee certification success. …

Once your AWS Lambda function is ready to deploy, you can choose many ways to deploy it on S3, I choose azure DevOps version control here to deploy it on S3.

Zero-Copy Cloning: Snowflake cloning is a meta data-only operation, there is no physical data copied from one environment to another, clone data point out to the actual database and further CRUD operations keep separately in the new environment which do not affect the old data, it is important to note…

Hello Guys, Currently, there are two languages supported in snowflake to create stored procedure. Javascript SQL and mostly Javascript is used language, lets understand this better. Using $$ as the delimiter makes it easier to write stored procedures that contain single quotes. Please follow the below steps, you would be…