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 ...
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...
Unable to Load sql_audit table in _incortametadata schema -incorta version 5.2.5 Error-Failed to load data from local files due to unable to read input header with properties.
