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.
You can publish your current View with just a click. Here’s how:
Login to your Data Library.
Navigate to the Dataset>View you want to publish.
Click on the “Publish as a DB” button on the taskbar.
A dialog box will appear with the default Data Server (PostgreSQL) and an option to change your Table’s name.
Click Publish to publish your View as a DB.
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 DB will also be recorded as a task at the end of the Data Pipeline.
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.
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.