jdfc url of blob storage

Shambhu Rai 1,411 Reputation points
2023-11-06T12:32:08.7566667+00:00

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>")
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,489 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,219 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,854 questions
Azure Data Lake Analytics
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,231 Reputation points
    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.