jdfc url of blob storage

Shambhu Rai Suspended 1,411

Hi ,

i wanted to push the files to blob storgate using portman ... how to connect using jdbc connection

i tried below but unable to push it.. can i get jdbc file for adls

spark.read.load("abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/<path-to-data>")

dbutils.fs.ls("abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/<path-to-data>")

PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee

2023-11-10T08:15:23.12+00:00

@Shambhu Rai - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee

2023-11-07T08:40:02.5366667+00:00

@Shambhu Rai - 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.

This article contains links to tutorials that show you how to use various Azure services with Data Lake Storage Gen2.

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

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
PRADEEPCHEEKATLA-MSFT 90,146 Reputation points Microsoft Employee

2023-11-15T07:05:29.57+00:00

@Shambhu Rai - Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

jdfc url of blob storage

1 answer

Your answer