# WORKS: --profile flag
databricks apps list --profile my-workspace

# WORKS: chained with &&
export DATABRICKS_CONFIG_PROFILE=my-workspace && databricks apps list

# DOES NOT WORK: separate commands
export DATABRICKS_CONFIG_PROFILE=my-workspace
databricks apps list  # profile not set!

# discover table structure (columns, types, sample data, stats)
databricks experimental aitools tools discover-schema catalog.schema.table --profile <profile>

# run ad-hoc SQL queries
databricks experimental aitools tools query "SELECT * FROM table LIMIT 10" --profile <profile>

# find the default warehouse
databricks experimental aitools tools get-default-warehouse --profile <profile>

# current user
databricks current-user me --profile <profile>

# list resources
databricks apps list --profile <profile>
databricks jobs list --profile <profile>
databricks clusters list --profile <profile>
databricks warehouses list --profile <profile>
databricks pipelines list --profile <profile>
databricks serving-endpoints list --profile <profile>

# ⚠️ Unity Catalog — POSITIONAL arguments (NOT flags!)
databricks catalogs list --profile <profile>

# ✅ CORRECT: positional args
databricks schemas list <catalog> --profile <profile>
databricks tables list <catalog> <schema> --profile <profile>
databricks tables get <catalog>.<schema>.<table> --profile <profile>

# ❌ WRONG: these flags/commands DON'T EXIST
# databricks schemas list --catalog-name <catalog>    ← WILL FAIL
# databricks tables list --catalog <catalog>           ← WILL FAIL
# databricks sql-warehouses list                       ← doesn't exist, use `warehouses list`
# databricks execute-statement                         ← doesn't exist, use `experimental aitools tools query`
# databricks sql execute                               ← doesn't exist, use `experimental aitools tools query`

# When in doubt, check help:
# databricks schemas list --help

# get details
databricks apps get <name> --profile <profile>
databricks jobs get --job-id <id> --profile <profile>
databricks clusters get --cluster-id <id> --profile <profile>

# bundles
databricks bundle init --profile <profile>
databricks bundle validate --profile <profile>
databricks bundle deploy -t <target> --profile <profile>
databricks bundle run <resource> -t <target> --profile <profile>