Extract data from partition table

Options
dhyadav79
dhyadav79 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 21 ✭✭✭✭

Hi,

I have partition table have 3 partitions and I need to extract data from table without using partition. When I run the query it giving error like Path does not exist in the dataset: '/process_date=20210629...

Could you please help how I can extract data from partition where next table should be normal table.

Thanks

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Options

    Hi,

    You can achieve this using a Sync Recipe in DSS. You can select the Partitions from the input dataset and set the output datasets as not partitioned. When running the recipe the output dataset will contain the desired partions. Below are a few screenshots to illustrate the steps:

    Screenshot 2021-09-07 at 16.33.22.pngScreenshot 2021-09-07 at 16.36.52.png

Setup Info
    Tags
      Help me…