Azure Data Factory Copy Activity to Copy to Azure Data Lake Table -
i need copy data incrementally on-prem sql server table in azure data lake store.
but when creating copy activity using azure portal, in destination see folders(no option tables).
how can scheduled on-prem table data lake table syncs?
data lake store not have notion of tables. file storage system (like hdfs). can use capabilities such hive or data lake analytics on top of data stored in data lake store conform data schema. in hive, can using external tables, while in data lake analytics can run simple extract script.
i hope helps!
Comments
Post a Comment