Currently supported databases by Sqitch's database change management tool include Snowflake's Cloud Data Warehouse as…
Category: article
How to Grant access to the S3 bucket for the Snowflake account (example)
To grant access to an S3 bucket for a Snowflake account, you will need to create an AWS Identity and…
Different ways that you can load data into Snowflake.
There are several ways to load data into Snowflake, depending on the specific needs of the user and the nature…
PySpark:Getting approximate number of unique elements in a column of a DataFrame
pyspark.sql.functions.approx_count_distinct Pyspark’s approx_count_distinct function is a way to approximate the number of unique elements in a column of a DataFrame….
Utilize the power of Pandas library with PySpark dataframes.
pyspark.sql.functions.pandas_udf PySpark’s PandasUDFType is a type of user-defined function (UDF) that allows you to use the power of Pandas library…
Pyspark, how to format the number X to a format like ‘#,–#,–#.–’, rounded to d decimal places
pyspark.sql.functions.format_number The format_number function is used to format a number as a string. The function takes two arguments: the number…
Pyspark : Formating the arguments in printf-style and returns the result as a string column
pyspark.sql.functions.format_string ‘format_string’ is a parameter in the select method of a DataFrame in PySpark. It is used to specify the…
PySpark : Combine two or more arrays into a single array of tuple
pyspark.sql.functions.arrays_zip In PySpark, the arrays_zip function can be used to combine two or more arrays into a single array of…
PySpark : Transforming a column of arrays or maps into multiple rows : Converting rows into columns
pyspark.sql.functions.explode_outer In PySpark, the explode() function is used to transform a column of arrays or maps into multiple rows, with…
Retrieving value of a specific element in an array or map column of a DataFrame.
pyspark.sql.functions.element_at In PySpark, the element_at function is used to retrieve the value of a specific element in an array or…
In PySpark how to sort data in descending order, while putting the rows with null values at the end of the result ?
pyspark.sql.Column.desc_nulls_last In PySpark, the desc_nulls_last function is used to sort data in descending order, while putting the rows with null…