Skip to main content
maruboyinap982925
August 23, 2023
Question

DB view associated with CDT but don't have primary Key. We used DB View in a!ExportDataStoreEntityToExcel to extract data into Excel File and getting timeout error.

  • August 23, 2023
  • 3 replies
  • 0 views

DB view associated with CDT but don't have primary Key. We used DB View in a!ExportDataStoreEntityToExcel to extract data(20k Records) into Excel File and getting an timeout Error. Is there any way to apply Composite Key for few columns on CDT to extract data to Excel without errors ? In Appian Best Practices mentioned that there is a way to apply composite key but no example. If anyone knows the solution please replay here. Thank you.

3 replies

mathieud0001
August 23, 2023

Only way to create a composite key to concatenate the fields in question in one field which you make your primary key.

maruboyinap982925
August 23, 2023

Can you explain briefly please?

mathieud0001
August 23, 2023

[View:https://docs.getdbt.com/blog/sql-surrogate-keys]