Loading
Slack製品の問い合わせ先はSalesforce Helpへ統合・変更されます続きを読む
PHPの脆弱性に関する監視状況について 続きを読む

Data 360: Error "table ... does not exist" in Data Explorer or Query Editor

公開日: Nov 27, 2025
説明

Errors in the following format may be observed when attempting to view the records on a Data Cloud object (e.g. Data Model Object, Data Lake Object, Calculated Insight etc.):

In Data Explorer:

42P01: table "[table name]" does not exist DETAIL: line 1, column 207: ... "[field name]" from "[table name]" fetch next 10... ^~~~~~~~~~~~~~~~~~~~~~~~~~ HINT:

In Query Editor:

table "[table name]" does not exist

Try quoting the identifier:..

解決策

This type of error is observed when a user does not have the required access policies assigned in Data Governance.

A user with access to the Data Governance tab within the Data Cloud app, should first check if the default All Data Access Ruleset policy is present:

  • Open the Data Governance tab (Note: if you do not see this tab ensure the tab is not hidden for your user's profile - see Data Cloud: Object Tabs are Missing).
  • Open Policies and then look for a All Data Access Ruleset policy on the Custom Policies list view.

If you do not see this policy, you can follow the steps in Create an Allow All Policy in Data 360 to create a policy that will give users access to all objects in Data 360. If you are using custom policies, then ensure that the user encountering the error has a policy assigned that grants them access to the object you are attempting to view in Data Explorer or Query Editor.

Reach out to Salesforce Support if updating your Data Governance policies does not resolve the error.

ナレッジ記事番号

005232610

 
読み込み中
Salesforce Help | Article