In this step, the converted assets would be reviewed for performance optimization to improve the execution duration by leveraging the Pushdown optimization, Partitioning, and specific connector level tunings. Performance tuning can be taken up as needed for different end-point connectors.
Please see the optimization methods to be followed in the Cloud Data Integration(CDI) assets in the PDF below:
Please see the resources below for the following topics:
- Performance tuning Guidelines for Snowflake connector
- Performance tuning Guidelines for AWS Redshift connector
- Performance tuning Guidelines for GBQ
- Performance tuning guidelines for Microsoft Azure Synapse SQL