question

VivekD-8464 avatar image
0 Votes"
VivekD-8464 asked SonikaAhlawat-7390 commented

Azure Synapse : Create External Table option for csv file missing

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?

54691-image.png


54701-image.png




azure-synapse-analytics
image.png (12.9 KiB)
image.png (10.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

Thanks,
Sonika

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @VivekD-8464,

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.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

Hello @VivekD-8464,

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.


1 Vote 1 ·

Hello @VivekD-8464,

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.

0 Votes 0 ·