PinnedJayakrishna SurampudiinTowards DevFinding duplicates in Snowflake and removing them using temporary table and swap with command.Create a table named customers and insert some data into it and we will try to check duplicates from the customers table.Apr 12Apr 12
PinnedJayakrishna SurampudiinTowards DevLoading kaggle csv dataset into Snowflake named internal stage.check below kaggle dataset link to download a sample dataset.Apr 4Apr 4
PinnedJayakrishna SurampudiReturn the latest data in Pysparkconsider the following dataframeJan 9Jan 9
PinnedJayakrishna SurampudiHandling data with multiple delimiters in Pyspark.Consider a DataFrame which reads data from a csv file and display it using show() method.Jan 6Jan 6
PinnedJayakrishna Surampudidifferent modes in Pysparkπ£π²πΏπΊπΆπππΆππ²: - This is the default mode of reading a dataframe. - If spark in unable to parse a data type due to a mismatch whileβ¦Jan 5Jan 5
Jayakrishna SurampudiinTowards DevRecovering data using Snowflake TimeTravel.Assume we already had a table of student marks like below.Jul 13Jul 13
Jayakrishna SurampudiinTowards DevRemoving duplicates using row_number() in Snowflake.1)Create a table NameTable and insert data into it.May 20May 20
Jayakrishna SurampudiFinding second highest salary in Snowflake.Finding second highest salary using max() function.May 20May 20
Jayakrishna SurampudiinTowards DevFinding months based on timestamp using months_between() method in Snowflake.we had months_diff column which we got past monthsMay 19May 19