Iamjaswanth🚀 Exploring Date Columns in PySpark: Date by Year, Month, and Day 🚀Today, I was working with a dataset in PySpark and wanted to dive deeper into date analysis. One of the key transformations I performed was…Oct 7Oct 7
IamjaswanthStop Orphaned Queries in Snowflake with ABORT_DETACHED_QUERY Parameter 🚀Have you ever closed your Snowflake session only to realize that some long-running queries are still draining resources in the background…Oct 7Oct 7
Iamjaswanth🚀 Importing Data into HDFS using Apache Sqoop 🚀When dealing with large datasets stored in relational databases, efficiently moving that data to Hadoop’s HDFS is a critical task for…Sep 29Sep 29
IamjaswanthAn Introduction to Apache Sqoop: Bridging the Gap Between Relational Databases and Hadoop1. Introduction to Sqoop Apache Sqoop is a tool designed for efficiently transferring bulk data between Hadoop and relational databases…Sep 29Sep 29
IamjaswanthIntroducing the SEARCH() Function in SnowflakeThe SEARCH() function is a powerful new addition to Snowflake that allows users to search for specific substrings within a text. This is…Sep 23Sep 23
IamjaswanthData Quality in Snowflake Using SodaData quality testing is essential to ensure that the data in your Snowflake environment is accurate, reliable, and suitable for analysis…Sep 18Sep 18
IamjaswanthSnowflake External Tables for Data Lake IntegrationSnowflake’s external tables allow you to directly query data stored in external locations, such as Amazon S3, Azure Blob Storage, or Google…Sep 17Sep 17
IamjaswanthSnowflake ASOF Join: Seamlessly Merging Time-Sensitive Financial Datawe’ll explore how Snowflake’s ASOF join works, using a scenario that involves two tables: trade and quotes. These tables hold transaction…Sep 16Sep 16
IamjaswanthAdvanced Data Governance in Snowflake: Beyond Masking and Row Access PoliciesIn the evolving landscape of data governance, traditional measures such as masking policies and row access policies are indispensable tools…Sep 13Sep 13
IamjaswanthinDev GeniusImplementing Dynamic Data Masking in Snowflakeprotecting sensitive information is paramount. With increasing data privacy regulations and the need to safeguard confidential information…Sep 12Sep 12