Users and Security

Use the dashDB console to create a user with a secure password to connect to Looker. This user should have read access to all tables to be explored in Looker:

PDTs

Use the following command to create a schema:

CREATE SCHEMA looker_scratch

Give the user that will access Looker write access to the schema.

Query Killing

In order to enable query killing, implement the following stored procedure:

CREATE OR REPLACE PROCEDURE LOOKER_CANCEL_ACTIVITY (IN application_handle INTEGER) LANGUAGE SQL BEGIN DECLARE UOW_ID INTEGER; DECLARE ACTIVITY_ID INTEGER; FOR v AS cur1 CURSOR FOR SELECT UOW_ID, ACTIVITY_ID FROM TABLE(SYSPROC.MON_GET_ACTIVITY(application_handle, -1)) DO CALL WLM_CANCEL_ACTIVITY(application_handle, v.uow_id, v.activity_id); END FOR ; END

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, this dialect supports the following Looker features:

Next Steps

After completing the database configuration, you can connect to the database from Looker using these directions.