Hello @HimanshuSinha-msft , the issue was with different variable names being used in Synapse pool and in Stream analytics. The issue is resolved now, Apologies for not keeping the thread updated.
Synapse Pool query return NULL values
Amber Bhanarkar
1
Reputation point
I am sending data from IoT Hub to Stream Analytics and then to Synapse Pool. In stream analytics the data is coming completely fine as I want. But querying the data in Synapse pool is giving me NULL values for two columns i..e, 'dates' and 'times'. These both are string variables and are getting Not-Null values in Stream Analytics.
![
]2
Above is Synapse query result and below is Stream Analytics query result