Hi all,
I am trying to connect to a CSV data source on Azure Storage Account File Shares. I have the CDATA configured as below according to Connect to CSV with CData – TimeXtender Support.
But when I test the connection I got error “The given path's format is not supported.”
Can you guys help me find the reason why? That would be much appreciated.
Best answer by Xiaoqing Hu
Hi
Thank you for the tip. Yes it is working now.
The problem was that I was using an azure file share location for the schema location as well next to the url for connecting, and that seems not fit and gives the error format not supported. After I change the schema location to a local E: drive on the VM it works.
+5Hi
I have spent some more time explaining the different Data Lake options
Can you confirm that the file share is like this one?
If it is a blob container you should use azureblob:// or abfsss:// instead.
Hi
I have spent some more time explaining the different Data Lake options
Can you confirm that the file share is like this one?
If it is a blob container you should use azureblob:// or abfsss:// instead.
Hi
+5Hi
We recently released a new version of all the providers.
I tried to set it up in that.
I made the setup changes marked with red squares.
See if it still do not work in that.
Hi
Thank you for the tip. Yes it is working now.
The problem was that I was using an azure file share location for the schema location as well next to the url for connecting, and that seems not fit and gives the error format not supported. After I change the schema location to a local E: drive on the VM it works.
+5Hi
OK, yeah that will not work. I am not even sure they have a option of saving any location field files in anything but local folders.
This field is mainly used for the provider, so it should be OK to store it locally. If you used multiple environments and had this on different servers, you would maybe try to store the location files on a location visible by both, but if it is not possible, having the same files on both servers is also fine.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
