Other SQL databases

Dataiku DSS can both read and write datasets in SQL databases. You can:

  • Create datasets representing SQL tables (and read and write in them)

  • Create datasets representing the results of a SQL query (and read them)

  • Write code recipes that create datasets using the results of a SQL query on existing SQL datasets. See /code_recipes/sql for more information.

In addition, on most supported databases, Dataiku DSS is able to:

  • Execute Visual recipes directly in-database (ie: for a visual recipe from the database to the database, the data never moves out of the database)

  • Execute Charts directly in-database

For more information on the range of what Dataiku DSS can do with SQL databases, please see DSS and SQL.

Note

You might want to start with our resources on data connections in the Knowledge Base. The rest of this section is reference information.

Dataiku DSS provides full support for many databases and experimental support for others. Click on a link for detailed support information for that database.