S3 dataset orders_copy is not associated to an Athena connection

[rwani]

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.

[denisemalan]

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