Load data to ClickHouse from CSV file via Python

In this article, we will show you how you can insert your data to ClickHouse from CSV file.

To do that, we will use a python script.

First, download the python script from the command given below.

git clone https://github.com/ChistaDATA/Csv-To-ClickHouse

Open the script file with your editor and edit the following rows with your ClickHouse server information.

conn = clickhouse_driver.Client(host='localhost', port=9000)
 
with open('data.csv', 'r') as f:

query = f"INSERT INTO table ({columns}) VALUES "

Now you can run the script:

python uploadFile.py

or

python3 uploadFile.py

Was this article helpful?

Yes No

Licensed under the Apache License, Version 2.0 (the “License”); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an “AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

ChistaDATA Inc.

Enterprise-class 24*7 ClickHouse Consultative Support and Managed Services

Load data to ClickHouse from CSV file via Python

CHISTADATA IS COMMITTED TO OPEN SOURCE SOFTWARE AND BUILDING HIGH PERFORMANCE COLUMNSTORES

Need Support?

ChistaDATA Inc. Knowledge base is licensed under the Apache License, Version 2.0 (the “License”)

Load data to ClickHouse from CSV file via Python

Related Articles

CHISTADATA IS COMMITTED TO OPEN SOURCE SOFTWARE AND BUILDING HIGH PERFORMANCE COLUMNSTORES

Need Support?

ChistaDATA Inc. Knowledge base is licensed under the Apache License, Version 2.0 (the “License”)