-
1. Re: Profiling Azure SQL DW table in Developer tool
Akshada Sable Sep 15, 2020 12:32 AM (in response to Amarendra Reddy Sagila)Hi,
Can you check if the profile warehouse is configured at the DIS level? Please share the profile run logs present at $INFA_HOME/logs/NodeName/Services/DataIntegrationService/disLogs/profiling to check the exact cause of the failure.
Thanks,
Akshada -
2. Re: Profiling Azure SQL DW table in Developer tool
Syed Muzamil Sep 17, 2020 9:52 PM (in response to Amarendra Reddy Sagila)1 of 1 people found this helpfulHi Amarendra,
There is no additional steps required for the Profiling object as such, however for creating a data object we need to have the operations (read,write) created.
Once you have the operations created, you can create the Profile on this object and run it.
Regarding the message "Drilldown Results not available", can you share the complete screenshot here?
Are you seeing any Profile results, if yes you need to select the particular column values and then perform the drilldown. This will populate the records in the Datapreview panel.
In case if the results are not available, please share the Profile logs as requested by Akshada for analysis.
Thanks,
Syed
-
3. Re: Profiling Azure SQL DW table in Developer tool
Amarendra Reddy Sagila Sep 18, 2020 5:32 AM (in response to Syed Muzamil)Hi Syed,
Yes, after creating the read, write Data Object Operations, I am able to see profiling and also drilldown results.
Thanks!