Spanner: Documentation missing for PROTO BUNDLE

[SanjayVas]

There doesn't appear to be any documentation on how to deal with CREATE PROTO BUNDLE or ALTER PROTO BUNDLE DDL statements using the JDBC driver. There appears to be a PROTO_DESCRIPTORS variable that can be set.

java-spanner-jdbc/src/test/resources/com/google/cloud/spanner/jdbc/ITDdlTest.sql

Line 204 in abea10e

SET PROTO_DESCRIPTORS = 'CvYCCgxzaW5nZXIucHJvdG8SFmV4YW1wbGVzLnNwYW5uZXIubXVzaWMi6gEKClNpbmdlckluZm8SIAoJc2luZ2VyX2lkGAEgASgDSABSCHNpbmdlcklkiAEBEiIKCmJpcnRoX2RhdGUYAiABKAlIAVIJYmlydGhEYXRliAEBEiUKC25hdGlvbmFsaXR5GAMgASgJSAJSC25hdGlvbmFsaXR5iAEBEjgKBWdlbnJlGAQgASgOMh0uZXhhbXBsZXMuc3Bhbm5lci5tdXNpYy5HZW5yZUgDUgVnZW5yZYgBAUIMCgpfc2luZ2VyX2lkQg0KC19iaXJ0aF9kYXRlQg4KDF9uYXRpb25hbGl0eUIICgZfZ2VucmUqLgoFR2VucmUSBwoDUE9QEAASCAoESkFaWhABEggKBEZPTEsQAhIICgRST0NLEANCKQoYY29tLmdvb2dsZS5jbG91ZC5zcGFubmVyQgtTaW5nZXJQcm90b1AAYgZwcm90bzM=';

[SanjayVas]

Thanks for the very quick turnaround! I noticed that this doesn't document the PROTO_DESCRIPTORS or PROTO_DESCRIPTORS_FILE_PATH variables though, which would be how one would interact with the PROTO BUNDLE over pure DDL. This is necessary for schema management systems like Liquibase.

[olavloite]

@SanjayVas The SET PROTO_DESCRIPTORS and SET PROTO_DESCRIPTORS_FILE_PATH are the SQL equivalent of the setProtoDescriptors method. Meaning that instead of this method call, you can also execute:

SET PROTO_DESCRIPTORS_FILE_PATH='/path/to/descriptors.pb'

or

SET PROTO_DESCRIPTORS='<base64 encoded contents of the descriptor file>'

I'll try to add sample for the above as well some time in the coming days.