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/Jobscreate actions needmanage_data.Semantic Layerscreate/publish needsadministrator.
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
WHEREclauses 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
typefield 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.