public void ThenALevyDeclarationSnapshotForTheCurrentDataShouldBeCreated() { var expectedTableName = $"DAS_LevyDeclarations_Snapshot_{DateTime.Today:yyyyMMdd}"; HmrcDataTestsRepository.RemoveLevyDeclarationSnapshotTable(expectedTableName).Wait(); InsertPendingLoadControl(); HmrcDataTestsRepository .InsertIntoStaging(new DataStagingRecord { Record_ID = 1, SchemePAYERef = "999/RD11111" }).Wait(); HmrcDataTestsRepository .InsertIntoStaging(new DataStagingRecord { Record_ID = 2, SchemePAYERef = "999/RD11112" }).Wait(); HmrcDataTestsRepository.ExecuteLoadData().Wait(); var tables = HmrcDataTestsRepository.GetLevyDeclarationSnapshotTableNames().Result; tables.Any(l => l == expectedTableName).Should().BeTrue(); }