Data Tips and Solutions
In this tutorial, we are going to work on Databricks community edition and convert a dataframe into a table using Apache spark. We are going to use a dataset that is stored in Databricks Community. If you want more information about the datasets on databricks … “How to Convert a Dataframe into a Table in Apache Spark”
Read More In this tutorial, we are going to work on Databricks community edition and read a csv file using Spark. For going through the tutorial, we are going to upload a csv file from the following dataset. https://www.ecdc.europa.eu/en/publications-data/data-daily-new-cases-covid-19-eueea-country For completing the task, please follow the next … “How to read Csv files in Spark”
Read More
There are certain cases where you need to get the the name of the week number or name. On Sql Server we have some functions that can help us. You can check the following functions that can help with this task. Datename This function returns … “How to get day of week in Sql Server”
Read More
In this tutorial, I am going to zip files in azure data factory. For going through the tutorial, we are going to create some files and move them into a blob storage. For completing the task, please follow the next steps. Steps to zip files … “How to zip files in azure data factory”
Read More A typical sql server update consist in updating a set of data filtered by the where clause but sometimes we only need to update the top N records without affecting the others. Dataset We are going to use ‘Sales.Customers’ table from WideWorldImporters database. Next, we … “How to Update top N records in Sql Server”
Read More