This topic describes how to create tables and import data in the DataWorks console. The bank_data and result_table tables are used in the example.
Prerequisites
Background information
Create the bank_data table
Create the result_table table
Upload a local file to import its data to the bank_data table
- Upload a local text file to import its data to a table in a workspace.
- Use Data Integration to import business data from different data sources to a workspace.
- File format: The file must be in the .txt, .csv, or .log format.
- File size: The size of the file cannot exceed 30 MB.
- Destination object: The destination object can be a partitioned table or a non-partitioned table. The partition key value cannot contain special characters such as ampersands (&) and asterisks (*).
To upload the local file banking.txt to DataWorks, perform the following steps:
Subsequent steps
You have learned how to create tables and import data. You can proceed with the next tutorial. In the next tutorial, you will learn how to create, configure, and commit a workflow and then you can use the DataStudio service to further compute and analyze data in the workspace. For more information, see Create a workflow.