Hi ,
I have a query whether we can display the table or a dataset columns metadata as a report for the end users to show the data type for the columns ?
I mean something like this in OAC Report : DESCRIBE TABLE_NAME
@Ramya Madhyastha-Oracle -
Yes, you can display table metadata in an Oracle Analytics Cloud (OAC) workbook, though it requires creating a dataset or SQL queries to expose and visualize metadata details.
Example:
Hope this helps!
The column "table_name" in user_tab_columnsis just the table name, not the schema . table name. And user_tab_columns, as the name suggest, only works for objects owned by the current user (https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/USER_TAB_COLUMNS.html).
user_tab_columns
If the owner of the table is another user, you have to switch to all_tab_columns (could require different permissions in your DB ), and in there you have a column "owner" for the schema owning the table and again "table_name" that is just for the table name.
all_tab_columns
@Ramya Madhyastha-Oracle , do you really want to describe the table as it is in the database? Or do you want to describe the columns and data types of the columns in a DV dataset? Because they could be different if you transform them when creating the dataset based on your table.
Hi @Ramya Madhyastha-Oracle You try checking in other tables (or views) called ALL_TAB_COLUMNS or DBA_TAB_COLUMNS https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/ALL_TAB_COLUMNS.html#GUID-F218205C-7D76-4A83-8691-BFD2AD372B63
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_TAB_COLUMNS.html#GUID-91F945AE-5778-45A6-A07E-775A006A9AA1
Hope it helps.
HI @Gianni Ceresa @RajeshPolavarapu-Oracle
Thank you !! all_tab_column worked
@Gianni Ceresa , Basically I need to connect to the database and show all the tables metadata and add business need of each column and as and when new column is added I need not have to manually add it to the report it will be picked up from the dataflow or dataset
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.
