Administrative Discussions

Configure SQL tool to query Incorta via SPARK

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?

Resolved! How to implement column level security?

There are some business sensitive columns that only certain users should have access to. For example, only show salary information to executives or users at a certain management level or above. For all other users trying to build insights using thi...

How Does Incorta treat NULLs for KEY columns

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 ...

Resolved! How to Avoid Counting Nulls in a DISTINCT Expression

Using DISTINCT() with an IF() in a formula expression leads to incorrect computation as nulls are not handled by default for an on-premise Incorta environment.

How does Incorta treat duplicate rows for load and update?

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...