Databricks Community

seanstachff · 02-11-2025

Hi - I am using `from_json` with FAILFAST to correctly format some data using databricks SQL. However, this function can return the error "[MALFORMED_RECORD_IN_PARSING.WITHOUT_SUGGESTION] Malformed records are detected in record parsing" with the res...

seanstachff · 12-03-2024

Hello, I am trying to use from_csv in the sql warehouse, but I am getting unexpected results:As a small example I am running: WITH your_table AS ( SELECT 'a,b,c\n1,"hello, world",3.14\n2,"goodbye, world",2.71' AS csv_column ) SELECT from_csv(csv_c...

seanstachff · 12-05-2024

Yes, you are correct. That is the result I want. The above I showed is just an example however my real source table is a list of files with one column value being the entire contents of a CSV.

seanstachff · 12-04-2024

Thanks, I didn't read the docs clear enough and see that csv_data is for one row. I'm a big confused as to why it has a header then. My only issue with this is how could you handle the possibility of it having a linebreak in a string value on the csv...

Databricks Community

User Stats

User Activity

Databricks SQL Error outputting sesntive data to logs

Using FROM_CSV giving unexpected results

Re: Using FROM_CSV giving unexpected results

Re: Using FROM_CSV giving unexpected results