I have a SQL table which just started failing w/ a data agent error:>> INC_03010100: Unknown Error: Extraction failed [com.incorta.connector.dataagent.exception.DataAgentException: Failed to open new channel for executing command [QUERY_DATA]].View ...
The documentation ( link below ) says InQuery can be used either in an internal session variable or an InQuery filter operator and formula expression."What does this mean?" seems like a simple question, but there it is. When I drag a formula into a...
I have DBeaver set up to query Incorta via SQLi, but I'd like to send the SQL to SPARK directly a'la Spark SQL materialized views.How do I configure a DBeaver ( or the like ) to do that?
I'm in the middle of trying to figure this out - Incorta table w/ multiple key columns, some of which may be NULL on some rows. Do I need to assign ( IfNull ) fake values to these for Incorta to recognize them as part of a key? e.g. Think Order ...
If I have a table with keys defined and primary key enforcement turned on how does Incorta ingest and process duplicate rows? First in wins? Last one in wins? Other? If a duplicate(s) is found during an incremental update does the existing Inco...
