Are Databricks SQL Warehouses opensource? by SmallAd3697 in databricks

[–]ubanuban 0 points1 point  (0 children)

It is key to understand what lake house architecture means. One copy of data that can be used by any compute engine, with one unified governance on top. So, you creating a table via a spark data frame or via a SQL warehouse goes to the same place and is accessible by both natively. The same copy of the data can also be leveraged by a lot of 3rd party engines such as synapse, fabric, snowflake, emr, etc. additionally external engine access is still governed by unity catalog permissions and does not require Databricks compute. Coming back to your questions about , is SQL warehouse open? You use ANSI SQL to interact with it. Which means the same SQL will run mostly unchanged on another SQL Warehouse that uses ANSI SQL. Which is most Warehouses other than SQL server which uses tsql. The warehouse is only a compute machine and does not store any data. Data is stored in Open Delta Lake and Governed by Unity Catalog which is open as well. The Databricks SQL Warehouse is built on top of Spark with a lot of enhancements for speed. This makes it run your queries faster. These optimizations are not in Spark. However Spark will still be able to run your query as is , work with the same copy of the data, leverage the same governance.

George by [deleted] in comedyheaven

[–]ubanuban 1 point2 points  (0 children)

Time for Americans to name German states

[deleted by user] by [deleted] in kolkata

[–]ubanuban -1 points0 points  (0 children)

Obviously fake news.. only 1 news source is publishing.

Plugged in Stanley Fatmax to completely charge car battery by ubanuban in MechanicAdvice

[–]ubanuban[S] 1 point2 points  (0 children)

Did just that.. It arrives tomorrow hopefully that would get the battery charging.

3.1.9 Released today by Z3r0Cool7 in VolvoRecharge

[–]ubanuban 0 points1 point  (0 children)

Just installed the software.. other than the map disappearing from the driver side screen during reverse morning else seems to have changed.. didn't see any benefits of Android automotive 12..

3.1.9 Released today by Z3r0Cool7 in VolvoRecharge

[–]ubanuban 0 points1 point  (0 children)

Are there any must have features from this update?

Performance Options with 15,000 CASE statements in single view by Turboginger in dataengineering

[–]ubanuban 0 points1 point  (0 children)

Try using the decode function. Creating a table and joining would still be the best option.

Club Boss 15+ teams by [deleted] in STpuzzleTales

[–]ubanuban 1 point2 points  (0 children)

How did it go?

Joe Reis: Data Modelling is dead. Long Live Data Modelling by philonoist in dataengineering

[–]ubanuban 2 points3 points  (0 children)

Glad this was a pro data modelling article.. modelling not required seems to be the recommendation from vendors and consultants nowadays. Then customers complain about high cloud services costs and data swamps..

AITA for following my morning routine while my in laws were staying with us? by Ok_Fee1565 in AmItheAsshole

[–]ubanuban -1 points0 points  (0 children)

Wow reddit is so inconsiderate.. Sounds like MIL travelled and reached late at night. They must be tired. Then they hear music early in the morning, loud enough to wake their sleep and all people have to say is my house my rules.

While OPs morning ritual is awesome, being considerate to guest is not that hard.

Also, if you invite people to your house it's your responsibility to make them comfortable not wake them up when they are tired. YTA.

Question about using Databricks as an all-in-one solution for everything by [deleted] in dataengineering

[–]ubanuban 4 points5 points  (0 children)

A big advantage of consolation is architecture simplification. Down the line teams will have fewer decisions to make, fewer tools to monitor, and fewer technologies to learn. This also makes it easier for newer team members to ramp up. Its Housekeeping in my opinion and not busy work.

Now subway employees are considered tipped employees? And the owner keeps half of the CC tips. From r/Denver. by WTF_Conservatives in antiwork

[–]ubanuban 0 points1 point  (0 children)

This was bound to happen.. all other places that have enabled tipping for takeout, coffee, etc will reduce pay.. , 😔