MySQL 5 destination connector with base normalization using SELECT * instead of WITH keyword

Summary

Looking for a MySQL 5 destination connector that uses SELECT * instead of the WITH keyword for base normalization.


Question

Is there a mysql 5 destination connector anyhere? The base normalization uses the WITH keyword which doesn’t work for mysql 5. Is there a fork or connector anywhere that uses SELECT * instead?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mysql-5-connector", "destination-connector", "base-normalization", "select-star"]

You could write your own custom transform in dbt to avoid CTEs/“with”