Hi,
I created a new Azure Synapse Analytics resource and uploaded some csv files to the data lake storage created with the Synapse. I can see the files in the workspace and preview the files.
However, when I tried to create a new SQL script from the file (right click on the file), I don't see the option "Select TOP 100 rows" to open a new script for to to edit and run the query. I only see the "Bulk load" option, and when I clicked it, I got the error "Failed to execute query. Error: File 'x' cannot be opened because it does not exist or it is used by another process. The batch could not be analyzed because of compile errors." If I created a new SQL script from the landing page (New -> SQL script) and tried to query the file, I got the same error.
Is this a permission issue? Since I can list the files in the container and preview them, I assume the workspace should have access to the files in data lake.
Thanks,
Bryan

