Accessing your metastore database

The metadata store for the Data Catalog is by default Apache Derby, however, you can configure your Zetaris Enterprise deployment to access an external relational database e.g. PostgreSQL.

The metadata repository gives metadata information. It also logs a complete auditing trail of queries. To register and connect to this repository through Zetaris, use the following commands:

To Register Metadata Tables

CREATE DATASOURCE derby DESCRIBE BY "Zetaris_Metadata" OPTIONS (
    jdbcdriver "org.apache.derby.jdbc.ClientDriver",
    jdbcurl "jdbc:derby://localhost:1527/../metastore/lightning/lightningMetaStore",
    username "admin" ,
    password "password"
);
REGISTER DATASOURCE TABLES FROM derby


Popular Tables:
-    datasource_relation_schema
-    datasource_relation_schema_tag
-    datasource_relation
-    datasource_relation_tag


Register logs:

CREATE DATASOURCE derby_logs DESCRIBE BY "Zetaris_Metadata_logs" OPTIONS (
    jdbcdriver "org.apache.derby.jdbc.ClientDriver",
    jdbcurl "jdbc:derby://localhost:1527/../metastore/lightning/auditLog",
    username "admin" ,
    password "password"
);
REGISTER DATASOURCE TABLES FROM derby_logs