Writers

The Data Science Lab provides a Writers tab to write the output of the data science experiments.

Check out the illustration on how to use the Writers operation inside a DS Notebook.

Using Writers inside .ipynb file

• Navigate to a code cell with dataset details.

• Run the cell.

• The preview of the dataset appears below.

• Click the Secrets tab to get the registered DB secrets.

• Select the registered DB secret keys from the Secrets tab.

• Add a new code cell.

• Get the Secret keys of the DB using the checkboxes provided for the listed Secret keys.

• Add a new code cell.

• Open the Writers section.

• Use the given checkbox to select a driver type for the writers.

• The code gets added to the newly added cell.

• Provide the Secret values for the required information of the writer such as Username, Password, Host, Port, Database name, table name, and DataFrame.

• Run the code cell with the modified database details.

• A message below states that the DataFrame has been written to the database. The data gets written to the specified database.

Please Note:

• The supported DB writers are MYSQL, MSSQL, Oracle, MongoDB, PostgreSQL, and ClickHouse.

• Refer to the Data Science Lab Quick Start Flow page to get an overview of the Data Science Lab module.