nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Semantic Modeler - Use of Trino connection (Starburst)

Thomas HYRIEN

Hello,

We would like to use Trino connections in Semantic Modeler.

Trino Starburst is very useful in the company and we have high expectations for using it in OAC Classic through a subject area.

Thank you

Find more posts tagged with

Delivered

Status: Delivered

Comments

Pravin Janardanam-Oracle

Thank you very much for reaching out and sharing your valuable feedback. Trino connectivity in Semantic Modeler is tentatively scheduled for release in CY 2025.

Thomas HYRIEN

Hello,

Trino connectivity in Semantic Modeler is now available.

But it doesn't work well with the hierarchy : Catalog > Schema > Table

The level Catalog is missing. So we have several schemas with the name at the same level.

And the tables are not loading.

Pravin Janardanam-Oracle

Hi,

Does the physical layer of the semantic model under the database have a catalog, schema, and table?

If the table import did not create the catalog, you can manually create the catalog and the schema in the Physical Layer as needed.

Thomas HYRIEN

Hi, yes but it is very long to create all the tables and all the columns manually… Why the metadatas are not loading ?

Pravin Janardanam-Oracle

Is the import working and only the catalog missing or the objects are not loading at all when you expand the connection for import?

For the first case, follow these steps..

Lets say, after import, you have Schema —> 100s of Tables directly under Physical Database.

Now you want the path to be CAT1 —> Schema —> 100s of Tables.

Step 1: Create the Catalog CAT1
Step 2: Cut the schema and paste on CAT1

No need to create tables manually.

Thomas HYRIEN

When I expand my trino connection, I have directly the list of the schemas and not the catalogs.

Import is not working because I can't expand the tables under the schemas.

Pravin Janardanam-Oracle

Is the Catalog specified in the connection?

Top Leaders

Top Ideas

Allow us to delete unwanted NSAW pages and watchlists
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
Include a "Show Where Used" option on Workbook objects
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
Promote a folder, a single workbook, or multiple workbooks between Oracle Analytics Cloud instances
We want to automate the workbook export to .dva file and import this into another OAC instance using REST API, The goal is an OCI DevOps pipeline that can promote (a) a whole folder, (b) a single workbook, or (c) several workbooks in one run to another OAC instance, and print a status result at the end. Blocker: Export and…
Save AI-detected anomalies and insights as a reportable dataset
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…
Custom snapshot : disable catalog content
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.