Meet other GoodData developers. Search our knowledge base. Attend live events.

GoodData

Hi all, not sure if this has been asked before, but is there any way of pulling my GoodData database into R for offline analysis?

Hi Benji, you can access Data Warehouse remotely with SQL via the JDBC driver provided by GoodData. Other JDBC drivers cannot be used with Data Warehouse. For more information, see <https://help.gooddata.com/doc/enterprise/en/data-integration/data-preparation-and-distribution/data-preparation-and-distribution-pipeline/data-pipeline-reference/data-warehouse-reference/how-to-set-up-a-connection-to-data-warehouse/connecting-to-data-warehouse-from-sql-client-tools/download-the-jdbc-driver|Download the JDBC Driver>.

Note that exporting data outside ADS (GoodData Platform datawarehouse) is outside the scope of the solution, but you may query it via an SQL client