Amazon Athena database -- is there a way to generate an Data Schema for Amazon ML in an automated way Amazon Athena database -- is there a way to generate an Data Schema for Amazon ML in an automated way
(e.g. a SQL command that would generate the Amazon-format)
Please see:
https://docs.aws.amazon.com/machine-learning/latest/dg/creating-a-data-schema-for-amazon-ml.html
NOTE:  I obtained an answer from AWS support; see below.
Although the reference above doesn't explicitly name the format as JSON, it looks very much like a JSON format to me.
FROM AWS Support-Team:
There are 3 ways of obtaining database schemas through AWS services that I have heard so far.  The first two are using Lake Formation, and the last is with glue:

In the Lake Formation console window select Tables, click on the desired table, and hit the properties button, this will show a json schema as part of the information (&quot;StorageDescriptor&quot;)
If the Lake Formation was setup using database blueprints, the blueprint will contain the schema, it is available from the lake formation console under blueprints
AWS glue data catalog – once a database is crawled by glue, it’s table schemas are available under the “View Properties” after clicking on the table, similar to 1)