DBFS stands for Databricks File System. It provides a place to put your data in databricks. It is a distributed file system mounted into Azure
Month: June 2020
Parquet File Format
When it comes to storing data in files, CSV has been the most common format so far or may be delimited-file format, in a general
How to Mount Azure Blob Storage Container to Azure Databricks File System
In the previous post How to Configure Azure KeyVault in Azure Databricks, we saw how your Azure Databrick’s workspace could be linked to an Azure
How to Configure Azure KeyVault in Azure Databricks
Below are the things you would need to keep handy while configuring the Azure keyvault in Azure Databricks – Azure Databricks Host: URL in the
How to Check Python Version Installed on the Machine
Probably, the smallest post 🙂 Run the following command from command line prompt
Count(), CountA(), CountRows() and CountX() Functions
Both Count() and CountA() functions counts non-blank values but works with different data types. Count() = works with Numbers, Dates and String data types only
Calendar vs. CalendarAuto
Calendar() and CalendarAuto(), both functions help you to create a base table for date dimension. They give you a contiguous set of dates which is
Import Data vs. DirectQuery vs. Live Connection
Import Data Imports whole dataset into Memory. This memory will be the memory of machine hosting your Power BI report. With the span of time
Eager and Lazy Execution
Eager execution means instant executions as soon as the thread assigned to statement gets its turn and Lazy execution means, actual execution is delayed until
Azure Analysis Services Pricing Model
Azure Analysis Services offers three tiers – Developer, Basic and Standard. Developer Tier is like developer edition of SQL Server Analysis Services i.e. includes every
An Introduction to DAX
DAX stands for Data Analytical Expressions. This is a language in itself that can be leveraged to do all analytical calculations, be it regular aggregations
Azure Blob Storage vs. Azure Data Lake Store
I have been asked this question many times by my colleagues that why can’t Blob Storage and Data Lake Store be used interchangeably when they
Power BI Pricing Model
There always have been some confusion around what all different Power BI licensing options means. In this post, we will try to clear those doubts.
Introduction to ARM Templates
One of my friends has been kind enough and allowed me to share the presentation about a training that he delivered to one of his
Azure BLOB Storage Access on Azure SQL Database
Almost every data project would fall into the need of accessing files from some storage location. On premise servers used to access such files from