Binding errors in azure synapse studio when i try querying the view

Question

We have recently facing issues when trying to run the query on top of a parquet file for view or an external table.

Nothing has changed in our setup. This issue seems to come and go after a few minutes; we are able to query the view as normal, but this has been happening every day. Please provide the solution.

Started executing query at Line 40

Msg 13822, Level 16, State 1, Procedure fct_barrier, Line 2
File 'https://****.dfs.core.windows.net/test/file.parquet' cannot be opened because it does not exist or it is used by another process.

Msg 4413, Level 16, State 1, Line 540
Could not use view or function 'mdm.test' because of binding errors.

Total execution time: 00:00:00.184

or

External table 'dbo.test' is not accessible because content of directory cannot be listed.

Answer 1

@Prashanthi Kamasani - Thanks for the question and using MS Q&A platform.

It seems like you are facing issues when trying to run a query on top of a Parquet file for a view or an external table in Azure Synapse Studio. This error message indicates that the file cannot be opened because it does not exist or it is being used by another process.

This issue seems to come and go after a few minutes, which indicates that it might be a temporary issue. However, to resolve this issue, you can try the following steps:

• Check if the file exists in the specified location. If it does not exist, make sure that the file is uploaded to the correct location.
• Check if the file is being used by another process. If it is, wait for the process to complete and try again.
• Check if the external table is accessible. If it is not accessible, make sure that the directory content can be listed.

For more details, refer to the MS Q&A thread addressing similar issue.

If none of the above steps work, you can try refreshing the connection to the data source or restarting the service. If the issue persists, please provide more information about your setup and the query you are running so that we can investigate further.