User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Amazon Aurora

To connect Looker to Amazon Aurora, follow the instructions for connecting to MySQL on Amazon RDS, located on this documentation page.

In addition to the steps in the Amazon RDS instructions, Amazon Aurora may need further setup, depending on your configuration. If you have a redirected read-only endpoint for Amazon Aurora, or if you want to leverage persistent derived tables (PDTs), see the sections below.

Configuring Amazon Aurora with Redirected Read-Only Endpoints

For the typical Amazon Aurora read-only endpoint, the URL contains a -ro element, which Looker will detect and then automatically set the connection’s lookerFailover to false.

However, if your configuration tunnels to your Amazon Aurora read-only endpoint, or if you are using redirects, your URL may not include the -ro element. If your URL doesn’t have the -ro element, go to the Looker Connection Settings page and add the following to the Additional Params field:

lookerFailover=false

Configuring Amazon Aurora for PDTs

In order to leverage persistent derived tables (PDTs) with Aurora, you must use MySQL replication, not Amazon Aurora’s default replication, which is read-only. You must set the read_only parameter to 0 to make the MySQL replica writable, as described on this documentation page.

If you don’t want to grant write access to the database, you can copy and paste the derived table SQL into the sql_table_name parameter of a view file as shown below. This creates a subquery that is used at query time:

view: my_name { sql_table_name: (sql_of_derived_table_goes_here) ;; }

For more details on Aurora replication, see the AWS documentation.

Feature Support

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

In the current Looker release, Amazon Aurora supports the following Looker features:

Next Steps

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

Top