Use this collector to harvest metadata for Presto tables and columns across the enterprise systems and make it searchable and discoverable in data.world.
Important
The Presto collector can be run on-premise using Docker or Jar files.
Note
The latest version of the Collector is 2.300. To view the release notes for this version and all previous versions, please go here.
The collector catalogs the following information.
Object | Information cataloged |
|---|---|
Columns | Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, Foreign), Column size, Column index |
Table | Name, Description, Primary key, Schema |
Views | Name, description |
Schema | Identifier, Name |
Database | Type, Name, Identifier, Server, Port, Environment, JDBC URL |
By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.
Resource page | Relationship |
|---|---|
Table | Columns |
Columns | Table |
Schema | Database that contains Schema, Table that is part of Schema |
Database | Schema contained in Database |
The collector supports username/password authentication to Presto.