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 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
Jayakrishna SurampudiinTowards DevTo find the top 5 selling products at the store level in the past 30 days in Snowflake.Step 1) Create a table transactions in snowflake.May 18May 18