Explanation of this guide: This guide will cover the basics on how to create an external table reference for Cross-database querying Azure SQL Databases. For this guide to work, we will need tw...
Published Aug 27, 2019
Version 1.0
Blog Post
Great work and thanks very much. I had been creating tables for my views in my main reporting database because I couldn't Cross Query. My efforts were complicated and required a great deal of data duplication of the Production data to populate the view tables. My largest cross database is 800+ tables. If you have a moment, let me know if you think number of tables plays a part using your scheme. I'm going to start consuming your idea. I already used a strategy like this for ingesting our legacy data through Parquet files but not as a solution for the Cross Query problem. Cheers Jim