amazon web services - Autofilling Vertex Properties in GraphMappingConfig

Question

I am Using AWS DMS to migrate schemas from MySQL to an AWS Neptune graph database. Part of this process is writing a GraphMappingConfig.json file. There isn't much documentation, but I am wondering, is there is a way to implicitly define vertex properties from the column names and values?

For example, I don't want to have to write a separate "vertex_property" object for each property, because I have many tables and dozens of columns on each table. Instead, I suspect that there should be a way to encode that I want vertex properties to be built as {column_name: column_value} ranging over all columns except the table's id column.

question from:https://stackoverflow.com/questions/65839232/autofilling-vertex-properties-in-graphmappingconfig

Answer 1

As it stands today, you'll need to explicitly define each column that you want to bring over into a vertex property (similar with columns from join tables that you want to bring over as edge properties) within the JSON mapping file. You could write a script to build the JSON and that is something that we've discussed providing to customers. Just need to get back around to working on that. :)