get_warehouse_settings
Retrieve current server-side database settings for a warehouse, including result caching and time travel retention.
Instructions
Return the current server-side database settings for a warehouse.
Reads result_set_caching, time_travel_retention_days, and
time_travel_retention_cutoff_date from sys.databases.
Both Data Warehouses and SQL Analytics Endpoints are supported.
Args: workspace: Workspace name or GUID. item: Warehouse or SQL Analytics Endpoint name or GUID.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace | Yes | ||
| item | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||