SQL

Execute

from rtdip_sdk.authentication.azure import DefaultAuth
from rtdip_sdk.connectors import DatabricksSQLConnection
from rtdip_sdk.queries import SQLQueryBuilder

auth = DefaultAuth().authenticate()
token = auth.get_token("2ff814a6-3304-4ab8-85cb-cd0e6f879c1d/.default").token
connection = DatabricksSQLConnection("{server_hostname}", "{http_path}", token)

data = (
    SQLQueryBuilder()
    .get(
        connection=connection, 
        sql_query="SELECT * FROM {tablename_or_path}"
    )
)

print(data)

← Previous Next →

Course Progress

• Introduction
• SDK
  • Authentication
  • Connectors
  • Queries
    • Time Series
    • SQL
    • Weather
    • Exercise
• Power BI
• APIs
• Excel Connector