topic Re: Error while installing SAT tool in azure databricks in Data Engineering

Error while installing SAT tool in azure databricks

p-kolluri — Thu, 14 Sep 2023 04:17:15 GMT

Hi, was running the security analysis initializer notebook, am I'm getting an error in cmd 8 for import_dashboard_template notebook. That is notebook no.5. First got an error for cmd 8 for this line "workspacedf = spark.sql("select * from `global_temp`.`all_workspaces` where workspace_id='" + current_workspace + "'" )" . After changing the line to "workspacedf = dfexist.filter(dfexist['workspace_id'] == current_workspace)" the cell worked fine. But now getting an error in cmd 9 for this line "
if resource['endpoint_id'] == json_['sql_warehouse_id']:. "as string indices must be integers". Can someone help me with this. Thank you.

@arun_pamulapati

Re: Error while installing SAT tool in azure databricks

victormarcel09 — Fri, 15 Sep 2023 06:09:34 GMT

Hii,

You can double-check the structure and contents of the json_ object to ensure it contains the expected keys and values. If you still encounter issues, verify the data types and perform necessary type conversions to ensure compatibility.

Re: Error while installing SAT tool in azure databricks

p-kolluri — Fri, 15 Sep 2023 16:14:36 GMT

Also here is the whole code

import requests

DOMAIN = ws.deployment_url

TOKEN = dbutils.secrets.get(json_['workspace_pat_scope'], ws.ws_token)

print(json_['workspace_pat_scope'])

loggr.info(f"Looking for data_source_id for : {json_['sql_warehouse_id']}!")

response = requests.get(

'https://%s/api/2.0/preview/sql/data_sources' % (DOMAIN),

headers={'Authorization': 'Bearer %s' % TOKEN},

json=None,

timeout=60

)

print(response)

resources = json.loads(response.text)

found = False

for resource in resources:

if resource['endpoint_id'] == json_['sql_warehouse_id']:

data_source_id = resource['id']

loggr.info(f"Found data_source_id for : {json_['sql_warehouse_id']}!")

found = True

break

if (found == False😞

dbutils.notebook.exit("The configured SQL Warehouse Endpoint is not found.")

And when trying to run this code