Search code examples
kqlkusto-explorer

Kusto malformed string literal

Can anyone suggest what is wrong with below Kusto. I get error as below. I am trying to export data from my External table to a storage account

Error 

 Method 'ParseStringLiteral' invoked with an invalid argument 'literal', details: 'Malformed string literal: '<missing STRINGLITERALX>''

Query(logsKube is my external table name):

.export async compressed to json
  (
    h@"https://azdevstoreforlogs.blob.core.windows.net/exportinglogs;JnAU9secretmUGqNa4/4F8WE+MIWj8z9FQ==",
  )
  <|'logsKube'| limit 10000

New Query as suggested in answer below but get same error:

.export async compressed to json
  (
    h@"https://azdevstoreforlogs.blob.core.windows.net/exportinglogs;YBLLh3FY20tVI6a2fQ==",
  )
  <|external_table('logsKube')| limit 10000
Solution

  • Your query is invalid.

    1

    External table should be referenced as following:

    external_table('logsKube ')

    2
    You have extra comma after the storage URL