Skip to content

README.md

Latest commit

 

History

History
10 lines (7 loc) · 765 Bytes

README.md

File metadata and controls

10 lines (7 loc) · 765 Bytes
Raw

SQL Admin Examples

This directory contains SQL scripts for Dremio administration and maintenance tasks.

Files

  • access_control_rbac.sql: Demonstrates Role-Based Access Control (RBAC) setup, creating users, roles, and granting privileges on folders and datasets.
  • reflection_management.sql: Scripts for creating, refreshing, and optimizing Reflections (Dremio's query acceleration technology).
  • data_maintenance.sql: Examples of table optimization (OPTIMIZE TABLE) and cleanup (VACUUM) for Iceberg tables.
  • source_engine_management.sql: Scripts for configuring and managing Dremio execution engines and source connections.