create_asset_table
Creates a new asset table for file management with automatic URL, filename, length, MD5, and description columns, plus optional custom columns and foreign keys for provenance tracking.
Instructions
Create a new asset table for file management with automatic URL/checksum tracking.
Asset tables automatically include: URL, Filename, Length, MD5, Description. They integrate with executions for provenance tracking.
Args: asset_name: Name for the asset table (e.g., "Image", "Model", "Checkpoint"). columns: Additional columns beyond standard asset columns. referenced_tables: Tables this asset should have foreign keys to. comment: Description of the asset table's purpose. schema: Schema to create the table in. If not provided, uses the default domain schema.
Returns: JSON with status, table_name, schema, columns.
Example: create_asset_table("Image", [{"name": "Width", "type": "int4"}], ["Subject"])
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| columns | No | ||
| comment | No | ||
| asset_name | Yes | ||
| referenced_tables | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |