Manual Query Input - Capitalization?

Comments

6 comments

  • Avatar
    Malinda Jepsen

    I had to do something similar and we ended up writing an SSIS package to bring the data into a SQL Server database using SOQL.  I didn't find a way to do it directly in Sisense. I'm hoping I missed something.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Hi Glenn,

    I had a situation where on ODBC preview worked perfectly for simialr case(in a sense that I had to limit number of rows), but then I got errors upon building. Then with support we found a way to edit json config for given type of connector to nominate query patterns. I think this might help in this case, not sure as I have not had problems with Case. I will dig out the location of this file and let you know.

    Regards,

    Michał

    0
    Comment actions Permalink
  • Avatar
    Tri Anthony Situmorang

    Hi Glenn,

    The problem is not the auto capitalization. Metadata (table names, column names, etc) are usually not case sensitive for most databases.

    To enter manual query on Salesforce, DO NOT use brackets. Instead, use double quotation marks (") around the table and column names.

     

    For example:

    SELECT * FROM "Account"
    where "isdeleted" = false

    Note: I tried not using quotes, it worked too. My guess is that if you don't have any space in the table name, it's fine to not use quotes.

    1
    Comment actions Permalink
  • Avatar
    Glenn Hinkley

    Is this special to Salesforce or Sisense?

    0
    Comment actions Permalink
  • Avatar
    Tri Anthony Situmorang

    It is special to Salesforce. Sisense by default will generate SQL with brackets around the metadata, but that's not necessarily the right syntax for all data sources. You should always follow the syntax of the actual data source whenever you use manual query input because the query is going be run directly against that actual data source.

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    Tri Anthony is right, I have not noticed that earlier. Anyway there is no way to influence how Salesforce querry patern looks like. Also Salesforce uses SQLite, so some functions will be different than what MS SQL/MySQL usually use.

    0
    Comment actions Permalink

Please sign in to leave a comment.