You can discover the Teradata Database structure using standard Arrow Flight SQL metadata commands
| Command | Description |
|---|---|
| CommandGetCatalogs | Lists catalogs |
| CommandGetDbSchemas | Lists schemas (databases) in the Teradata system |
| CommandGetTables | Lists tables in a schema |
| CommandGetTableTypes | Lists supported table types (table, view, system table, and so on) |
| CommandGetPrimaryKeys | Lists primary keys of a table |
| CommandGetImportedKeys | Lists foreign keys of a table |
| CommandGetExportedKeys | Lists foreign keys referencing a table |
| CommandGetCrossReference | Lists foreign key columns referencing another table |
| CommandGetSqlInfo | Returns SQL dialect and feature information for the Arrow Flight SQL Connector — SERVER Execution Type, including transaction support |
When you request metadata, the planner node retrieves it from the Teradata Database through a JDBC connection.