Azure Synapse : Create External Table option for csv file missing

Question

Azure Synapse : Create External Table option for csv file missing

Vivek Devalkar 122

In Azure Synapse, the Create External Table option shows up for parquet files which is very convenient but I don't see that option for csv files. Is that by design?

If yes, is there an easy way to setup an external table and have the script generated for you for a csv file?

Sonika Ahlawat 1 Reputation point Microsoft Employee

2021-09-23T06:13:51.693+00:00

Hi @Anonymous , I am also facing the same issue. Can you please help me on this?

Thanks,
Sonika

Accepted answer

0 additional answers

Your answer

Sonika Ahlawat 1 Reputation point Microsoft Employee

2021-09-23T06:13:51.693+00:00

Hi @Anonymous , I am also facing the same issue. Can you please help me on this?

Thanks,
Sonika

Answer 1

PRADEEPCHEEKATLA 90,641 Moderator

Hello @Anonymous ,

Creates an external file format object that defines external data stored in Azure Blob Storage or Azure Data Lake Storage. Creating an external file format is a prerequisite for creating an external table.

The following file formats are supported for CREATE EXTERNAL FILE FORMAT:

Delimited Text
Hive RCFile - Does not apply to Azure Synapse Analytics.
Hive ORC
Parquet
JSON - Applies to Azure SQL Edge only.

For more details, refer - CREATE EXTERNAL FILE FORMAT.

Hope this helps. Do let us know if you any further queries.

------------

Please accept an answer if correct. 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.

Vivek Devalkar 122 Reputation points

2021-01-08T15:53:50.173+00:00

Right, I understand that part. My question was more around the fact that with parquet we have the convenience factor in Synapse Studio of just being able to right-click on a file or folder and create an external table but the same doesn't appear to be there for csv (delimitedtext) files.

It would be nice to have an interface similar to the regular SQL Server Import flat file functionality where you can pick a file, it detects the columns and column names, gives you the option to change any column formats and then finally creates the external table.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-01-12T09:32:22.247+00:00

Hello @Anonymous ,

I would suggest you to provide feedback on the same:

https://feedback.azure.com/forums/307516-azure-synapse-analytics

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-01-18T08:54:15.567+00:00

Hello @Anonymous ,

Just checking in to see if the above answer helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.

Share via

Azure Synapse : Create External Table option for csv file missing

0 additional answers

Your answer