For a specified measure, Oracle's LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates the values of the measure column. How do we implement the LISTAGG() function in Incorta?
We can implement this using Spark...
Incorta supports many connectors but it can happen that there is a particular cloud application for which we do not have a connector yet. For eg Pendo is one such application, it does have a REST API framework which we can use to query the data from...
Refer to https://www.oracle.com/database/technologies/java-connectivity-to-atp.htmlDownload the Autonomous Data Warehouse Client Credentials (wallet) zip fileUnzip the wallet file and copy the credentials folder to a location on the Incorta serverIf...
? is the epoch time stored in the time log file for that table in our server. Duplicate rows could be due to key columns as Incorta does a upsert based on the keys so can you check the key fields?
One more option is our runtime sql view , it is still a lab feature and we can write a Union sql in that , pls check https://docs.incorta.com/5.2/concepts-incorta-sql-view
.png "Employee"){kind=icon}
