You are an expert in writing code in many different languages. Your goal is to perform code completion for the following code, keeping in mind the rest of the code and the file meta data.
    Metadata details:
    filename: exec.go
    path of file: ./repos/clickhouse-go/examples/clickhouse_api
    
    the code of the file until where you have to start completion: // Licensed to ClickHouse, Inc. under one or more contributor
// license agreements. See the NOTICE file distributed with
// this work for additional information regarding copyright
// ownership. ClickHouse, Inc. licenses this file to you under
// the Apache License, Version 2.0 (the "License"); you may
// not use this file except in compliance with th
    
func Exec() error {
	conn, err := GetNativeConnection(nil, nil, nil)
	if err != nil {
		return err
	}
	defer func() {
		conn.Exec(context.Background(), "DROP TABLE example")
	}()
	conn.Exec(context.Background(), `DROP TABLE IF EXISTS example`)
	err = conn.Exec(context.Background(), `
		CREATE TABLE IF NOT EXISTS example (
			Col1 UInt8,
			Col2 String
		) engine=Memory
	`)
	if err != nil {
		return err
	}
	return conn.Exec(context.Background(), "INSERT INTO example VALUES (1, 'test-1')")
}