iframe-proxy | Sunbelt Computer Software

23 lines (16 loc) · 682 Bytes

from databricks import sql
with sql.connect(
    server_hostname=os.getenv("DATABRICKS_SERVER_HOSTNAME"),
    http_path=os.getenv("DATABRICKS_HTTP_PATH"),
    access_token=os.getenv("DATABRICKS_TOKEN"),
) as connection:
    with connection.cursor() as cursor:
        cursor.execute("CREATE TABLE IF NOT EXISTS squares (x int, x_squared int)")
        squares = [(i, i * i) for i in range(100)]
        values = ",".join([f"({x}, {y})" for (x, y) in squares])
        cursor.execute(f"INSERT INTO squares VALUES {values}")
        cursor.execute("SELECT * FROM squares LIMIT 10")
        result = cursor.fetchall()
        for row in result:
            print(row)

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

insert_data.py

Latest commit

History

insert_data.py

File metadata and controls