AWS: Create table lookup protocol for long-list value labels
Need way to reference and call lookup metadata information for long-list value labels. Good test example would be to create the value label look ups for state fips codes (see attached csv) file. Needs to be referenced from the standard metadata labels. E.g., see Feature Request #1352 where the label information looks like:
Instead of separate values/label columns method use a single column format such as the following:
title: "my column title",
keyType: "my keyType",
[all other weave metadata],
In this example, the standard config table references a lookup for values of "fips" referencing another table. The angle brackets or some other character flag might be necessary to tell AWS that this is a table lookup. Don't know if this is the best way to do this, but something along these lines might do...
#1 Updated by Andy Dufilie almost 4 years ago
Instead of using a value_lookup object for multiple purposes (value lookups and sql table locations), it's better to create a separate metadata field for a sql table lookup. I suggest having a private metadata field that contains a SQL query. For example, the field name could be "sqlValueLookupQuery" and the value would be "SELECT fips,name from myschema.fips_lookup". Each column could have a different lookup query in its metadata.