Data & Schema Discussions

How to install a new python library or module to use in incorta materialized view ?

Hello there, I'm looking to install a couple new libraries on incorta, so that they can be utilized in during creating a materialized view. Can someone guide me to a documentation for it or enlist the steps ?Thank you in advance !Regards,Ruchita

MV Table in a business schema

Dear all,is it possible to create a MV from two tables in a physical schema and use this MV in the business schema ?

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