This space regroups calls to manage data package tables and staging tables. While these two concepts are often used interchangeably, there is a subtle difference between the two that is reflected in the API calls. The concepts are very much linked and one affects the other.
Data package tables are the specifications of the tables that will end up becoming staging tables. They are contained in a data package, itself contained in a source system. They are not specific to a database system in particular.
Staging tables are the actual tables in the database system. They are contained in a database schema, itself contained in an environment. By definition, their info is specific to a database system. See all “environment database“ calls.
Typically modifying a data package table will affect the corresponding staging table in the project’s modeling environment.
| Title | Path | Http Method |
|---|---|---|
| Metavault API - Get environment database table column |
/api/projects/{projectId}/environments/{environmentName}/schemas/{schemaName}/tables/{tableName}/columns/{column} |
GET |
| Metavault API - Get filtered global datapackage table list |
/api/projects/{projectId}/datapackagetables |
GET |
| Metavault API - Get environment database schema |
/api/projects/{projectId}/environments/{environmentName}/schemas/{schemaName} |
GET |
| Metavault API - Get environment database table |
/api/projects/{projectId}/environments/{environmentName}/schemas/{schemaName}/tables/{tableName} |
GET |
| Metavault API - Update data package table |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableId} |
PUT |
| Metavault API - Delete datapackage table column |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableNameOrId}/columns/{columnNameOrId} |
DELETE |
| Metavault API - Get datapackage table column list |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableNameOrId}/columns |
GET |
| Metavault API - Create data package table |
/api/projects/{projectId}/metavault/sourcesystems/{sourceId}/datapackages/{dataPackageId}/tables |
POST |
| Metavault API - Delete data package table |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableId} |
DELETE |
| Metavault API - Update data package table column (hard rule) |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableNameOrId}/columns/{columnNameOrId} |
PUT |
| Metavault API - Get environment database table list |
/api/projects/{projectId}/environments/{environmentName}/schemas/{schemaName}/tables |
GET |
| Metavault API - Get datapackage table column |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableNameOrId}/columns/{columnNameOrId} |
GET |
| Metavault API - Get data package table list |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables |
GET |
| Metavault API - Get environment database schema list |
/api/projects/{projectId}/environments/{environmentName}/schemas |
GET |
| Metavault API - Get environment database table data (with hard rules) |
/api/projects/{projectId}/environments/{environmentName}/schemas/{schemaName}/tables/{tableName}/query |
POST |
| Metavault API - Create data package table column |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableNameOrId}/columns |
POST |
| Metavault API - Get data package table |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/tables/{tableId} |
GET |
| Metavault API - Analyze file before data import |
/api/projects/{projectId}/metavault/sourcesystems/{sourceNameOrId}/datapackages/{dataPackageNameOrId}/analysefile |
POST |