INSERT statement failing on QSACCEL table

[kulczz]

Hi All,

I've encountered an issue with inserting data into a qsaccel table created as a source for custom dashboards.

I've followed the documentation available here: https://experienceleague.adobe.com/en/docs/experience-platform/query/data-distiller/sql-insights/rep... and a very helpful article by @annamalai: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform-blogs/harnessing-data-dis...

I am able to create the table and use it as a source for dashboards (creating it as a result of select query), however for the use-case that I'm working on I would like to be able to insert data directly into the qsaccel table.

When trying to execute the INSERT statement in Query Service, I get the following error: 

Error code: 42809

Description: <MY_TABLE_NAME> is not a QsAccel Table

Thank you in advance for any tips

Kamil

[AnilMalkani]

can you share more detail like the insert you used and the query id.
I think you might need to just fully qualify the table.
please share additional details

[kulczz]

Hi,

thanks for a quick reply.

I am using a fully qualified name in the insert statement:

INSERT INTO monitoring_kk.triggers.triggerscount
select
  triggerName,
  cnt AS ProfileCount,
  refreshDate AS RefreshDate
from
  trigger_counts_test;

[AEPExplorer]

Hi @kulczz ,Curious, did the INSERT work for you? How did you fix your issue?

[kulczz]

Hi @AEPExplorer 

Yes, the insert has worked in the end - I believe the issue was with how I was creating the table.
If you have a look at step 3 in this article, you'll see that the table is first created with null values as placeholders and only after that data is inserted. What I was trying to do was to create the table as a result of data selection. This works and table is getting populated but for some reason you cannot perform inserts on it at a later time.