question

mjcarey_178232 avatar image
mjcarey_178232 asked Erick Ramirez commented

Is there a way to specify the order of keys through the Astra Data Loader UI?

If you use the "Upload Data" button on the Astra console to initiate a CSV upload, it's pretty cool, but it it seems like the dialog is insufficient. The ORDER of columns matters when defining keys, but the dialog that one gets after the file has been initially parsed doesn't allow one to control the order of the columns in the partitioning key (which I guess doesn't matter) or the clustering columns (which does matter). Am I missing the way one can reorder columns in this interface?

astra
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered Erick Ramirez commented

There isn't a way to do this through the UI at this point in time. I am going to confirm with the Astra team that this is on the roadmap.

The only workaround I can offer is to define the table schema through the cqlsh console then load the data with the DataStax Bulk Loader. Cheers!

1 comment Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image Erick Ramirez ♦♦ commented ·

@mjcarey_178232 thanks for your patience and sticking with us. The team is going to prioritise this and possibly deploy it some time next week.

I'll keep you posted in the coming days as I get more information. Cheers!

0 Likes 0 ·