%sql select statement

Question

%sql select statement

Shambhu Rai 1,411

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

Shambhu Rai 1,411 Reputation points

2023-10-24T08:31:35.73+00:00

The below mentioned link gives info about spark SQL not %sql
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-10-24T15:27:48.19+00:00

@Shambhu Rai could you please provide the complete SQL query that you are trying to run?

Regards

Geetha

Shambhu Rai 1,411

This is the question wants to run from blob storage without spark. SQL select * from delta.`dbfs://mnt/rawdatea/data/transt.csv  `

1 answer

Your answer

Shambhu Rai 1,411 Reputation points

2023-10-24T08:31:35.73+00:00

The below mentioned link gives info about spark SQL not %sql
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator

2023-10-24T15:27:48.19+00:00

@Shambhu Rai could you please provide the complete SQL query that you are trying to run?

Regards

Geetha
Shambhu Rai 1,411 Reputation points

2023-10-24T15:36:14.4+00:00

This is the question wants to run from blob storage without spark. SQL select * from delta.`dbfs://mnt/rawdatea/data/transt.csv `

Answer 1

Wilko van de Velde 2,241

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

Shambhu Rai 1,411 Reputation points

2023-10-25T08:48:07.7666667+00:00

suggestion please
Shambhu Rai 1,411 Reputation points

2023-10-26T10:50:35.4766667+00:00

suggestion pls
Shambhu Rai 1,411 Reputation points

2023-10-26T11:38:17.3566667+00:00

suggestion pls
Viorel 126.9K Reputation points

2023-10-26T14:01:22.1933333+00:00

Are you still receiving the truncated error messages?

Maybe you should use csv instead of delta.
Shambhu Rai 1,411 Reputation points

2023-10-27T05:13:31.4366667+00:00

Yes This is the question wants to run from blob storage without spark. SQL select * from delta.dbfs://mnt/rawdatea/data/transt.csv

Share via

%sql select statement

1 answer

Your answer