Author: user

Snowflake

Does Snowflake support indexes which is supported by other databases ?

The answer is NO. Indexes are not utilized or supported by Snowflake. By keeping extensive metadata in each of its…

getDbt

DBT command not found after intalling DBT – How to resolve – Explained.

Once you installed dbt after going through the https://docs.getdbt.com/dbt-cli/install/overview , if still you are getting DBT command not found ,…

getDbt

DBT – Best practices that developers show follow

DBT – Best practices The article will give you the cumulative knowledge of dbt’s seasoned users on how to use…

PySpark @ Freshers.in

PySpark-How to returns the first column that is not null

pyspark.sql.functions.coalesce If you want to return the first non zero from list of column you can use coalesce function in…

PySpark @ Freshers.in

How can you convert PySpark Dataframe to JSON ?

pyspark.sql.DataFrame.toJSON There may be some situation that you need to send your dataframe to a file to a server or…

PySpark @ Freshers.in

How can I see the full column values in a Spark Dataframe ?

When we do a dataframe.show () , we can see that some of the column values got truncated. Here we…

PySpark @ Freshers.in

What is the difference between repartition() and coalesce() ?

The repartition algorithm will perform a full shuffle and creates new partitions with data that’s distributed evenly.┬áThe repartition algorithm makes…

PySpark @ Freshers.in

Converts a column containing a StructType, ArrayType or a MapType into a JSON string-PySpark(to_json)

You can convert a column containing a StructType, ArrayType or a MapType into a JSON string using to_json function. pyspark.sql.functions.to_json…

Gradle Devops @ Freshers.in

Gradle DevOps Interview Questions and Answers for Freshers and Experienced

1. What Are Benefits Of Daemon in Gradle 3.0 a. It has good UX b. It is very powerful c….

Android_iOS @ Freshers.in

How to move WhatsApp conversations from an Android to an iPhone

Please follow the steps to move WhatsApp conversations from an Android to an iPhone. Step 1: On your Android phone,…