I have created a CH client using a session_id but it seems my temporary tables disappear after a few minutes (whilst I interactively explore in an iPython session).

session_id =  str(uuid.uuid4())
client = clickhouse_connect.get_client(
    host=HOST, 
    port=PORT, 
    username=USERNAME, 
    password=PASSWORD,
    database=DATABASE,
    interface='https' ,
    ca_cert=CA_CERT,
    server_host_name=HOST,
    session_id = session_id,
    # 
    settings={"join_use_nulls": 1}
)

I can create a temporary table like this:

clientmand("""
CREATE TEMPORARY TABLE T
AS SELECT
    uep_id, ...

but after a few minutes (while still in iPython), any queries on this table lead to a "table does not exist" error.