Implementing a Data Vault

So far in this book, design chapters were followed by provision and implement chapters. A Data Vault data warehouse, however, is a relational database. You can implement a Data Vault using either a SQL database or a Synapse Analytics dedicated SQL pool. The choice is largely economical. The total size of the Data Vault will matter. You need to estimate the total size. Once you know the tables and the data types of the columns, you can calculate the size by estimating the number of rows. You then need to know something about the usage and the performance you need. Size and performance together determine whether a SQL database will do the job or whether you need a Synapse SQL pool. In both cases, you can use the skills learned in earlier chapters to implement the Data Vault.