Data & Schema Discussions

Incorta Metadata

Hi Team,I want to build the dashboard with metadata to know schema name, tables , alias tables, columns and formula columns used in which dashboard.Please let me know the table names and column names to build the dashboard.

Groupby Pivot in Materialized View

Hello, I am trying to create a materialized view with pyspark where I change the shape of a dataframe using a groupby and pivot function to create many new columns out of a pre existing column.Like so: result = df.groupby("ItemId").pivot("Question")...

week over week?

I need to do some reporting on a week-over-week basis. The built-in "ago" and "toDate" functions only support "month", "quarter" and "year".Any thoughts on how to do this inside a formula on a business schema? My last-ditch thoughts:1) create a date ...

What exactly does this do? >> Please, increase max retries threshold property.

I have a table which loads from a DB view. It takes a long time ( v. very quick for incremental, so hurrah for CDC! ) and just recently ( i.e. yesterday ) started erroring out when doing the full load. The error message includes this:The data source ...

Creation of a "Can Load" Schema Permission

I think it would be extremely helpful if "Can Load" was added as a responsibility in addition to "Can View", "Can Share", and "Can Edit" (see below). This responsibility would be allowed to load and share schemata but not edit them. It would be ext...