Execute databricks notebook form a python source code.

shiv4050
New Contributor

Hello,

I 'm trying to execute databricks notebook form a python source code but getting error.

source code below

------------------

from databricks_api import DatabricksAPI
 
# Create a Databricks API client
api = DatabricksAPI(host='databrick_host', token='access token')
 
# Define the notebook path
notebook_path = '/Users/xyz@abc.com/data_restoration'
print("A")
 
# Create a new run
run = api.jobs.run_now(notebook_path)
print("B)")
 
# Wait for the run to complete
run.wait_for_completion()
 
# Get the run output
output = api.jobs.get_run_output(run.run_id)
 
# Print the output 
for entry in output:
       print(entry['data'])

Output

------

A
 
Traceback (most recent call last):
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 174, in _new_conn
 
  conn = connection.create_connection(
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\util\connection.py", line 72, in create_connection
 
  for res in socket.getaddrinfo(host, port, family, socket.SOCK_STREAM):
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\socket.py", line 954, in getaddrinfo
 
  for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
 
socket.gaierror: [Errno 11001] getaddrinfo failed
 
 
 
During handling of the above exception, another exception occurred:
 
 
 
Traceback (most recent call last):
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 703, in urlopen
 
  httplib_response = self._make_request(
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 386, in _make_request
 
  self._validate_conn(conn)
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connectionpool.py", line 1042, in _validate_conn
 
  conn.connect()
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 363, in connect
 
  self.sock = conn = self._new_conn()
 
 File "C:\Users\sshiv\AppData\Local\Programs\Python\Python39\lib\site-packages\urllib3\connection.py", line 186, in _new_conn
 
  raise NewConnectionError(
 
urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPSConnection object at 0x000001F2B2A244C0>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed
 
 
 
 
 
Process finished with exit code 1