This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
I am connecting Hive database using Azure Delta databricks datasets in azure data factory. connection and everything is successful but why i added in Sink and validate in copy data object .. it is giving validation error
Which dataset should use to load data into Hive table
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
An Apache Spark-based analytics platform optimized for Azure.
An Azure service for ingesting, preparing, and transforming data at scale.
Hi @Shambhu Rai
Just checking in to see if the below answer provided by @Pratik Somaiya helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Hi @Shambhu Rai
You can use Hive activity in ADF when working with Hive tables
Please refer to the below documentation:
https://learn.microsoft.com/en-us/azure/data-factory/connector-hive?tabs=data-factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
@Pratik Somaiya ,@PRADEEPCHEEKATLA - facing same issue.
Using Hive activity will retain the delta functionality into the table? The table I have created in Azure databricks is a delta table . wondering why the Azure databricks delta lake linked service is not able to connect the table.
How to create a delta table that works with ADF >> Azure databricks Delta lake and Azure databricks metastore ?
@VENKATA SATYA S RAVI KUMAR APPARAJU
If you need to copy data from Hive datastore then it is recommended to use Hive activity
https://learn.microsoft.com/en-us/azure/data-factory/connector-hive?tabs=data-factory
Have you tried using Hive activity?
I understand that you created a Delta table, but if source is Hive then recommend to use Hive dataset as source dataset