save an editable table on S3

Tanguy
Tanguy Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023 Posts: 124 Neuron

We can sometimes create editable tables in "SQL flows" (e.g. to create mappings between codes and their corresponding meaning).

However, the editable table can not be used by SQL recipes because its type does not conform to the expected format (see below screenshot showing the shaded SQL recipe, at our organization SQL recipes use AWS Athena):

1.jpgNote: SparkSQL recipes do work on editable tables but at the expense of facing Spark's overhead (so one can wait several minutes to synchronize a very small table).

In this case, a workaround is to convert the editable table in parquet, for example by using a sync recipe, so that SQL recipes can now read it (see below screenshot where the SQL recipe is now available):

2.jpg

It would make things simpler if dataiku directly offered the possibility to save the editable table in the desired format (in my case on S3 if I am correct).

6
6 votes

New · Last Updated

Setup Info
    Tags
      Help me…