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 ?
Dear all,is it possible to create a MV from two tables in a physical schema and use this MV in the business schema ?
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.
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")...
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 ...
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 ...