Hi @Sirilakshmi Veerapaneni ,
Welcome to Microsoft Q&A platform and thanks for posting your query here.
As I understand your issue, you are trying to create Credential for dedicated SQL pool to access the file in storage account via external tables.
You need to create database scoped credential in your dedicated SQL Pool on top of which you can create external data source , file format and finally external table to access ADLS files.
You can access Storage account files via external tables in Synapse SQL pools via the following steps:
CREATE EXTERNAL DATA SOURCE to reference an external Azure storage and specify the credential that should be used to access the storage.
CREATE EXTERNAL FILE FORMAT to describe format of CSV or Parquet files.
CREATE EXTERNAL TABLE on top of the files placed on the data source with the same file format.
In order to create Data source, you need to create database scoped credential .
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators