Writers

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

• The user can run a code cell with dataset details.

• Run the cell.

• The preview of the dataset appears below.

• The limit function is applied to write the selective rows to the database.

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

• Select a registered DB secret keys from the given filter option under the Secrets tab.

• Add new code cell.

• Get the Secrets keys of the DB in it by using the checkboxes provided for the listed Secret keys.

• Check the authorization of the secret keys by running the cell.

• 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.

• Map the required information of the writer such as Username, Password, Host, Port using the above acquired secret values. Also, mention the database name where you wish to write the data.

• Also provide the authenticated database, table name and data frame to write the chosen data.

• Run the code cell with the modified database details.

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

• The user can validate the specified table from the Dataset Create page and get the data preview.

Please Note: Refer the Data Science Lab Quick Start Flow page to get an overview of the Data Science Lab module in nutshell.