Azure stream analytics: number in column name

Filip Van Raemdonck 21 Reputation points
2020-06-19T10:03:59.867+00:00

Hi,

I have a stream analytics job which outputs to azure table storage. Is it possible to do this when I have a column from which the name contains a numerical value?

Regards,

Filip Van Raemdonck

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
354 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2020-06-23T00:05:15.01+00:00

    Hello *anonymous user* ,

    I did checked the storage explorer and if your entity has a numeric value in the name , it does not allow to create that entity . But I think you can use the column alias and get around this issue . Here is the more details with examples .https://video2.skills-academy.com/en-us/stream-analytics-query/select-azure-stream-analytics

    Please do let me know how it goes and if you have any queries .

    Thanks
    Himanshu

    0 comments
  2. Filip Van Raemdonck 21 Reputation points
    2020-06-26T08:33:18.943+00:00

    Yeah I renamed my columns for now, but it's not an ideal solution since we are migrating to stream analytics and such an existing solution which reads the data is using these numerical column names already.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.