The invention discloses a
data warehouse table
structure generation method and device, a medium and a product, and belongs to the technical field of data warehouses. According to the method, the Excel template configured with multiple pieces of source
database table structure information is obtained, table field definition is automatically analyzed, the
source data type is intelligently mapped and converted into the target
data type according to the source
database type, meanwhile, partition key fields are automatically recognized based on the preset strategy, and finally a complete and accurate
data definition language (DDL) statement is generated. According to the method, remarkable technical breakthrough and value are achieved in practical application, the table building efficiency can be improved by 90% or above,
batch processing of hundreds of tables is supported, and manual errors are reduced by 95% or above; mainstream
database type conversion is comprehensively supported, and various data models such as Dores are adapted; the method has the capabilities of automatic type detection and conversion, intelligent key field selection and partitioning and bucket dividing strategy optimization.