S3 dataset orders_copy is not associated to an Athena connection

Options
rwani
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
    denisemalan Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 19 Dataiker
    Options

    Hi, @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

Setup Info
    Tags
      Help me…