Launch week·Five new features shipping this week (March 30 – April 3)→
3 posts tagged with "Database"
View All TagsThe assets page now includes a workspace exploration view with data tables, Ducklakes, and object storages. Column-level tracking detects which columns are read or written in DuckDB and data table queries. Individual tables can be starred as favorites for quick access.
New features
- Assets exploration UI with cards for data tables, Ducklakes, and object storages
- Column-level asset tracking for DuckDB and data table queries
- Column badges displayed on flow graph asset nodes
- Favorite/star individual tables in the database manager
- Deep-linking to the database manager via URL hash
The database studio now supports altering existing tables. Right-click a table to rename columns, change types, add or remove columns, and update foreign keys. A SQL preview shows the ALTER TABLE statements before execution.
New features
- Alter table support in the database studio
- Rename columns with automatic foreign key reference updates
- Add, remove, and modify columns with type changes
- SQL preview of ALTER TABLE statements before execution
- Warning for databases without transactional DDL support
Windmill Data Tables provide workspace-scoped relational data storage with near-zero setup, enabling scripts and flows to leverage SQL without exposing credentials.
New features
- Near-zero setup relational data storage managed by Windmill
- Workspace-scoped with automatic credential management
- Support for Custom instance database (superadmin-managed) or Postgres resources
- Safe parameterized queries in TypeScript and Python
- Native DuckDB integration with ATTACH syntax
- Automatic asset detection and data dependency visualization
- Default "main" data table for simplified access
- Full CRUD operations for all workspace members