Best Practices: Using the Dataiku DSS Python API For Interfacing with SQL Databases

Online Events
Wed, Jul 22, 2020, 11:00 AM (EDT)

About this event

In most companies, SQL databases are a primary source of data for data science projects. The seamless access to a broad range of SQL databases is a key feature of Dataiku DSS. DSS builds on this capability by providing a Python API for interfacing with SQL tables. This functionality is a boon for Data Scientists who use Python to develop and deploy machine learning projects.

Marlan Crosier (Senior Data Scientist, Premera Blue Cross) will share practical suggestions for making effective use of the Python API for interfacing with SQL databases across a number of use cases. The following topics will be covered:

- Reading SQL based data into Python

- Reading large tables using memory efficient practices

- Writing data from Python to SQL tables

- Executing SQL statement from Python

The presentation will be followed by a live exchange for all participants to share feedback, experiences, and best practices. 



Wednesday, Jul 22
11:00 AM - 12:00 PM (EDT)