Databricks Community

Harsha777 · 09-02-2024

Hi Team,I have a query with below construct in my projectSELECT count(*) FROM `catalog`.`schema`.`t_table`WHERE _col_check IN (SELECT DISTINCT _col_check FROM `catalog`.`schema`.`t_check_table`)Actually, there is no column "_col_check" in the sub-que...

Harsha777 · 08-26-2024

Hi,I have a string column containing a number in EU format, has comma instead of dot, e.g. 10,35I need to convert this string into a proper decimal data type as part data transformation into the target table.I could do it as below by replacing the ",...

Harsha777 · 09-03-2024

thanks @filipniziol for sharing the information, that helps!!Just curious to know if it is the databricks sql behavior or in general sql behavior with all databases?

Harsha777 · 07-10-2024

Hi,It would be a good feature to pass parameters at task level. We have scenarios where we would like to create a job with multiple tasks (notebook/dbt) and pass parameters at task level.

Harsha777 · 07-10-2024

Hi,Any update on this feature?With the info that is currently available, we cannot track the user who initiated the job run. The job run shows whether its scheduled or manual run but doesn't provide info on the user who triggered the manual run. "RUN...

Databricks Community

User Stats

User Activity

Sub-Query behavior in sql statements

Casting a String (containing number in EU format) to a Decimal

Re: Sub-Query behavior in sql statements

Re: Jobs API "run now" - How to set task wise parameters

Re: How to know, who started a job run?