Publish as a Database (DB)¶
The Publish as a DB function lets you publish your View as a table on Mammoth managed database server. This function eliminates the need of having a dedicated self-hosted Database to host your transformed data.
Quick Start¶
You can publish your current View with just a click. Here’s how:
Go to Exports and Share
Select “Export to database” then “Mammoth managed databse”
Enter a new table name or keep the default
Click apply.
Note
The system only allows unique table names. You will get a prompt to choose a different table name if the database already has a table with the same name.
Once your View is published on the server, you will receive credentials to access the published database.
Further, Publish as a Database will also be recorded as a task at the end of the Data Pipeline.
Supported Options¶
Show credentials: This displays credentials to access the published table.
Regenerate password: Generates a new password. Make sure to re-authenticate connected applications once you do this.
Run now: This option syncs all Pipeline modifications to the published table.
Delete: This removes the Publish as a DB task from the Data Pipeline as well as the table from the database server.
Note
There can be only one Publish to DB in a view.
Users have read-only access to the database and the tables.
Mammoth maintains a table named reference_table in the same database. Mammoth maintains a list of all published views and tables in this. Use this for quick reference of all published views.
For each user, there exists a unique database.