Data & Schema Discussions

SQL Server new Data Source connection Error

Hi Team,I'm new to Incorta and started to learn this wonderful tool.I'm trying to create an SQL Server Data Source connection in my Trail version environment but getting the below error while testing the connection.ErrorINC_03070502: Failed to Connec...

how to convert date to string

Hi,I have two columns , one is timestamp and another one is string. I want to join these two columns in spark sql mv.Date_effective column is timestamp with "yyyy-mm-dd hh:mm:ss" format.Period_name column is string with "mm-yy" format. I want write b...

Resolved! Month End Schema Scheduling

Hi, I would like to load a schema only at the end of the month, but Incorta does not offer the ability to schedule it for that time.Example : We may have 28, 29, 30, or 31 days this month. With Incorta, we can schedule on a specific day instead of st...

Joins missing post upgradation from 5.2.9 to 6.0.3

Hello Everyone,We recently upgraded to 6.0.3 from 5.2.9 and post upgrade we are getting two weird issues -1)Few joins are missing.2)Compaction issue which is causing data mismatch.Do let us know if any one had already faced similar issue.

subquery

Hi Team,Glad to see you all.I need help to get run time values by passing input. in sql query we can call as subquery.query(EBS_CS.CS_ESTIMATE_DETAILS.AFTER_WARRANTY_COST,EBS_CS.CS_ESTIMATE_DETAILS.SOURCE_CODE = 'DR',EBS_CS.CS_ESTIMATE_DETAILS.LINE_C...