Google’s spanner database special syntax on createTable change type, the feature “interleaved tables”
Spanner is a distributed database. Interleaved tables are basically a way to indicate that the tables are often queried together and data should be located close together when possible. I’ll be updating the spanner extension here
What would be the best way to add an interleaved attribute to createTable? It seems there could be many ways.
- modifySql type, checking for spanner only, to append the interleaved syntax. No extension needed.
- make a new createTableSpanner element, which copies dbchangelog-4.2.xsd but with interleaved as an attribute. This would make more obvious that non-standard features are being used.
- Have the spanner extension extend the createTable adding in the interleaved attribute. If commands were copied to another database, liquibase would probably just ignore the interleaved element because of the “namespace=”##other" processContents=lax" in the xsd
- Some other way with the Change type?
Is there a best practice on this?