How to import a data table from SQLQuery2 into Databricks notebook

moski
New Contributor II

Can anyone show me a few commands to import a table, say "mytable2 

From: Microsoft SQL Server 

Into: Databricks Notebook using spark dataframe or at least pandas dataframe

Cheers!