As per this ticket, raising a feature request to include Performance Max campaigns:
"Performance Max campaigns are not supported. Performance Max campaigns have recently been introduced in the Google Ads API v9 but Fivetran uses Google Ads API v8.1 in the new connector which is currently in Private preview.
The current connector is on an older API version, so Performance Max campaigns are not supported.
I request you to raise this as a feature request with our product team".
Also, video campaigns are not available in the metadata tables. Could this be made available as well?