Biml metadata connection snippet

var metadataConnection = 
        SchemaManager.CreateConnectionNode("db_metadata", 

        RootNode.Connections["db"].RenderedConnectionString);

List<string> includedSchemas = new List<string>{"schema1"};
List<string> includedTables = null;
    
var metadataSchema = metadataConnection.GetDatabaseSchema(

        includedSchemas, includedTables, ImportOptions.None);

foreach (var t in metadataSchema.TableNodes) {
    //perform biml magic
}