Databricks

Rishabh264 · 03-11-2023

Hey there! I've noticed that many people seem to be confused about the differences between databases, data warehouses, and data lakes. It's understandable, as these terms can be easily misunderstood or used interchangeablyHere is the summary for all ...

Rishabh264 · 03-09-2023

"Hey everyone, it seems like there's some confusion about enhanced autoscaling in Databricks lately. If you're feeling lost or unsure about how it works, don't worry - you're not"Enhanced autoscaling is a feature in Databricks that enables dynamic sc...

Rishabh264 · 12-27-2022

PrivilegesSELECT: gives read access to an object.CREATE: gives ability to create an object (for example, a table in a schema).MODIFY: gives ability to add, delete, and modify data to or from an object.USAGE: does not give any abilities, but is an add...

Rishabh264 · 12-26-2022

To connect Delta Lake with Microsoft Excel, you can use the Microsoft Power Query for Excel add-in. Power Query is a data connection tool that allows you to connect to various data sources, including Delta Lake. Here's how to do it:Install the Micros...

Rishabh264 · 12-22-2022

woahhh #Excel plug in for #DeltaSharing.Now I can import delta tables directly into my spreadsheet using Delta Sharing.It puts the power of #DeltaLake into the hands of millions of business users.What does this mean?Imagine a data provider delivering...

Rishabh264 · 05-01-2023

yes I am answering too 

Rishabh264 · 05-01-2023

Delta Lake is an open-source storage layer that is designed to bring reliability to data lakes. It is built on top of Apache Spark and provides features such as ACID transactions, schema enforcement, and time travel. Delta Lake is essentially a stora...

Rishabh264 · 05-01-2023

hey ,can you try you sql query with this methodselect * from (your sql query )

Rishabh264 · 05-01-2023

you are loading the data in your delta live tables , there is the concept of full refresh and and refresh , if you do the full refresh it will truncate the previous data and only give you the schema , so maybe in that case you have to do the refresh ...

Rishabh264 · 05-01-2023

Top keyword is not supported so in place of that you can do one thing order your data in desc and then use the limit 1 in last it will give only the max record so you can modify your query according to that

Databricks

User Stats

User Activity

Hey there! I've noticed that many people seem to be confused about the differences between databases, data warehouses, and data lakes. It's un...

"Hey everyone, it seems like there's some confusion about enhanced autoscaling in Databricks lately. If you're feeling lost or unsure abo...

PrivilegesSELECT: gives read access to an object.CREATE: gives ability to create an object (for example, a table in a schema).MODIFY: gives ability to...

To connect Delta Lake with Microsoft Excel, you can use the Microsoft Power Query for Excel add-in. Power Query is a data connection tool that allows ...

www.linkedin.com

Re: &#xd83d;&#xde0e; One hack to get more raffle entries in the ongoing contest and win big&#xd83d;&#xdc51; Answer as many un-answered questions as possible to get 1 r...

Re: Deltalkake vs Delta table

Re: Display Command Not showing the Result, Rather giving the Dataframe Schema

Re: loading incremental data

Re: Trying to build subquery in Databricks notebook, similar to SQL in a data frame with the Top(1)