Register Basic Database Mashables

a Presto administrator must configure the data source for this database. Presto administrators should See Manage Data Sources and Drivers for more information.

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. See Default Operations Available for Database Mashables for more information.

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.

2. Enter a unique Name for this mashable information source. Presto uses this name to assign a unique ID. For more information, see What are valid artifact names and IDs?.

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.

Note:

You cannot delete the primary key column.

6. Add metadata for this mashable, such as a description or category. For more information, see Descriptions, Providers, Categories and Tags for Artifacts external.

Presto registers the database mashable and turns this mashable information source on (by default). Then, either:

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.

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. See Automatically Grant Run Permissions to Users and Groups for instructions.

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.