CData Python Connector for Amazon DynamoDB

Build 25.0.9454

Tables and Views

The connector possesses system tables that are used to discover the tables and views available in the data model. Of these system tables, "sys_tables" and "sys_views" are used to fetch information about the available tables and views respectively:

Tables


import cdata.amazondynamodb as mod
conn = mod.connect("AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;")
cur = conn.cursor()
cmd = "SELECT * FROM sys_tables"
cur.execute(cmd)
rs = cur.fetchall()
for row in rs:
	print(row)

Views


import cdata.amazondynamodb as mod
conn = mod.connect("AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;")
cur = conn.cursor()
cmd = "SELECT * FROM sys_views"
cur.execute(cmd, params)
rs = cur.fetchall()
for row in rs:
	print(row)

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454