INSERT statement failing on QSACCEL table | Community
Skip to main content
K
kulczz
September 24, 2024

INSERT statement failing on QSACCEL table

  • September 24, 2024
  • 2 replies
  • 887 views

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/reporting-insights-data-model and a very helpful article by @annamalai: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform-blogs/harnessing-data-distiller-s-query-pro-mode-for-chart-authoring/ba-p/673218

 

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

A
Adobe Employee
AnilMalkaniAdobe Employee
Adobe Employee
September 24, 2024

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

    K
    kulczzAuthor
    September 24, 2024

    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;

     

     

      A
      AEPExplorer
      June 18, 2025

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

      K
      kulczzAuthor
      June 18, 2025

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...