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
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' %3EKA%3C/text%3E%3C/svg%3E)
@Pratik Somaiya ,@PRADEEPCHEEKATLA-MSFT - 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 ?
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