Can I connect JDBC to Azure Data Lake Storage Gen2?

Question

[background]

I want to use the following Athena Connector with Azure Data Lake Storage Gen2 to query Azure Storage from Amazon Athena on AWS.

https://docs.aws.amazon.com/athena/latest/ug/connectors-adls-gen2.html

According to the documentation, a JDBC connection string to Azure Data Lake Storage Gen2 is required, but the Data Lake Storage documentation only provides an HTTP connection string for Azure Data Lake Storage Gen2.

A connection string of the form:

   datalakegentwo://jdbc:sqlserver://adlsgentwo1.hostname:port;databaseName=database_name;${secret1_name}  

secret1_name is like Azure Key Vault in AWS and stores the following secret information.

   {"username": "${username}", "password": "${password}"}  

I'm confused why the connection string like SQL Server.

[question]

Can I connect JDBC to Azure Data Lake Storage Gen2?

Answer 1

Hello @Takahito Iwasa ,

Thanks for the question and using MS Q&A platform.

There is no JDBC connection string available for Azure Data Lake Storage Gen2 account.

Note: ADLS gen2 does not natively offer access via JDBC

As per my knowledge - JDBC connection string is used to connect databases and not the storage accounts.

As per the document which you are referring in the question which clearly says as follows:

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 jhow you can be part of Q&A Volunteer Moderators