Databricks Community

joeyslaptop

Hi. If I've posted to the wrong area, please let me know.I am using SQL to join two tables. One table has the wildcard '%' stored as text/string/varchar. I need to join the value of TableA.column1 to TableB.column1 based on the wildcard in the str...

joeyslaptop · 01-17-2024

If this isn't the right spot to post this, please move it or refer me to the right area.I recently learned about the "_metadata.file_name". It's not quite what I need.I'm creating a new table in DataBricks and want to add a USR_File_Name column cont...

joeyslaptop · 01-25-2024

Hi, Shan_Chandra.Thanks for the suggestion. The method I'm using to import my file is the Data Ingestion>Data Sources> From Local Files> Create or Modify Table.It doesn't provide a place for code or to specify column values outside of what's found i...

joeyslaptop · 01-22-2024

I have files with file names like "HT00114_DXLS_PROD_20240102_00001.txt" where the 2024xxxx is the date the file was created. I want to load the file from my hard drive to a table on my sandbox-type space on our DataBricks data lake as a SQL DB tabl...

Databricks Community

User Stats

User Activity

How do I use DataBricks SQL query to convert a field value % back into a wildcard?

How to add a column to a new table containing the original source filenames in DataBricks.

Re: How to add a column to a new table containing the original source filenames in DataBricks.

Re: How to add a column to a new table containing the original source filenames in DataBricks.