Information Schema
The MetaKraftwerk Information Schema (also “Data Dictionary”) consists of a set of system-defined views that provide metadata information about the objects created in the meta database of your project. (We know, metadata about metadata, now it's getting deep 😉 )
The Information Schema is implemented as a schema named @INFORMATION_SCHEMA that MetaKraftwerk automatically creates in every project.
List of Information Schema views
All views of the information schema are listed below:
| View name | Description |
|---|---|
| COLUMNS | Returns metadata about all columns in all tables in the meta database. |
| COMMITS | Information about all commits within the project. |
| DELIVERIES | The list of deliveries in the project |
| INSTANCE_LABELS | List of all labels attached to instances |
| Instance Metadata | Makes metadata available (read/write) |
| INSTANCES | List of all instances in the project |
| PATTERN_VARIABLES | Values of all pattern variables for the various instance folders |
| TABLES | List of all tables in the meta database |
General Usage
If you want to query a view of the information schema, you must qualify it with @INFORMATION_SCHEMA, as shown in the following example.
sql
SELECT * FROM @INFORMATION_SCHEMA.COLUMNS;