S3 dataset orders_copy is not associated to an Athena connection
rwani
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 2 ✭
Getting below error while learning the SQL Query Recipe
An invalid argument has been encountered: S3 dataset orders_copy is not associated to an Athena connection.
Answers
-
denisemalan Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 19 DataikerHi, @rwani
.Sorry to hear you are having trouble! It sounds like the dataset is saved into an S3 connection rather than as an SQL dataset, as required to run a SQL query.
Have you set up a SQL database and connected it to Dataiku? If not, you can do so by completing the tutorial here: https://academy.dataiku.com/path/core-designer/integration-with-sql-databases-1. If you have set up a connection, make sure the Sync recipe is set to save the orders_copy output dataset to the SQL connection.
Best regards,
Denise