---
title: "Metadata Export"
canonical: "https://docs.vaultspeed.com/space/VPD/3012853765/Metadata%20Export"
format: markdown
---
With the metadata export, you can export information about the Sources, Data Vaults, and Business Vaults.  
This can be used for example to retrieve data lineage information.

A configuration defines which metadata should be exported and with which file name. If no attributes are selected in the configuration, then all attributes will be exported by default.  
The generation screen lets you select a certain release and export the metadata of that release with a certain configuration.  The resulting CSV file will be downloaded through the browser.  
The CSV has a header, uses a semicolon (“;”) as a column separator and a newline as a row separator.

The metadata exports are counted for the VAU count in your subscription. So these will also show up in the chart on the dashboard.  
The formula that is used is: `number_of_attributes * number of records / 5000`

For example, If you have on average 800 data vault objects, with 52 releases per year a dv_src_column_relation export each release costs per year:  
`52(12*20 000/5 000) = 2496`

which is only 4% of a gold subscription.

# Configurations

We have already created 2 configurations for the lineage between the Data Vault and source, at the object and attribute level.

![image](media://182064af-f819-41c8-bc76-6ea9c9629ce0)

To create your own configuration, click the '+ Configuration' button.  Give your configuration a name and description.  Select the Attributes you want to export and choose a name for the CSV file that will be generated.  Click the ‘Create’ button at the bottom to save your configuration.

![image](media://01216cae-ae48-47c7-a3bf-77ba047d503e)

When your configuration is saved, you can go to the Generation tab.  Select a project, data vault + release and business vault release.  Choose the configuration you want to export and click the ‘Generate’ button.

![image](media://f58c2eda-78b1-4797-bbca-ecfa80dc887f)

You can follow the progress of the generation in the VaultSpeed task list (the round button at the bottom right).  When the generation is done, hit the ‘Refresh’ button on the Generation screen.  You can now download the exported metadata.

![image](media://62634f19-7793-4bba-b4e0-f449ee39808a)


### Available properties

|  |  |  |  |
| --- | --- | --- | --- |
| **layer** | **type** | **property** | **description** |
| SRC | TABLE | src_name | source release identifier:   
“src_name - release comment (release number)” |
| SRC | TABLE | src_physical_schema |  |
| SRC | TABLE | stg_physical_schema |  |
| SRC | TABLE | cdc_physical_schema |  |
| SRC | TABLE | ini_physical_schema |  |
| SRC | TABLE | src_table_name | The table name from the source (without pattern removals) |
| SRC | TABLE | stg_table_name | table name of the object (with patterns removed) as shown in the source editor |
| SRC | TABLE | stg_table_short_name | short name of the object as shown in the source editor |
| SRC | TABLE | stg_table_abbreviated_name | abbreviated name of the object as shown in the source editor |
| SRC | TABLE | src_short_name | short name of the source |
| SRC | TABLE | src_name_in_bk | the source business key |
| SRC | TABLE | src_table_comment |  |
| SRC | COLUMN | src_column_name |  |
| SRC | COLUMN | src_column_order | The order of the attributes, this value can differ from the value in your source, since new attributes are always added at the end by Vaultspeed. |
| SRC | COLUMN | src_column_comment |  |
| SRC | COLUMN | src_column_data_type |  |
| SRC | COLUMN | src_column_data_precision | only for numeric data types |
| SRC | COLUMN | src_column_data_scale | only for numeric data types |
| SRC | COLUMN | src_column_data_length | data size for non numeric types |
| SRC | COLUMN | stg_column_name |  |
| DV | TABLE | datavault | Data Vault release identifier:   
“dv_code (dv_name)- release name (release number)” |
| DV | TABLE | dv_physical_schema |  |
| DV | TABLE | dv_table_name |  |
| DV | TABLE | dv_table_type | type of DV object (short name) e.g. HUB, LNK,LND, …. |
| DV | TABLE | dv_table_type_description | type of DV object (long name) e.g. Satellites on Hubs, Relationship Based Links, … |
| DV | TABLE | dv_linked_tables | DV objects referenced by this object, `', '` separated list of dv_table_name’s  
e.g. for a SAT this contains the HUB, for a LNK the linked HUBS, … |
| DV | COLUMN | dv_column_name |  |
| DV | COLUMN | dv_column_order | The order of the columns in the data vault objects (this can also be used to see the order of your business keys in the hub objects) |
| DV | COLUMN | dv_column_type | the type of attribute e.g. OBJECT_H_KEY, BUSINESS_KEY, LOAD_TIMESTAMP, … |
| DV | COLUMN | dv_column_data_type |  |
| DV | COLUMN | dv_column_data_length |  |
| DV | COLUMN | dv_column_data_precision |  |
| DV | COLUMN | dv_column_data_scale |  |
| DV | COLUMN | dv_data_type_null_value | the null exception value for this attribute |
| DV | COLUMN | dv_data_type_unknown_value | the unknown exception value for this attribute |
| BV | TABLE | bv_physical_schema |  |
| BV | TABLE | bv_table_type |  |
| BV | TABLE | bv_table_type_description |  |
| BV | TABLE | bv_table_name |  |
| BV | COLUMN | bv_column_name |  |
| BV | COLUMN | bv_column_data_type |  |
| BV | COLUMN | bv_column_data_length |  |
| BV | COLUMN | bv_column_data_precision |  |
| BV | COLUMN | bv_column_data_scale |  |
| SRC | TABLE | record_src_name |  |
| SRC | TABLE | record_src_value |  |
| SRC | TABLE | source_name |  |
| SRC | TABLE | source |  |
| SRC | COLUMN | src_linked_table |  |
| SRC | COLUMN | src_linked_column |  |
| DV | COLUMN | dv_linked_hub_name |  |
| DV | COLUMN | dv_driving_key |  |