Loading data from your local system

You can load data in a delimited format file (CSV or TXT) from your local system into IBM® Db2® Warehouse as a Service. For files less than 500 MB in size, simply drag and drop them onto the Load page in the IBM Db2 Warehouse SaaS web console.

When loading data through the web console, IBM Db2 Warehouse SaaS autodetects and infers column types for your file. You can also configure delimiters and date/time formats for your data.

If you want to load larger CSV files on the gigabyte or terabyte scale into IBM Db2 Warehouse SaaS on IBM Cloud, we recommend using IBM Lift CLI, a free ground-to-cloud data migration tool.