Get table names
Preview
The Preview button opens the same preview settings dialog as Table Input (row limit and query timeout in seconds). The JDBC statement timeout is applied only in preview mode from the Hop GUI.
You can set a default for the timeout field with the HOP_QUERY_PREVIEW_TIMEOUT application variable. See Table Input: Preview for the same behaviour details.
Options
| Option | Description |
|---|---|
Transform name | Name of this transform as it appears in the pipeline workspace |
Connection | The connection to use |
Schema name | The schema to use |
Get schema from field | Allows passing a field containing the schema name |
Schema name field | The field containing the schema name |
Include catalogs | Includes catalogs in the output |
Include schemas | Includes schemas in the output |
Include views | Includes views in the output |
Include procedures | Includes procedures in the output |
Include synonyms | Include synonyms in the output |
Add schema in object name | Adds the schema to the object name |
Tablename fieldname | Output field containing the table name |
Object type fieldname | Output field containing the object type (catalog, schema, table, …) |
Is system object fieldname | Output field containing boolean: is object a system object |
Creation SQL fieldname | Output field containing create statement for object |