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 instructions linked above, add the following to the Additional Params field on the Looker Connection Settings page:
The primary consideration when connecting to Aurora is that in order to leverage PDTs, MySQL replication must be used, not Amazon Aurora’s default replication, which is read-only. The instructions in the MySQL on Amazon RDS documentation page cover how to to make the MySQL replica writable (by setting the
read_only parameter to
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:
For more details on Aurora replication, see this documentation from AWS.
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:
After completing the database configuration, you can connect to the database from Looker using these directions.