The complete list of Table Functions in Snowflake are as follows. Table functions are functions…
Category: article
How to encrypt VARCHAR or BINARY in Snowflake ? What are the Encryption Functions in Snowflake ?
In Snowflake Encryption functions encrypt or decrypt VARCHAR or BINARY values. ENCRYPT : This function will Encrypts a VARCHAR or…
What are the different Python List Methods?
In Python Lists are used to store multiple items in a single variable. There are multiple built-in methods that you can use…
What are the Unix Specific Services in Python ?
The following are the unix specific services in Python posix : The most common POSIX system calls (This module provides…
What is Snowflake Merge Command ? How to use it ?
The Snowflake Merge command will allows you to perform merge operations between two tables. The Merge operation includes Insert, Delete,…
What are the Data Processing Operators in Snowflake ?
Filter : Represents an operation that filters the records. Attributes: Filter condition – the condition used to perform filtering. Join…
What are the features in Snowflake Query History page?
You can access the snowflake query history page from Navigation=>Compute=>Query History. Users can access the Query History page from the…
What are the Query Operators supported by Snowflake
Snowflake supports most of the standard operators defined in SQL:1999. Arithmetic Operators + , – , * , / ,…
PySpark how to get rows having nulls for a column or columns without nulls or count of Non null
pyspark.sql.Column.isNotNull isNotNull() : True if the current expression is NOT null. isNull() : True if the current expression is null. With…
PySpark – groupby with aggregation (count, sum, mean, min, max)
pyspark.sql.DataFrame.groupBy PySpark groupby functions groups the DataFrame using the specified columns to run aggregation ( count,sum,mean, min, max) on them….
PySpark filter : How to filter data in Pyspark – Multiple options explained.
pyspark.sql.DataFrame.filter PySpark filter function is used to filter the data in a Spark Data Frame, in short used to cleansing…