%sql select statement

Question

Hi Expert,

how to get %sql query using below statement and not spark.sql

example

%sql

select * from delta.dbfs://mnt/rawdatea/data/transt.csv

getting error message

Error in SQL statement: ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near

Answer 1

Dear @Shambhu Rai ,

Look at this documentation page:
https://learn.microsoft.com/en-us/azure/databricks/files/

The article provides multiple ways for interacting with files in the following locations:

• Unity Catalog volumes
• Workspace files
• Cloud object storage
• DBFS mounts and DBFS root

Kind regards,

Wilko

---

Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".