GET /v1/storedProcedures/{id}/versions
from metadata.sdk import configure
from metadata.sdk.entities import StoredProcedures
configure(
host="https://your-company.open-metadata.org/api",
jwt_token="your-jwt-token"
)
# List all versions
versions = StoredProcedures.get_versions("770e8400-e29b-41d4-a716-446655440000")
for v in versions:
print(f"Version {v.version}: {v.description}")
# Get a specific version
sp_v1 = StoredProcedures.get_specific_version(
"770e8400-e29b-41d4-a716-446655440000",
"0.1"
)
print(f"Original description: {sp_v1.description}")
import static org.openmetadata.sdk.fluent.StoredProcedures.*;
// List all versions
var history = StoredProcedures.getVersions("770e8400-e29b-41d4-a716-446655440000");
for (var version : history.getVersions()) {
System.out.println("Version: " + version);
}
// Get a specific version
var v1 = StoredProcedures.getSpecificVersion(
"770e8400-e29b-41d4-a716-446655440000",
0.1
);
System.out.println("Description: " + v1.getDescription());
# List all versions
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions" \
-H "Authorization: Bearer {access_token}"
# Get a specific version
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions/0.1" \
-H "Authorization: Bearer {access_token}"
{
"entityType": "storedProcedure",
"versions": [
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.2,\"description\":\"Updated procedure to calculate average of integer arrays\",\"serviceType\":\"BigQuery\"}",
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.1,\"description\":\"Procedure to calculate average\",\"serviceType\":\"BigQuery\"}"
]
}
Stored Procedure Versions
List and retrieve historical versions of a stored procedure
GET
/
v1
/
storedProcedures
/
{id}
/
versions
GET /v1/storedProcedures/{id}/versions
from metadata.sdk import configure
from metadata.sdk.entities import StoredProcedures
configure(
host="https://your-company.open-metadata.org/api",
jwt_token="your-jwt-token"
)
# List all versions
versions = StoredProcedures.get_versions("770e8400-e29b-41d4-a716-446655440000")
for v in versions:
print(f"Version {v.version}: {v.description}")
# Get a specific version
sp_v1 = StoredProcedures.get_specific_version(
"770e8400-e29b-41d4-a716-446655440000",
"0.1"
)
print(f"Original description: {sp_v1.description}")
import static org.openmetadata.sdk.fluent.StoredProcedures.*;
// List all versions
var history = StoredProcedures.getVersions("770e8400-e29b-41d4-a716-446655440000");
for (var version : history.getVersions()) {
System.out.println("Version: " + version);
}
// Get a specific version
var v1 = StoredProcedures.getSpecificVersion(
"770e8400-e29b-41d4-a716-446655440000",
0.1
);
System.out.println("Description: " + v1.getDescription());
# List all versions
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions" \
-H "Authorization: Bearer {access_token}"
# Get a specific version
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions/0.1" \
-H "Authorization: Bearer {access_token}"
{
"entityType": "storedProcedure",
"versions": [
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.2,\"description\":\"Updated procedure to calculate average of integer arrays\",\"serviceType\":\"BigQuery\"}",
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.1,\"description\":\"Procedure to calculate average\",\"serviceType\":\"BigQuery\"}"
]
}
Stored Procedure Versions
Every change to a stored procedure entity creates a new version. Use these endpoints to view the version history and retrieve specific versions.List Versions
UUID of the stored procedure.
Get Specific Version
UseGET /v1/storedProcedures/{id}/versions/{version} to retrieve a specific version.
UUID of the stored procedure.
Version number to retrieve (e.g.,
0.2).GET /v1/storedProcedures/{id}/versions
from metadata.sdk import configure
from metadata.sdk.entities import StoredProcedures
configure(
host="https://your-company.open-metadata.org/api",
jwt_token="your-jwt-token"
)
# List all versions
versions = StoredProcedures.get_versions("770e8400-e29b-41d4-a716-446655440000")
for v in versions:
print(f"Version {v.version}: {v.description}")
# Get a specific version
sp_v1 = StoredProcedures.get_specific_version(
"770e8400-e29b-41d4-a716-446655440000",
"0.1"
)
print(f"Original description: {sp_v1.description}")
import static org.openmetadata.sdk.fluent.StoredProcedures.*;
// List all versions
var history = StoredProcedures.getVersions("770e8400-e29b-41d4-a716-446655440000");
for (var version : history.getVersions()) {
System.out.println("Version: " + version);
}
// Get a specific version
var v1 = StoredProcedures.getSpecificVersion(
"770e8400-e29b-41d4-a716-446655440000",
0.1
);
System.out.println("Description: " + v1.getDescription());
# List all versions
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions" \
-H "Authorization: Bearer {access_token}"
# Get a specific version
curl "{base_url}/api/v1/storedProcedures/d02b24fa-a246-4563-adf1-9ad21f251c0e/versions/0.1" \
-H "Authorization: Bearer {access_token}"
{
"entityType": "storedProcedure",
"versions": [
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.2,\"description\":\"Updated procedure to calculate average of integer arrays\",\"serviceType\":\"BigQuery\"}",
"{\"id\":\"d02b24fa-a246-4563-adf1-9ad21f251c0e\",\"name\":\"calculate_average\",\"fullyQualifiedName\":\"sample_data.ecommerce_db.shopify.calculate_average\",\"version\":0.1,\"description\":\"Procedure to calculate average\",\"serviceType\":\"BigQuery\"}"
]
}
Returns
List versions returns an object withentityType and a versions array of serialized entity snapshots (newest first).
Get specific version returns the full stored procedure object as it existed at that version.
Error Handling
| Code | Error Type | Description |
|---|---|---|
401 | UNAUTHORIZED | Invalid or missing authentication token |
404 | NOT_FOUND | Stored procedure or version does not exist |
Was this page helpful?
⌘I