jdfc url of blob storage

Shambhu Rai 1,406 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,346 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,926 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,570 questions
Azure Data Lake Analytics

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 77,336 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.