SQL Metadata Tool

The SQL Metadata Tool allows authorized users to add, edit, and remove SQL schemas, tables, and columns. (Available as of version 17.29)

With the SQL Metadata tool, you can easily add SQL schemas to the metadata store. Once your tables are in a SQL schema, you can access them with a SQL tool such as Tableau or Power BI. The SQL schema namespace differs from the hierarchical 1010data database in that it is a global namespace shared by all customers in an environment. Therefore, only administrators can create or delete a schema. However, the SQL Metadata Tool allows ordinary users to create a self-schema. A self-schema must have the format self_[USERNAME]. With a self-schema, the user can save tables for use with the ODBC/JDBC drivers without requesting that an administrator create a schema. Once the user creates a self-schema, it is no different in functionality from any other schema. When the self-schema is first saved, only its creator can use it. However, the self-schema's creator can edit it to add user or administrator access to other users. Users who are listed as admins for a schema or self-schema may edit the schema and any objects within the schema.

The SQL Metadata tool contains separate tabs for adding, editing, or deleting schemas, tables, columns, and views for a given SQL database catalog. The tool also contains tabs to auto-populate a schema, reorder columns, edit keys, and edit foreign key relationships.

Note: In most cases, you will use the SQL database catalog tenten. Click Reload into session to refresh the entire catalog in the session.

See also <do action_="sql"> in the 1010data Reference Manual for a programmatic API to the SQL metadata store.