Hi @Clover J
Thank you for reaching out to the Microsoft Q&A platform.
Based on your query, it seems like you have followed all the necessary steps to create an external table in Synapse Analytics. However, the error message you are receiving indicates that there might be an issue with the permissions.
To resolve this issue, you can try the following steps:
- Ensure that the SAS token you are using is valid and has the necessary permissions to access the container that has the parquet file. You can regenerate the SAS token and try again.
- Check if the firewall settings of the storage account are configured correctly. You might need to add the IP address of the Synapse Analytics workspace to the firewall rules.
- Verify that the database scoped credential you created has the correct identity and secret. Make sure that the secret is not expired.
- Check if the external data source you created has the correct location and credential. Make sure that the credential has the necessary permissions to access the storage account.
If none of the above steps work, you can try to run the following command to get more information about the error:
SELECT * FROM sys.external_data_sources WHERE name = 'your_external_data_source_name';
This will give you more details about the error and help you troubleshoot the issue.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.