title: Can we join tables in on-premise SQL Server database to tables in Delta tables in Azure Delta lake? what are my options
body: <p>I am archiving rows that are older than a year into ADLSv2 as delta tables, when there is a need to report on that data, I need to join archived data with some tables existing on on-premise database. Is there a way we can do a join without re-hydrating from or hydrating data to cloud?</p>