when we connect to redshift SQl query is not generating has Teradata connection. its splitting physical query in the session log
Can you clarify? It sounds like it might require a support ticket and not an 'idea'
Problem Description:
Physical query for OAS reports is not generating in expected form by using redshift ODBC Advance connection.
Problem Explanation and Challenges:
While generating physical query, we are facing 3 different patterns of issues.
Problem 1: Timedifference logic is not populating in a proper executive query format. Due to which the debugging process will be challenging as the timestamp difference columns are not parsing. It is in frontend computed format.
Problem 2: For any parent and child connected reports, Teradata is generating physical queries in subquery format but using redshift, the subqueries are generating separately. The challenge here is to identify the relationship between parent and child reports, as physical query is splitting the subquery.
Problem 3: Query with multiple joining condition like an inner join or a left / right outer join, the query gets splits up into different whole query. Again, the debugging process get tricky as the columns splits up from main query.
It is still not clear what you are trying to do. What is the use case are for mixing feature sets between DBs? What is your source DB, Redshift or Teradata?
We are migrating our enterprise data warehouse from Teradata to Redshift.
In this process, our backend table structure will remain same on Redshift, and all our OAS reports will be now pointed to Redshift database.
While running OAS Reports pointing to Teradata source, OAS Generates full query that can be directly executed on backend Teradata database, it is very helpful for troubleshooting data related issues.
But Incase of Redshift as a source, OAS is splitting that query into multiple sub queries which is not in the required format that can be directly executable on Redshift database. so it is becoming more difficult to validate the data related issues.
I feel it will be a big bottleneck for any migration projects to redshift if it is not resolved. Hope problem statement is clear and looking forward for a meeting if that helps.
Thanks
Sreekanth
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…
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…
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…
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…
We use the snapshot to update AppRoles members. But we would like to disable catalog content to have smaller snapshots and create snapshots faster.
