Smartbi Insight, launched by Simi Software Co., Ltd., is a one-stop BI big data analysis platform.
Smartbi Insight can interface with various business databases, data warehouses, and big data platforms, performing data processing, analysis, mining, and visualization. It meets diverse data analysis application needs, such as big data analysis, visualization, exploratory analysis, complex reporting, application sharing, and more.

Prerequisites #

1. Install Smartbi. Follow the installation and deployment instructions according to here.
2. Have a ByteHouse account.

Data Preparation #

Import example data into ByteHouse.

Example Database #

We take the following third-party example data as an example, which contains 5 tables and data.

ddl #

ddl.sql

Unknown size

Data #

categories.csv

Unknown size

orderdetails.csv

Unknown size

products.csv

Unknown size

customers.csv

Unknown size

orders.csv

Unknown size

Import data into ByteHouse #

1. Refer to the above SQL statements to create a database in ByteHouse.
2. Import the above data using the ByteHouse Client tool. For instructions on using the ByteHouse Client tool, see ByteHouse CLI quick start .

bytehouse-cli --host <host> --port 19000 --secure --token <API Key> --send_timeout=3600 --receive_timeout=3600 --database=northwind  -q "INSERT INTO northwind.categories FORMAT CSVWithNames" < categories.csv

bytehouse-cli --host <host> --port 19000 --secure --token <API Key> --send_timeout=3600 --receive_timeout=3600 --database=northwind  -q "INSERT INTO northwind.customers FORMAT CSVWithNames" < customers.csv

bytehouse-cli --host <host> --port 19000 --secure --token <API Key> --send_timeout=3600 --receive_timeout=3600 --database=northwind  -q "INSERT INTO northwind.orderdetails FORMAT CSVWithNames" < orderdetails.csv

bytehouse-cli --host <host> --port 19000 --secure --token <API Key> --send_timeout=3600 --receive_timeout=3600 --database=northwind  -q "INSERT INTO northwind.orders FORMAT CSVWithNames" < orders.csv

bytehouse-cli --host <host> --port 19000 --secure --token <API Key> --send_timeout=3600 --receive_timeout=3600 --database=northwind  -q "INSERT INTO northwind.products FORMAT CSVWithNames" < products.csv