GizmoSQL Integrations & Adapters

1pip install adbc-driver-gizmosql
2
3from adbc_driver_gizmosql import dbapi as gizmosql
4
5with gizmosql.connect("gizmosql://localhost:31337",  # TLS by default
6                      username="gizmosql_user",
7                      password="gizmosql_password",
8                      tls_skip_verify=True,
9                      ) as conn:
10    with conn.cursor() as cur:
11        cur.execute("SELECT n_nationkey, n_name FROM nation LIMIT 5")
12        print(cur.fetch_arrow_table())

Database → New Database Connection → search "GizmoSQL"
Host:     gizmosql.example.com
Port:     31337
Username: analyst
Password: ••••••••
(DBeaver fetches com.gizmodata:gizmosql-jdbc-driver on first connect)

pip install gizmosql-pdf-loader

# .env: GIZMOSQL_HOSTNAME, GIZMOSQL_PORT, GIZMOSQL_USERNAME, GIZMOSQL_PASSWORD,
#       GIZMOSQL_CATALOG (required), GIZMOSQL_SCHEMA (default: pdf_docs)
gizmosql-pdf-loader load --source-dir source_pdf_files
gizmosql-pdf-loader list
gizmosql-pdf-loader search "hydraulic pump relief valves" --ranked --limit 5

# Then from any SQL client:
#   SELECT file_name, page_number, score, snippet
#     FROM my_lake.pdf_docs.search_pages_ranked('hydraulic pump relief valves', top_k := 10);

# python -m pip install dbt-core dbt-gizmosql
my-gizmosql-db:
  target: dev
  outputs:
    dev:
      type: gizmosql
      host: gizmosql.example.com
      port: 31337
      auth_type: external   # browser-based OAuth/SSO
      use_encryption: True
      threads: 2

1# pip install sqlframe-gizmosql
2from sqlframe_gizmosql import GizmoSQLSession
3
4session = GizmoSQLSession.builder \
5    .config("gizmosql.uri", "gizmosql://localhost:31337") \
6    .config("gizmosql.username", "gizmosql_user") \
7    .config("gizmosql.password", "gizmosql_password") \
8    .config("gizmosql.tls_skip_verify", True) \
9    .getOrCreate()
10
11df = session.sql("SELECT 1 as id, 'hello' as message")
12df.show()

1# pip install sqlalchemy-gizmosql-adbc-dialect
2url = URL.create(drivername="gizmosql",
3                 host="localhost",
4                 port=31337,
5                 username=os.getenv("GIZMOSQL_USERNAME", "gizmosql_username"),
6                 password=os.getenv("GIZMOSQL_PASSWORD", "gizmosql_password"),
7                 query={"disableCertificateVerification": "True",
8                        "useEncryption": "True"})
9engine = create_engine(url=url)

1# pip install ibis-gizmosql
2import ibis
3
4con = ibis.gizmosql.connect(host="localhost",
5                            user=os.getenv("GIZMOSQL_USERNAME", "gizmosql_user"),
6                            password=os.getenv("GIZMOSQL_PASSWORD", "gizmosql_password"),
7                            port=31337,
8                            use_encryption=True,
9                            disable_certificate_verification=True)
10print(con.tables)
11t = con.table('lineitem')

1# brew install gizmodata/tap/gizmosql-odbc
2import pyodbc
3conn = pyodbc.connect(
4    "Driver=GizmoSQL ODBC Driver;"
5    "host=localhost;"
6    "port=31337;"
7    "uid=gizmosql_user;"
8    "pwd=gizmosql_password;"
9    "useEncryption=true"
10)
11cursor = conn.cursor()
12cursor.execute("SELECT * FROM my_table LIMIT 10")

SELECT
  order_date AS time,
  SUM(total_price) AS revenue
FROM orders
WHERE $__timeFilter
GROUP BY order_date
ORDER BY time

// npm install @gizmodata/gizmosql-client
import { FlightSQLClient } from "@gizmodata/gizmosql-client";

const client = new FlightSQLClient({
  host: "localhost",
  port: 31337,
  tlsSkipVerify: true,
  username: "gizmosql",
  password: "your-password",
});

// Positional parameters, in placeholder order
const table = await client.execute(
  "SELECT id, name FROM users WHERE id = ? AND name = ?",
  [42, "Alice"]
);
console.log(table.toArray());
await client.close();

pip install flight-sql-websocket-proxy
flight-sql-websocket-proxy-server --help
#   --port INTEGER              Run the websocket server on this port.
#   --tls CERTFILE KEYFILE      Enable transport-level security (TLS/SSL).
#   --database-server-uri TEXT  The URI of the Arrow Flight SQL server.