Skip to main content

Loading Data into Databend

Databend provides a variety of tools and commands that can help you load your data files into a table. Most of them are straightforward, meaning you can load your data with just a single command. Please note that your data files must be in one of the formats supported by Databend. See Input & Output File Formats for a list of supported file formats.

This topic does not cover all of the available data loading methods, but it provides recommendations based on the location where your data files are stored. To find the recommended method and a link to the corresponding details page, toggle the block below:

I want to load staged data files ...
If you have data files in an internal/external stage or the user stage, Databend recommends that you load them using the COPY INTO command. The COPY INTO command is a powerful tool that can load large amounts of data quickly and efficiently.

To learn more about using the COPY INTO command to load data from a stage, check out the Loading from a Stage page. This page includes detailed tutorials that show you how to use the command to load data from a sample file in an internal/external stage or the user stage.
I want to load data files in a bucket ...
If you have data files in a bucket or container on your object storage, such as Amazon S3, Google Cloud Storage, and Microsoft Azure, Databend recommends that you load them using the COPY INTO command. The COPY INTO command is a powerful tool that can load large amounts of data quickly and efficiently.

To learn more about using the COPY INTO command to load data from a bucket or container, check out the Loading from a Bucket page. This page includes a tutorial that shows you how to use the command to load data from a sample file in an Amazon S3 Bucket.
I want to load local data files ...
If you have data files in your local system, Databend recommends that you load them using BendSQL, the Databend native CLI tool, allowing you to establish a connection with Databend and execute queries directly from a CLI window.

To learn more about using BendSQL to load your local data files, check out the Loading from a Local File page. This page includes tutorials that show you how to use the tool to load data from a local sample file.
I want to load remote data files ...
If you have remote data files, Databend recommends that you load them using the COPY INTO command. The COPY INTO command is a powerful tool that can load large amounts of data quickly and efficiently.

To learn more about using the COPY INTO command to load remote data files, check out the Loading from a Remote File page. This page includes a tutorial that shows you how to use the command to load data from a remote sample file.

Databend offers the ability to query and transform your data before and during the loading process. With this feature, you can preview your data using a SELECT statement in Databend before loading it into a table. Moreover, you can customize your data by selecting a subset of columns, changing the column order, and even converting data types when you load with the COPY INTO command. See the topics below for details: