Skip to main content

Doorda SDK for access to Hosted Platform

Project description

Doorda Python SDK

GitHub Action GitHub Action PyPI version PyPI pyversions




$ pip install doorda-sdk



  1. Connect to database

    from import client
    conn = client.connect(username="username",
    cursor = conn.cursor()
  2. Execute Queries

    cursor.execute("SELECT * FROM table_name")
    # Returns generator of results
    # Does not put result into memory. Iterates through rows in a streaming fashion.
    for row in cursor.iter_result():
        # Do something with row
    # Fetch all results
    rows = cursor.fetchall()
    # Fetch one results
    rows = cursor.fetchone()
    # Fetch multiple results
    rows = cursor.fetchmany(size=10)
    # Get list of column names
    # Get column names mapped to data types
  3. Simplified Functions

    # List Permissions
    ## Permissions are shown as a hierarchical tree structure
    ### Level 1 = Catalog, Level 2 = Schemas, Level 3 = Table Names
    permissions = cursor.permissions()
    # Check database connection
    results = cursor.is_connected()
    # List all catalogs
    rows = cursor.show_catalogs()
    # List all schemas
    rows = cursor.show_schemas("catalog_name")
    # List all tables
    rows = cursor.show_tables("catalog_name", "schema_name")
    # Get number of rows
    rows = cursor.table_stats(catalog="catalog_name", 

Find out more

To find out more about DoordaHost, head over to

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

doorda_sdk-1.0.11.tar.gz (11.1 kB view hashes)

Uploaded source

Built Distribution

doorda_sdk-1.0.11-py3-none-any.whl (15.6 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page