Using Qualified Queries
If you prefer to use fully qualified table names in your SuiteAnalytics Connect queries, make sure that you use exact qualifier values. Inexact qualifier values are those that contain additional spaces or use lowercase characters instead of uppercase characters, or uppercase characters instead of lowercase. Queries that use inexact qualifier values will fail.
To learn exact qualifier values for your account:
-
Run the following query:
select distinct table_qualifier, table_owner from oa_tables where table_owner !='SYSTEM'; -
Make a note of the table_qualifier and table_owner values that are returned. These are the values that should be used in your qualified queries.
The table_qualifier and table_owner values should correspond to the company name and role name for the Account ID and Role ID you use to connect to the SuiteAnalytics Connect service.
For example, if the returned value of table_qualifier is Wolfe Company and the value of table_owner is Administrator, your qualified queries should reference SuiteAnalyitcs Connect tables in the following way:
select * from "Wolfe Company"."Administrator".<table_name>;If this query used an inexact table_qualifier value, such as WolfeCompany or wolfecompany, it would fail to run.
For information about SQL queries, see Query Language Compliance.
For information about using SuiteQL with the NetSuite2.com data source, see Using SuiteQL with the Connect Service.