Using Biml to Retrieve Query Metadata

Kevin Feasel

2019-06-17

Biml

David Stein shows how you can use the GetQuerySchema() function in Biml to retrieve metadata for a query:

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so.

The GetQuerySchema method provides an excellent way to import metadata from a query, in a similar way as GetDatabaseSchema imports schemas, tables, and views. GetQuerySchema was introduced last year with the 2018 editions of BimlStudio and BimlExpress.

This kind of higher-level programming takes some getting used to, but once you understand it, you can find common data access patterns and build one solution to work through many versions of the pattern.

Related Posts

Importing Biml Metadata from Excel

David Stein wraps up a series on using Biml to load flat files: Make sure you read and understand the concepts in each of the following articles before tackling this one. – Import Biml Metadata with GetQuerySchema– BimlScript Code Nuggets and Mad Libs– Import Biml Metadata Directly from Excel One of the primary issues I’ve […]

Read More

Importing Biml Metadata from Excel

Kevin Feasel

2019-06-24

Biml

David Stein shows how you can take table and column data from Excel and use it to populate Biml flows: Excel Spreadsheets as a metadata source have a lot going for them.– Everyone uses Excel and is comfortable with it.– Excel is incredibly customizable and versatile.– Excel offers data validation and filtering. For these reasons, […]

Read More

Categories

June 2019
MTWTFSS
« May Jul »
 12
3456789
10111213141516
17181920212223
24252627282930