Register Basic Database Mashables
a Presto administrator must configure the data source for this database. Presto administrators should
You can register database mashables in Presto for one table, view or stored procedure. The operations that Presto generates for these mashable information sources depends on configuration defined by your Presto administrator.
Typically, a database mashable includes queries or finders to find records based on any column in the table or view. They may also include operations to insert, update or delete records. Mashables for stored procedures have a single operation that runs that stored procedure.
Important: | Presto administrators have additional features they can use to register database mashables that work with combinations of database resources within a given schema or catalog in one data source. They can also customize the database mashable to fine tune the operations that are available or add custom queries for more complex requirements. Administrators should see Register Custom Database Mashables for more information. |
1. Select Connect > Database in the Presto Hub main menu.
3. Select the Datasource for this mashable.
4. Depending on the type of database, select a Schema, a Catalog or both.
For most types of databases, you select a schema. If information for both fields is available, select both to narrow the list of database assets.
Note: | For MySQL databases, choose the Catalog entry that identifies the name of the database. |
After a few seconds, information for the tables, views and stored procedures in this schema or catalog for this data source are displayed.
5. Choose Table, View or Procedure and then select the specific database table, view or stored procedure that you want to use.
By default, all columns for database tables are included in the database mashable. You can exclude certain columns, if needed:
a. In the list of columns that opens, select the columns that you want to exclude from the database mashable.
b. Click Remove.
Note: | You cannot delete the primary key column. |
7. Click Register.
Presto registers the database mashable and turns this mashable information source on (by default). Then, either:
Grant permissions to run this mashable to other users and groups:
Choose the mashble-wide
Service >> mashable name permissions section to grant run permissions to all operations. Or expand a specific
Operation >> operation name section to grant run permissions for just that operation.
Click on a user or group in the
Search result list to add them to the list of
Principals with permissions.
Save the permissions once the list is complete.
Or skip permissions for now and click
Finish.
To allow other users to work with this mashable, you must grant run permissions at a later time.
Note: | Some groups or users may already be listed as Principals with permissions. These users and groups have been defined by a Presto administrator to grant permission automatically. |
You can open the artifact page for this new mashable to run the mashable, add views, take snapshots, create basic apps based on this mashable, edit the mashable, turn it off or grant permissions to other users to work with it.
