Skip to main content

INVALID_REFRESH_SELECTION error condition

SQLSTATE: 42000

This error condition has the following derived sub error conditions.

INVALID_IDENTIFIER

The refresh selection parameters specified for this update are invalid because the dataset identifier '<datasetName>' is invalid.

To resolve this issue:

  1. Ensure the dataset exists and the name is correctly spelled.

  2. If the dataset name includes special characters (e.g., - or .), enclose it in backticks.

Example: my-catalog.my.schema.my_table

NO_TABLES_IN_FILE

Unable to refresh tables in file: '<filePath>'.

The file either does not define any tables or defines only views. Refreshing views is not currently supported.

PATH_NOT_FOUND

Unable to refresh tables in file: '<filePath>'.

Please make sure file '<filePath>' is part of this pipeline with tables defined in the file.

SELECTIVE_REFRESH_VIEW_NOT_SUPPORTED

The refresh selection parameters specified for this update are invalid because one of the selected datasets '<viewName>' is a view.

Please only include tables in the refresh selection.

TABLE_NOT_FOUND

The refresh selection parameters specified for this update are invalid because one of the the selected tables '<tableName>' is not part of this pipeline.

Table <tableName> does not exist in the graph.

Was this article helpful?