Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

New Connector: My SQL connector

Answered
Mehdi Sridi User

Dear All,

Dear Fivetran Support Team,

I hope this message finds you well.

I am writing to inquire about the possibility of using our existing MySQL connector, named GCP_QA_RIMOWA_GROUP, to copy the results of SQL views into our Google Cloud Platform (GCP) environment.

Could you please confirm if this functionality is supported with the current connector, or if there are any specific configurations required to achieve this?

Thank you for your assistance.

Best regards,

 

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Rean Fivetranner

    Hi Mehdi,

    Thanks for reaching out about replicating views from MySQL to your GCP destination.

    Currently, the MySQL connector replicates the underlying tables but does not replicate the view objects themselves. This is because changes to the data in the underlying tables make it hard to accurately track incremental updates to the view itself.

    To preserve equivalent logic in your destination, we recommend manually re-creating the views. You can refer to this guide for best practices on replicating views in your target environment.

    Let us know if you need help or have any additional questions.

     

    Best,
    Rean Rodrigues