amit_kothari
Employee
Employee
since ‎03-02-2022
‎06-07-2023

User Statistics

  • 58 Posts
  • 8 Solutions
  • 3 Kudos given
  • 42 Kudos received

User Activity

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...
Can we use analytic functions like LEAD or LAG in Incorta Sparksql?  
While trying to load an Incorta table with nearly 1 billion rows from Oracle the load fails with 'ORA-01555 ERROR MESSAGE “SNAPSHOT TOO OLD”' error.
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...