Data & Schema Discussions

Incorta Schema Data Size

Is there a way to automatically get list of all schemas and data size for each of them using any Postgres SQL or Sparks SQL code. Currently I see it as a manual process to go to list of schemas and capture each of their size.

2 Sets of RLS

If I have tables A, B, and C and want to use them for 2 different dashboards with different rules for row-level security, what would be the best way to do this? An example of this would be:Dashboard X only contains aggregate level information such as...

Resolved! incorta allowing to inherit the joins from source to Incorta?

Hi,Was incorta allowing to inherit the joins from source to Incorta? like oracle

Schema load schedule behavior

I have a schema which takes ~ 13 hours to load doing a full load.Last night it finished ~ 1:30 a.m. which is 1/2 hour *past* the scheduled incremental build time.I would have expected the scheduler to queue the incremental build and run it directly a...

Activity with in window of time

If I have a site and I want to bucket visitors in to 'Super Active,' 'Active,' 'Kinda Active,' and 'Meh' based on a rolling n-day window of activity ( e.g. 30 visits is 'Super' 2 is 'Meh' )That seems pretty straightforward for a given end date ( alth...