<@U088WCP3B4P> How can I fix the “Transaction is a...
# ask-elementary-ai
f
@kapa.ai How can I fix the “Transaction is aborted due to concurrent update against table” error ? We have different dbt jobs running at the same time right now.
k
A message from kapa.ai
New message text here
f
@kapa.ai What kind of Looker user account do I need to have for Elementary to see the Looker data ,
k
A message from kapa.ai
To connect Looker to Elementary, you need to create a dedicated Looker user account with a custom role and permission set. The required steps are: 1. Create a Permission Set in Looker with the following permissions: -
access_data
-
see_lookml_dashboards
-
see_looks
-
see_user_dashboards
-
see_sql
-
see_lookml
-
develop
2. Create a Role in Looker (e.g., "Elementary Role") and assign it the permission set you just created. 3. Create a dedicated Looker user and assign this user the "Elementary Role". This user will allow Elementary to access the necessary metadata and lineage information in Looker, following the principle of least privilege. You will also need to generate an API key for this user to complete the integration process. For more details, see the official documentation on [Looker integration](https://docs.elementary-data.com/cloud/integrations/bi/looker)<source>https://docs.elementary-data.com/cloud/integrations/bi/looker&lt;/source>.