clickhouse_connect_quickstart_create_table_insert_query.py

1import clickhouse_connect
2
3# Create a client connection
4# For ClickHouse Cloud, host will be the 'Host' from the console
5# For local ClickHouse, host is usually 'localhost'
6client = clickhouse_connect.get_client(
7    host='localhost',
8    port=8123,
9    username='default',
10    password=''
11)
12
13# Create a table
14client.command('CREATE TABLE IF NOT EXISTS quickstart_test (id UInt32, name String) ENGINE = MergeTree ORDER BY id')
15
16# Insert data using a list of rows
17data = [[1, 'ClickHouse'], [2, 'Python'], [3, 'Quickstart']]
18client.insert('quickstart_test', data, column_names=['id', 'name'])
19
20# Query the data
21result = client.query('SELECT * FROM quickstart_test')
22
23# Iterate through the results
24for row in result.result_rows:
25    print(row)
26
27# Clean up (optional)
28# client.command('DROP TABLE quickstart_test')