Databricks

elgeo · 03-05-2024

Hello,We have recently created a notebook in order to allow users inserting/updating values in specific tables. The logic behind the update statements is included in a separate notebook where users don't have access. However we would like to know if ...

elgeo · 02-15-2024

Dear experts,We need to create a notebook in order the users to insert/update values in a specific table. We have created one using widgets. However the code performed per action selected is visible to the users. Is there a way to have in a the dropd...

elgeo · 11-29-2023

Hello. Do you know if you can add columns at a specific position (before / after a column) by altering a delta table ?

elgeo · 10-23-2023

Hello experts,Could someone please explain what is exactly contained into the column usage in the system.billing.usage table?We ran specific queries in a cluster trying to calculate the cost and we observe that the DBUs shown in the system table are ...

elgeo · 10-18-2023

Hello experts,Do you know how we can retrieve the DBUs consumed for a specific query?Thank you

elgeo · 10-20-2023

I couldn't find a metadata table. However the workaround is to multiply the DBU of the current cluster (retrieve it either online or to be more accurate from the compute page at the right) and multiply it with the time in minutes that the query took ...

elgeo · 03-10-2023

Hello - Just an update from the latest office hours. They mentioned that default value is available for Delta tables as well starting from release 12.2 Databricks Runtime 11.3 LTS | Databricks on AWS. However, I was able to set it up only in the foll...

elgeo · 02-23-2023

Thank you @Kaniz Fatma. This is exactly what I was looking for.

elgeo · 02-23-2023

Hi @Kaniz Fatma. Thank you for your feedback. However, my question is if we can enforce a column to have exactly a number of characters, not less than a number. For example an iban needs to have exactly 34 chars, not less than 34 not more than 34.

Re: User logging in Databricks · 01-02-2023

Any update on this? Thank you

Databricks

User Stats

User Activity

Hide widgets logic

Interactive Notebook with widgets

Αdd columns delta table

System billing usage table - Usage column

Retrieve DBU per query executed

Re: Retrieve DBU per query executed

Re: Using current_timestamp as a default value in a delta table

Re: Data type length enforcement

Re: Data type length enforcement

Re: User logging in Databricks