%sql select statement

Shambhu Rai 1,406 Reputation points
2023-10-23T20:50:30.7166667+00:00

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

Azure SQL Database
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,982 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,793 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Wilko van de Velde 2,226 Reputation points
    2023-10-24T06:28:25.4866667+00:00

    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".