IBM DB2 Warehouse on Cloud (dashDB)
You can connect Looker to your DB2 Warehouse on Cloud (dashDB) database.
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
For Looker to support some features, your database dialect must also support them.
In Looker 21.0, 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.