Infoworks 6.1.3
Knowledge Base Articles

Unity Catalog enabled Environments

  • On Unity Catalog enabled environments, if user sees this error User does not have permission SELECT on any file. SQLSTATE: 42501 which usually occurs when service principal is selected for profile running the job.
  • Then required permission is missing and admin has to provide access by running GRANT SELECT ON ANY FILE TO '<service-principal>'.