Security Analysis Tool (SAT) On Azure setup failed with error - [UNRESOLVED_COLUMN.WITHOUT_SUGGESTION] A column or function parameter with name `workspace_status` cannot be resolved.

harry546
New Contributor III

Hi All,

I was trying to setup Security Analysis Tool (SAT) on Azure Databricks cluster. I followed the setup steps motioned over here - 

https://github.com/databricks-industry-solutions/security-analysis-tool/blob/main/docs/setup.md

I started to run "securit_anaysis_initializer" and it got failed with error -

Py4JJavaError: An error occurred while calling o1628._run.

: com.databricks.WorkflowException: com.databricks.NotebookExecutionException: FAILED

Please refer to the docs attached for complete error log.

I navigate to the internal referred notebook "1. list_account_workspaces_to_conf_file" can see an error -

AnalysisException: [UNRESOLVED_COLUMN.WITHOUT_SUGGESTION] A column or function parameter with name `workspace_status` cannot be resolved. ; line 2 pos 18;

'Project ['workspace_id, 'deployment_name AS deployment_url#165, 'workspace_name, 'workspace_status]

Please refer to the docs attached for complete error log.

Then later I navigated to "accounts_bootstrap" notebook and were the views are create for workspace and found that the "No results" and the same is attached.

Can anyone please help me on the same and let me know if any further information required.

Thanks

Harish