Hi, All
Microsoft Azure Synapse Analytics target endpoint has a "executeTimeout" internal parameter.
I changed this value from 60(default) to 1800, but the changed value did not take effect on some query.
for example,
we got execute timeout error with query for getting target column information "SELECT c.name AS [Column Name] FROM sys.pdw_column_distribution_properties AS d INNER JOIN…" just 60 secs.
My customer often got execute timeout error with 60 secs from Azure Synapse Analytics during Full Load and some tables loading processes were suspended due to execute timeout error.
I know this timeout is mostly Azure Synapse Analytics' issue.
Microsoft had tried to resolve this issue , but not completely resolved yet.
So, please "executeTimeout" internal parameter value take effect to all query.
Best Regards,
Keishi Miyachi