Hi, I'm far from being a SQL expert, so i'm going to try to explain my issue as well as possible : I have a list of IDs (in a csv file for example) and i want to get different information about them t…
Hello ! I'm trying Dataiku Enterprise and trying to connect to a SQL server. I downloaded the driver thanks to https://doc.dataiku.com/dss/latest/installation/jdbc.html My DSS in installed in a Docker…
I have 2 datasets (PostgreSQL) to join: "input1", "input2" and the result should be "output". All datasets are partitioned by date. How to make a FULL OUTER JOIN and keep the partition?
Hello, I'm trying to use a FULL OUTER join in a recipe between 2 MySQL datasets. The option is not available while it appears that it should: "Not available in this mode, use a SQL or Hive database to…
Hello, I'm trying to make some SQL query directly from a python recipe to make some work in python on the results. I followed the advice from this page : http://doc.dataiku.com/dss/latest/api/python/s…
Hello, In order to create a table in oracle, i've created a new dataset. When I fill the filed Table and Schema, it automatically generate this sql statement: CREATE TABLE "dsa"."piv_obj" (...) Wich g…
Hi, I can't read my dataset on mysql, I have the error: Failed to run java.sql.SQLException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure…