ODA User Guide

Practical Flow and FAQ

Common troubleshooting questions and role-based guidance for ODA.

This section captures common troubleshooting questions and role-based answers for ODA Data Studio users.

Common Questions

Why do I not see the Create button?

  • You likely have reader-level access.
  • Workspaces/Jobs create actions need manage_data.
  • Semantic Layers create/publish needs administrator.

Why is semantic layer delete blocked?

  • The layer is used by one or more projects.
  • The app intentionally prevents deleting in-use semantic models.

Why does Ask Optra say chat is not enabled?

  • The selected account does not have chat enabled.
  • Contact your administrator to enable this feature.

What does "Publish as Service" mean?

  • Publish as Service turns a SQL query you ran against the Gold zone in Zone Explorer into a governed, callable service (an MCP tool/service endpoint other systems or agents can invoke), instead of only being a one-off query result.
  • It only appears after a Gold-zone query returns rows, and opens a 3-step wizard: Metadata (slug, name, description), Parameters (named parameters your SQL template uses, each with a type and required flag), and Review (a SQL validation check before you submit).
  • Any literal values in your WHERE clauses are converted to ? placeholders bound to the parameters you declare, so the same published query can be called again later with different inputs.
  • Submitting creates a draft service version and sends it for review; it is a governed publishing workflow, not an instant publish—Ask Optra does not publish services itself, it only explains the feature. See Publish as Service for the click-by-click wizard steps.

Explain the four types of Simple SQL Transformations

  • Full — reloads and replaces the entire result of the transformation's query every run.
  • Full History — reloads the full result each run, like Full; it does not provide a separate historical-retention mode.
  • Incremental — uses the selected Watermark column to pull only rows that are new or changed since the last run's watermark value.
  • Incremental Insert — also watermark-driven, but only inserts new rows rather than updating previously ingested ones.
  • These four values come from the same type field used by Ingestion nodes; Ingestion additionally offers a fifth value, Incremental CDC, which Simple SQL Transformations do not expose.

For full operational context, refer to Conclusion and the upstream ODA guide sections.