Synopsis
Tenable Research has identified and responsibly disclosed a critical SQL injection vulnerability in Looker Studio's Linking API. This flaw allowed attackers to craft a malicious URL that could execute arbitrary SQL queries on a victim's BigQuery data source.
The vulnerability exploited the CUSTOM_QUERY and BIG_QUERY connector types within the Linking API. An attacker could construct a specific URL containing a malicious SQL payload in the ds.*.sql parameter. When a victim clicked this link, Looker Studio would automatically create a temporary report, connect to the victim's BigQuery account, and execute the attacker's SQL query. This could lead to a one-click exfiltration of all datasets and tables the victim had access to. The vulnerability could also be used to insert, delete, or modify data, depending on the victim's permissions.
Proof of Concept
- Craft the Linking API link with the victim’s project ID and the SQL injection you wish to run
- Visit the Linking API link that the attacker has crafted as the victim
- Malicious SQL will run in your Big Query, in the context of your user.
Disclosure Timeline
All information within TRA advisories is provided “as is”, without warranty of any kind, including the implied warranties of merchantability and fitness for a particular purpose, and with no guarantee of completeness, accuracy, or timeliness. Individuals and organizations are responsible for assessing the impact of any actual or potential security vulnerability.
Tenable takes product security very seriously. If you believe you have found a vulnerability in one of our products, we ask that you please work with us to quickly resolve it in order to protect customers. Tenable believes in responding quickly to such reports, maintaining communication with researchers, and providing a solution in short order.
For more details on submitting vulnerability information, please see our Vulnerability Reporting Guidelines page.
If you have questions or corrections about this advisory, please email [email protected]
Contact our sales team