Even reference data available in joining SQL Server reference input tables, no result and no errors
FROM table, Event hub input
JOIN tables, SQL Server reference input
INTO, SQL Server table
SELECT a.Id
,SUM(r.FYQ1_c) AS FYQ1c
,SUM(r.FYQ2c) AS FYQ2c
,SUM(r.FYQ3c) AS FYQ3c
,SUM(r.FYQ4c) AS FYQ4c
INTO
[OutRevenueSplitVsAccount]
FROM
[RevenueSplitEvHuBIn] AS r TIMESTAMP BY LastModifiedDate
INNER JOIN [OpportunityInputTbl] AS o ON r.Opportunity_c = o.Id
INNER JOIN [AccountInputTbl] AS a ON o.AccountId = a.Id
GROUP BY a.Id, TumblingWindow(day,2)