IamjaswanthImplementing Dynamic Data Masking in Snowflakeprotecting sensitive information is paramount. With increasing data privacy regulations and the need to safeguard confidential information…19h ago19h ago
IamjaswanthDynamic Data Retrieval in Snowflake: Using Stored ProceduresIn this post, we’ll explore how to create and use a stored procedure to fetch employee performance data based on their department. We’ll…3d ago3d ago
IamjaswanthDynamic SQL Execution in Snowflake: Leveraging Session Variables with TO_QUERYwe will explore how to use TO_QUERY in Snowflake, demonstrate creating session variables, and execute dynamic SQL queries. Additionally, we…Sep 5Sep 5
Iamjaswanth“Exploring the Nifty Index: Monthly Returns Over the Years 🌟📊A visual journey through the ups and downs of the Nifty index, highlighting key trends and yearly performance from 2008 to 2024. How did…Sep 3Sep 3
IamjaswanthHow to Set Up Apache Airflow on AWS Managed Workflows: A Step-by-Step GuideWhen setting up an Apache Airflow environment on AWS, AWS offers Managed Workflows for Apache Airflow (MWAA). While Airflow isn’t a…Sep 2Sep 2
IamjaswanthDBT Models with Snowflake: Transforming Data with DBT Models in SnowflakeDBT (Data Build Tool) models are SQL files that define transformations on raw data within a data warehouse. These models enable analysts…Aug 20Aug 20
IamjaswanthEfficiently Transferring Data from AWS Transfer Family to S3: A Step-by-Step GuideAWS Transfer Family is a fully managed service that enables you to securely transfer files over SFTP, FTPS, and FTP directly into and out…Aug 1Aug 1
IamjaswanthStep-by-Step Guide to Configuring AWS Glue Crawlers and Querying S3 Data with AthenaIn this guide, we’ll walk through the process of setting up an AWS Glue Crawler to detect metadata from an S3 bucket, and then query the…Jun 28Jun 28
IamjaswanthEnsuring Data Quality with Custom dbt Macros in Snowflake!Macros in dbt are a powerful way to DRY up your SQL and make your data transformations more efficient and reusable. Check out this simple…Jun 10Jun 10
IamjaswanthImplementing Slowly Changing Dimension Type 2 (SCD Type 2) in Snowflake Using DBTSlowly Changing Dimensions (SCD) are an essential concept in data warehousing, allowing businesses to track historical changes in their…Feb 261Feb 261