Databricks Community

emma_s

We’ve recently created a new Excel reader function, and I decided to have a play around with it. I’ve used an open dataset for this tutorial, so you can follow along too. Using file available here - https://www.ons.gov.uk/employmentandlabourmarket/pe...

emma_s

Note - This event is for UK & Ireland Public Service Databricks Customers only ✨ Think the Christmas sparkle ends in December? Think again. We’re bringing it *straight into January* with the **Databricks Sparklefest Hackathon** — where public servic...

emma_s

Hi, you need to put all of the keys in the ON part of the clause rather then in the where condition. This code works: MERGE INTO target_table AS target USING source_table AS source ON target.key1 = source.key1 AND target.key2 = source.key2 AND target...

emma_s

Hi, yes your assumption is correct, there is no currently no way of adding parameters to an alert. This is a commonly requested feature, but as yet is not in the roadmap. There is potential it will come in Q2/Q3 once the feature is GA. Here is an ov...

emma_s

Hi, I can't find any reference to a user system table in our docs. Instead the recommended approach is to use the API to return users, groups and service principals. You can either run this using the Workspace Client if you only have worspace admin p...

emma_s

Hi, Hi, there isn't a table which shows mappings of Users to groups, you can only see this through the groups editing. You can, however, check grants on tables to see which groups or users have been granted permission to tables. The following query ...

emma_s

I would work, but you will need to specify and manage the ranges or number of header rows manually. You could potentially read the whole sheet in and then write some code that identifies the range that is of interest and cleans it in parsing. My reco...

Databricks Community

User Stats

User Activity

Databricks Excel Reader

Sparklefest - The UK Public Sector Hackathon

Re: Strange DELTA_MULTIPLE_SOURCE_ROW_MATCHING_TARGET_ROW_IN_MERGE error

Re: Alerts V2 Parameters

Re: Need Help - System tables that contains all databricks users, service principal details !!

Re: Need Help - System tables that contains all databricks users, service principal details !!

Re: Azure Content Understanding Equivalent