microsoft azure

Question

Dear Azure Support Team,

I am reaching out to request assistance with an issue I am encountering in Azure Synapse Analytics. When attempting to create a new external table using a CSV file, the import wizard is failing to detect the schema and is not allowing me to manually specify file format settings or adjust the schema.

The error message I receive is "Failed to detect schema" and it occurs immediately after specifying the CSV file path, preventing any further action on my part. Here are some specifics:

1. The CSV file path is correct.
2. The issue arises before I have the chance to choose a delimiter or any other format settings.
3. I have confirmed that the encoding of the CSV file is UTF-8.
4. Unfortunately, I cannot provide the CSV or a screenshot through this message, but I would be happy to supply them upon your request.

I have tried the operation multiple times to no avail and am concerned about the limited number of sessions I have available as part of my current plan with Udacity. Could you please guide me on how to proceed with creating an external table from my CSV file, or advise on an alternative method to accomplish this?

Thank you for your prompt assistance with this matter.

Best regards

Aninda

Answer 1

Hi Aninda M,

Thank you for posting on the Microsoft Community Forum.

From the description above, I understand that your question is about Azure.

Sincethere are no developers working with Azure on this forum. For quick and efficient handling of your problem, I recommend asking your question again in the Q&A forum, where a dedicated technician will give you a professional and efficient answer.

Here is the link to the Q&A forum.
Q&A - Microsoft Q&A

Click the "Ask a question" button at upper right corner to ask your question, and select "Azure" tag and other tags related to your productions.

I hope the above information is helpful.

If you have any questions or concerns, please feel free to let us know.

All the best
Neuvi Jiang