ATLAS_IMPORT stored procedure

The ATLAS_IMPORT stored procedure imports Db2® Big SQL metadata into Apache Atlas.

Authorization

Only the bigsql user or a user with Db2 Big SQL administrative privileges can run this procedure. However, the bigsql user can grant the EXECUTE privilege on the ATLAS_IMPORT procedure to any user, group, or role.

Syntax

Read syntax diagramSkip visual syntax diagram ATLAS_IMPORT ( schema-name , object-name , atlas-admin-properties )

Description

schema-name
Specifies the name of the schema that contains the object metadata that is to be imported into Atlas. The string can contain a pattern-expression, as described in LIKE predicate. NULL is treated as the wildcard character %.
object-name
Specifies the name of the object whose metadata is to be imported into Atlas. The string can contain a pattern-expression, as described in LIKE predicate. The pattern-expression is used to match tables, views, and nicknames in the specified schema. You can use NULL to specify that only schema metadata is to be imported into Atlas.
atlas-admin-properties
Specifies the Atlas administrator user ID and password that are to be used to import metadata. The format of this string is user-ID:password. In a Kerberized environment, this parameter is optional, and you can specify NULL as the value of this parameter.

Examples

In each of the following examples, the Atlas administrator user ID is admin and the password is admin123.
  • Import metadata for all table, view, and nickname objects within the EXAMPLES schema, as well as metadata for the schema itself.
    CALL SYSHADOOP.ATLAS_IMPORT('EXAMPLES', '%', 'admin:admin123');
  • Import metadata for all user schemas in the Db2 Big SQL database.
    CALL SYSHADOOP.ATLAS_IMPORT('%', '%', 'admin:admin123');
    You can use NULL in place of the wildcard character (for schema-name) and (for object-name) to specify that only schema metadata is to be imported into Atlas.
    CALL SYSHADOOP.ATLAS_IMPORT(NULL, NULL, 'admin:admin123');