Databricks Community

abueno · 08-04-2025

Python 3.10.12 I am trying to get these filter results: example:If "column1" = '2024' and column2 in ('DE','SC') then 'value1" else 'value2'If "column1" = "2023" and column2 in ('DE,'SC')then "value3 else "value4"if the row/record does not fit the cr...

abueno · 10-11-2024

I am querying a table from the Databricks Catalog which I have to filter several columns with the same criteria. below is what I have created so far. I have 10 columns that I have filter with a set of criteria from (dx_list1) and another 10 that I ...

abueno · 09-09-2024

I am trying to exclude rows with a specific variable when querying using pyspark but the filter is not working. Similar to the "Not like" function in SQL. e.g. not like '%var4%'. The part of the code that is not working is: (col('col4').rlike('var...

abueno · 08-02-2024

Hi,Is there a "Find and replace" option to edit SQL code? I am not referring to the "replace" function but something similar to Control + shift + F in Snowflake or Control + F in MS Excel.

abueno · 08-19-2025

I am having the same issue but on Python 3.10.12.I need to be able to have another user have "manage" access to a table in the unity catalog. We both have write access to the schema.

abueno · 10-30-2024

I use "find" one step at a time instead of "Replace all". Helps if too many changes are not required.

abueno · 09-10-2024

Worked perfectly Thank you.

abueno · 08-02-2024

This worked for me. using "TABLE" was restricted for me. CREATE or replace TEMPORARY VIEW details AS ...

Databricks Community

User Stats

User Activity

Python If Statement with multiple "and" conditions, if not default column value

Databricks Pyspark filter several columns with similar criteria

exclude (not like) filter using pyspark

Find and replace

Re: How to allow Table deletion without requiring ownership on table? Problem Description In DBR 6 (

Re: Find and replace

Re: exclude (not like) filter using pyspark

Re: How to create temporary table in databricks