Code
meta %>% dm_get_tables() %>% map(select, -any_of("constraint_name")) %>% map(
arrange_all) %>% map(collect) %>% jsonlite::toJSON(pretty = TRUE) %>% gsub(
schema_name, "schema_name", .) %>% gsub("(_catalog\": \")[^\"]*(\")",
"\\1catalog\\2", .) %>% writeLines()
Output
{
"schemata": [
{
"catalog_name": "master",
"schema_name": "schema_name"
}
],
"tables": [
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"table_type": "BASE TABLE"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"table_type": "BASE TABLE"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"table_type": "BASE TABLE"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"table_type": "BASE TABLE"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"table_type": "BASE TABLE"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"table_type": "BASE TABLE"
}
],
"columns": [
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"column_name": "a",
"ordinal_position": 1,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"column_name": "b",
"ordinal_position": 2,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "c",
"ordinal_position": 1,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "d",
"ordinal_position": 2,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "e",
"ordinal_position": 3,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "e1",
"ordinal_position": 4,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f",
"ordinal_position": 1,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f1",
"ordinal_position": 2,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "g",
"ordinal_position": 3,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "h",
"ordinal_position": 1,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "i",
"ordinal_position": 2,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "j",
"ordinal_position": 3,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "j1",
"ordinal_position": 4,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "k",
"ordinal_position": 2,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "l",
"ordinal_position": 3,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "m",
"ordinal_position": 4,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "ww",
"ordinal_position": 1,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "n",
"ordinal_position": 2,
"is_nullable": "YES"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "o",
"ordinal_position": 3,
"is_nullable": "NO"
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "zz",
"ordinal_position": 1,
"is_nullable": "YES"
}
],
"table_constraints": [
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"constraint_type": "FOREIGN KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"constraint_type": "FOREIGN KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"constraint_type": "FOREIGN KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"constraint_type": "FOREIGN KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"constraint_type": "FOREIGN KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"constraint_type": "PRIMARY KEY"
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"constraint_type": "UNIQUE"
}
],
"key_column_usage": [
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"column_name": "a",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "c",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "d",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "e",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_2",
"column_name": "e1",
"ordinal_position": 2
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f1",
"ordinal_position": 2
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "h",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "j",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "j1",
"ordinal_position": 2
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "k",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "l",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_5",
"column_name": "m",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "n",
"ordinal_position": 1
},
{
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "o",
"ordinal_position": 1
}
],
"constraint_column_usage": [
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_1",
"column_name": "a",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 1
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 1
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 1
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f1",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 2
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_3",
"column_name": "f1",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 2
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_4",
"column_name": "h",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 1
},
{
"table_catalog": "catalog",
"table_schema": "schema_name",
"table_name": "tf_6",
"column_name": "n",
"constraint_catalog": "catalog",
"constraint_schema": "schema_name",
"ordinal_position": 1
}
]
}
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.