Peggie Mishra – Medium

Peggie Mishra

she/her

Pinned

Understanding SQL Window Functions

Window functions in SQL provide a window of opportunity for data engineers to minimize effort and time by quickly wiring SQL queries to…

Jan 6, 2021

Understanding SQL Window Functions

Jan 6, 2021

Snowflake SHOW Commands to Boost Productivity

Snowflake’s SHOW command allows users to list objects of a specified type. One of its key advantages is that it does not consume credits…

3d ago

3d ago

ACCOUNT_USAGE Views In Snowflake

The ACCOUNT_USAGE schema in Snowflake provides comprehensive metadata at the account level. It contains detailed information about all…

5d ago

ACCOUNT_USAGE Views In Snowflake

5d ago

A Comprehensive Guide to Information_Schema Metadata in Snowflake

Hello Readers, Greetings !!In this article, we will dive into one of the most important schemas in Snowflake — the Information_Schema.

Mar 24

A Comprehensive Guide to Information_Schema Metadata in Snowflake

Mar 24

Snowflake Join Results Analysis (AI Gone Wrong)

I conducted a research on join result on multiple platforms like Databases, AI (Chatgpt /Gemini/ Perplexity etc) and it was surprising to…

Mar 20

Snowflake Join Results Analysis (AI Gone Wrong)

Mar 20

Time Travel & Cloning in Snowflake

Time Travel & Cloning are two game-changing features that have put Snowflake ahead in the cloud market. We’ve all had those moments in our…

Mar 18

Time Travel & Cloning in Snowflake

Mar 18

Delete Duplicates in a Table using Snowflake

Duplicate data refers to multiple records in a dataset that have the same values in specific fields, such as names, IDs, or other key…

Feb 19

Delete Duplicates in a Table using Snowflake

Feb 19

MOM Analysis Various SQL Methods

Month over month (MoM) is a financial metric used to compare the performance of a particular variable or indicator between two consecutive…

Feb 11

MOM Analysis Various SQL Methods

Feb 11

CTE and Recursive CTE in Snowflake

A Common Table Expression (CTE) is a temporary, named result set that you can use within a query. Defined using the WITH clause, a CTE acts…

Feb 10

CTE and Recursive CTE in Snowflake

Feb 10

AWS CLF-C02(Cloud Practitioner) Summary & Steps to Pass

AWS CLF-C02 is foundational certification offered by AWS which evaluates the fundamental understanding of oneself on cloud computing and…

Jan 28

Jan 28

Peggie Mishra

Peggie Mishra

she/her

Storytelling at the crossroads of data, cloud, and modern life—unpacking the tech that shapes how we live, work, and connect.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Rules
Terms
Text to speech