Before ingesting Teradata metadata into Dawiso, prepare your account for authentication by creating a dedicated Teradata user and granting it the necessary permissions.

Dawiso supports the traditional authentication method using credentials to connect. Only read access is required, Dawiso does not modify your data.

Connection prerequisites

  • Your Teradata account has administrator-level privileges

Create new Teradata user

Create a new dedicated user (e.g., dawiso_user) using the following statement:

CREATE USER "dawiso_user" FROM [database] AS PASSWORD = "password";
  • Replace password with a strong password.
  • If you choose a custom user, make sure to replace it in all following statements.

For more information, refer to the official Teradata documentation.

Grant permissions

In the context of the source database from where metadata will be ingested, grant the newly created user minimum required permissions to ingest Teradata metadata using the following statements:

GRANT SELECT ON dbc.DatabasesV TO "dawiso_user";
GRANT SELECT ON dbc.TablesV TO "dawiso_user";
GRANT SELECT ON dbc.ColumnsV TO "dawiso_user";
GRANT SELECT ON dbc.IndicesV TO "dawiso_user";
GRANT SELECT ON dbc.FunctionsV TO "dawiso_user";
GRANT SELECT ON dbc.All_RI_ChildrenV TO "dawiso_user";