⚠️ Reports are run against an in-memory sqlite3 database that is populated from the synced entries/assets and content types from Contentful
You must first have a file location of an existing contentful export, using the contentful-cli Run the following steps to generate the export:
contentful login
contentful space export --space-id {spaceId} --environment-id {envId} --export-dir {exportDir} --inlcude-drafts
The file sql/db.schema
has all the data we can build reports from.
Each report lives on a separate SQL query under sql/{reportName}.sql
.
In we want to capture more data from Contentful to build new reports, we can add new tables or add columns to the already existing ones and then create a new report file with the query for it.