Quick question: How can I export the actual datase...
# gd-beginners
o
Quick question: How can I export the actual dataset contents from my GoodData workspace, not just the logical model JSON or metadata? I have already tried using the “Export model to JSON” option, but it only gives me the schema, not the underlying data. Is there a recommended way (via API, CLI) to programmatically export the data in each dataset?
j
Hello Ogooluwa, the only way to export the actual data is to first create a table or visualization of the data you would like to export, and then export it.
o
thanks Joseph. I was trying to export the actual SQL code definitions used for each dataset in my GoodData data model. i am looking for a way to extract the actual code via api or CLI from the data model ?
j
If you need to track the SQL definitions, you can either maintain your SQL definitions separately in version control (e.g., in Git) outside of GoodData. Or, if your environment is automated (e.g., via declarative API), store the full declarative
layout/dataSources
or
layout/datasets
configuration files where possible — but note, even these do not expose SQL definitions if they were input manually via UI. More information on SQL datasets can be found HERE
o
thanks very much Joseph!