Komal ParekhConverting a Structured to Semi StructuredRecently, I came across a problem statement where i needed to convert a structured data to semi-strcutured JSON format.Sep 10Sep 10
Komal ParekhWorking with Resource MonitorsA resource monitor can help control costs and avoid unexpected credit usage caused by running warehouses. A virtual warehouse consumes…Aug 16Aug 16
Komal ParekhSNOWFLAKE SUMMIT 2024 HIGHLIGHTS● Enterprise AI (Secure AI that runs completely serverless & within your account w/o moving any data out and completely governed by…Jun 19Jun 19
Komal ParekhDatawarehouse Vs DataLake Vs Data Mart Vs DeltaLakeWith modern data warehousing there has been evolution of how we would store our data and where we would store data.Dec 18, 2023Dec 18, 2023
Komal ParekhTime To Live — Snowflake and Object TaggingTime to Live (TTL) is a mechanism that allows you to automatically expire database objects. TTL is expressed as the amount of time object…Feb 2, 2023Feb 2, 2023
Komal ParekhEmail Notification — Latest Nov 2022 Feature!Email Notification has been long awaiting feature of snowflake. Currently in order to send any email notification — Success or Failure is…Dec 28, 20221Dec 28, 20221
Komal ParekhAutomating finding mismatched column in duplicate rows in snowflakeAs part of data engineering, we have a primary key defined on each table that defines grain of the data. For example in an employee table…Nov 4, 2022Nov 4, 2022
Komal ParekhSnowflake Schema DetectionIn this blog, we will be exploring schema detection feature of snowflake.Oct 4, 2022Oct 4, 2022
Komal ParekhCreating Load plans using Snowflake TasksAs part of Datawarehouse implementation, we need to define schedules to run our data pipelines at regular interval of time.Aug 26, 2022Aug 26, 2022
Komal ParekhLoading Unstructured Data Using SnowflakeSnowflake now provides capability to process unstructured data in its ecosystem. In this article we will explore how to process a PDF and…Jul 29, 2022Jul 29, 2022