u/hubert-dudek

How to organize your notebook tabs?

It was a real pain, but now, with a few tricks, you can manage them better.

First, in Workspace files, next to the DABs folder or git repo, there is a small shortcut to show only tabs from that DABs folder or git repo. Alternatively, you can also use the switcher in Home next to Notebook.

If you need to organize your tabs differently, there is new functionality: spaces, which let you group them however you like.

more news https://medium.com/databrickscommunity/databricks-news-serverless-genie-code-ltap-lakeflow-61853d8e422a

u/hubert-dudek — 1 month ago

Bye Bye Fivetran

I went to the Ingestion section and saw that Fivetran is no longer there. It was always there for many years. Also, at the same time, a few new Lakeflow connectors were added.

u/hubert-dudek — 1 month ago

UI to DABs sync

When working from the web experience in development mode with source-linked deployment set to true (the default for development mode), you can edit jobs and pipelines in the UI, and changes are automatically propagated to your YML files. So it is like the best of two worlds: ow-code and IaC. Please remember to review any changes in Git, especially non-UI elements such as variables or mutators.

Whole talk with audio https://www.databricks.com/dataaisummit/session/dabs-do-pro-all-best-tips-and-tricks

u/hubert-dudek — 2 months ago

Serverless in Compute Section

It is great to see serverless in the compute section. Especially because I proposed it some time ago and lobbied for it during advisory meetings. Now we can set permissions for serverless compute. More options will come. I can say that it is my favorite recent improvement.

u/hubert-dudek — 2 months ago

Migrate PowerBI to databricks

Now we can drop the .pbit file to Genie Code and ask for migrating to databricks dashboard. I tested in direct query mode, and everything was migrated; I just had to be patient, as the whole process took quite a long time. The process created metrics views for tables used in Power BI, and now I understand why the dashboard relationship option was added. I presented how easy it is to migrate in my last video.

https://www.youtube.com/watch?v=-e3tkcg21zw

u/hubert-dudek — 2 months ago

Object metadata

Thanks to the new column_object_metadata we have access to storage-level information such as MIME type, ETag, and other metadata. That functionality is for external volumes, as in some use cases that data was needed for ingestion. Just remember that it is row-level data, so if you have a parquet file, it will be returned for every row.

https://medium.com/databrickscommunity/databricks-news-dabs-indexes-ltap-genie-last-update-25-july-ffac8533774f

u/hubert-dudek — 2 months ago

Secrets in UC

Now we can store secrets in Unity Catalog and use a 3-level namespace convention. Those secrets are no longer at the workspace level, as the old ones were, but at the catalog level. The biggest advantage is ease of managing permissions. There is READ SECRET, but also REFERENCE SECRET for scenarios when it can be used by other databricks services like Lakeflow Connections and not by programmatic access. Reading secrets in a notebook is still done by dbutils secrets get.

More news https://medium.com/databrickscommunity/databricks-news-dabs-indexes-ltap-genie-last-update-25-july-ffac8533774f

u/hubert-dudek — 2 months ago