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;