I need to Query the Triggered Sends in the data extension folder. Can I do that?

So the Hierarchy is like this.

- Data Extension 
   - Triggered Sends
      -  Parent Folder
        " Name of Data Extension to Query"

I need to write the SQL query to retrieve data from "Name of Data Extension to Query" DE, it gives me error as this DE is not a known data extension. Is there any specific syntax for this ?

  • Can you post your query too please?
    – Timothy
    Dec 2, 2014 at 22:50

1 Answer 1


More than likely the cause of your issue lies in the spaces in the data extension name.

Two resolutions would work here -

1) Preferred Method - Rename this and all data extensions with spaces to either include underscores (or dashes) instead of the space (or completely delete the space). This, while understandably, may cause headaches - but it's best practice when working with data tables to use underscores. It will save headaches in the long run.

Produces this:

SELECT * FROM Name_of_Data_Extension_to_Query

2) Workable - but not as good - Use brackets in your query.

SELECT * FROM [Name of Data Extension to Query]

Either way works, but you can save yourself hassle by naming them with the underscores.

  • 1
    ...as you said it was the problem with the name of my data extension. Thanks a lot for our help.
    – CodeDiva
    Dec 3, 2014 at 16:21
  • Great! Feel free to up vote and mark it answered. Dec 3, 2014 at 16:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .