Data & Schema Discussions

Resolved! Time not matching

I time in DB column is coming as it is in the incorta table from query level. I executed the same script in DB and Schema level and the time was matching. Once the tables are loaded in incorta I explored the schema and found out that the time in DB w...

Trouble with CASE in Incorta SQL view

I am trying to create a new derived view using Incorta SQL. I am not trying to do anything tricky that I am aware of. I have checked the syntax for the query against Spark SQL for the CASE statement and it doesn't look out of order. Here is the query...

Resolved! Next Run Time stamp - Strikethrough

Hi,I'm trying to schedule a schema load and the next run timestamp is strike-through.The schedule never triggers as well.Any help would be appreciated.Thanks

IFError

Hi Team,i have excel formula column having Iferror function. Can you please let me know how to write it in Incorta.

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