PinnedSanket PrabhuDBT env setup with SnowflakeIn this story we will cover dbt setup on windows/Unix environment. Prior setup the user must need basic understanding of ETL, dbt, and any…Mar 9, 20221Mar 9, 20221
Sanket PrabhuinTowards DevOptimizing Snowpark Procedures: A Guide to Migrating from Pandas to SnowparkWhen migrating from a Pandas-based procedure to Snowpark in Snowflake, it’s essential to focus on optimizing the performance of your…Aug 15Aug 15
Sanket PrabhuSnowflake roles recommendationsThe below topic will give you a basic idea about snowflake roles assignment for newly onboarding persons in a team and also for the overall…May 23May 23
Sanket PrabhuUnity catalog in Databricks: A Beginner’s GuideThis document explains the basic introduction to the identity and access management module called Unity Catalog in Databricks. Unity…Feb 22Feb 22
Sanket PrabhuWrite a SQL query to check fuzzy matching between two columns in AWS RedshiftI came across a scenario where I had to match data from two columns of different two tables and get the closest matched record. In short, I…Nov 27, 2023Nov 27, 2023
Sanket PrabhuAn Introduction to dbt and Essential Commands for SnowflakeIntroduction: In the world of data engineering and analytics, dbt (Data Build Tool) has gained popularity as a powerful and flexible…Jun 18, 2023Jun 18, 2023
Sanket PrabhuMastering Unix: 30 Important Commands with ExamplesUnix, a powerful operating system, is widely used in the world of computing. Understanding and mastering the fundamental Unix commands is…Jun 18, 2023Jun 18, 2023
Sanket PrabhuPerformance tuning in SnowflakeThis article describes multiple ways of tuning and optimizing the overall performance of the snowflake Data warehouse.Mar 23, 2022Mar 23, 2022
Sanket PrabhuPerform ELT using PythonThis is the documentation of a use case where you can Extract, Load, and Transform data from the DB2 server to Snowflake using a single…Mar 14, 2022Mar 14, 2022